You work as a Database Developer for GraySoft Inc. You are designing a database to record information about
potential customers. You create a table named ProductInquiry for the database.
The table is given below:

You want to uniquely identify the product in which a customer is interested. Choose the columns on which a
PRIMARY KEY constraint needs to
be created to accomplish this.

You are the database administrator of a MySQL server that runs on a Windows server. All clients are local
clients. For security, you want to disable connections from the remote clients. Which of the followingsteps will
you take to accomplish the task?

Which of the following statements is true about referential integrity?

Consider the case of an organization having many departments. Each department has a department head
known as senior manager. Several employees are working in a department under the senior manager. Identify
the most appropriate ER-diagram that represents therelationship between department and employees.

Which of the following are DML commands? Each correct answer represents a complete solution.
Choose all that apply.

Which of the following commands can be used to change the authorization type in DB2 9? Each correct
answer represents a complete solution. Choose all that apply.

Smith works as a Database Administrator for DWorldsInc. The management instructs him to plan a database
where identifying the key objects or entities for database management is important. Which of the following
database planning steps will help him to accomplishthe task?

You are a database developer for a database named Customers hosted on a SQL Server 2008 server.
Recently, several customers were deleted from the Customers database. To ensure this is not repeated in
future, you have decided to create a DML trigger toprevent it. What code will create the trigger to meet your
goals? Each correct answer represents a complete solution. Choose all that apply.

JDBC API 2.0 defines five levels of transaction isolation for database concurrency control. Which of the
following is the lowest level of transaction isolation?

Which of the following provides reliable units of work that allow correct recovery from failures and keeps a
database consistent even in cases of system failure?