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 1 of 5.

1. Question 1: Below are the SQL statements a DBA is planning to execute on a database: CREATE TABLE t1 (name VARCHAR (1)); INSERT INTO t1 VALUES ("˜A'), ("˜B'), ("˜C'), ("˜D…
2. Question 2: The DDL statement is used to create table T1: CREATE TABLEt1 ( c1 INTEGER, c2 INTEGER NOT NULL, c1 DECIMAL(11,2), c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP )…
3. Question 3: Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
4. Question 4: Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?
5. Question 5: 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…
6. Question 6: Which three facilities are used to control authorization in DB2?
7. Question 7: Which database object can be locked explicitly?
8. Question 8: What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuser
9. Question 9: Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
10. Question 10: Which edition of DB2 LUW has been discontinued in v11.1?