IBM DB2 11.1 Fundamentals for LUW - C2090-616 Exam Practice Test
The following statements are executed:
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A;
GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B;
GRANT ROLE role A to USER db2inst3;
GRANT ROLE role B to USER db2inst3;
Which of the following is TRUE if this statement is executed later?
REVOKE ROLE roleB FROM USER db2inst3;
Correct Answer: D
Vote an answer
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?
Correct Answer: A
Vote an answer
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?
Which of the following editions would be best meet the described needs?
Correct Answer: D
Vote an answer
Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?
Correct Answer: A
Vote an answer
Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?
Correct Answer: A
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
What is the primary use case for creating an index with the RANDOM option on a table?
Correct Answer: D
Vote an answer