IBM C2090-610 - DB2 10.1 Fundamentals Exam
Page: 3 / 28
Total 136 questions
Question #11 (Topic: Topic 1)
What is the purpose of a role?
A. To define exactly what a specific user can do within a particular database once they have been authenticated.
B. To group a collection of privileges together so that theycan be simultaneously granted to and revoked from multiple users.
C. To establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server.
D. To group a collection of users together so that theycan be simultaneously granted and revoked specific authorities and privileges.
Answer: B
Question #12 (Topic: Topic 1)
What is used in conjunctionwith a foreign key to define a relationship between two tables?
A. Primary key
B. Partitioning key
C. Check constraint
D. Unique constraint
Answer: A
Question #13 (Topic: Topic 1)
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?
unexpectedly,what happens to the temporary table and any data stored in it?
A. The data in the table is deleted and the table persists.
B. The data in the table is deleted and the table is implicitly dropped.
C. The temporary table is converted to a base table and the data is deleted.
D. The temporary table is converted to a base table and the data is persistent.
Answer: B
Question #14 (Topic: Topic 1)
Which type of constraint can be used to ensure that an INTEGER column in a table will
never be assigned more than one record that contains a NULL value?
never be assigned more than one record that contains a NULL value?
A. Unique constraint
B. Primary key constraint
C. Informational constraint
D. Column default constraint
Answer: A
Question #15 (Topic: Topic 1)
When a COMMIT statement is executed, what happens?
A. All locks held on the database are automatically released.
B. Data stored in global temporary tables is automatically deleted.
C. Open cursors defined WITH HOLD are closed, but their data is retained.
D. The current transaction is terminated and a new transaction boundary is started.
Answer: D
