IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows Free Practice Exam Questions

48 real IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows exam questions with answers and AI explanations. IBM certification prep — page 2 of 5.

1. Question 11: Which of the following is TRUE about indexes on column organized tables?
2. Question 12: How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
3. Question 13: 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…
4. Question 14: BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)
5. Question 15: Which operation typically requires a Share (S) lock?
6. Question 16: What of the following is TRUE about triggers?
7. Question 17: What is the purpose of a role?
8. Question 18: Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
9. Question 19: Given the following statement: DECLARE GLOBAL TEMPORARY TABLE TEMP1 ( ID INTEGER NOT NULL, ITEM CHAR(30), AMOUNT DECIMAL (10,2) ON COMMIT DELETE ROWS NOT LOGGE…
10. Question 20: What is the primary use case for creating an index with the RANDOM option on a table?