IBM DB2 10.1 Fundamentals - C2090-610 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which statement is true about an index that is used to support a UNIQUE constraint?

A. It must not contain more than one column. B. It must be defined as UNIQUE WHERE NOT NULL. C. It cannot be used in a referential constraint. D. It must be defined with the UNIQUE attribute.

Discussion 0

Correct Answer: D Vote an answer

Question 2

If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?

A. 8 B. 32 C. 16 D. 4

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which DB2 object is used to provide a logical grouping of other database objects?

A. Index B. Schema C. Alias D. Collection

Discussion 0

Correct Answer: B Vote an answer

Question 4

A table named EMPLOYEE was created as follows:

Which action will prevent unauthorized users from accessing SSN data?

A. Assign the SSN column to a restricted role that only authorized users can access. B. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access. C. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data. D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

Discussion 0

Correct Answer: D Vote an answer

Question 5

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

A. The temporary table is converted to a base table and the data is persistent. B. The temporary table is converted to a base table and the data is deleted. C. The data in the table is deleted and the table is implicitly dropped. D. The data in the table is deleted and the table persists.

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

A. DB2 Connect B. High Availability Disaster Recovery C. Workload Manager D. DB2 pureScale

Discussion 0

Correct Answer: D Vote an answer