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

1. Question 31: Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT…
2. Question 32: If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?
3. Question 33: Which of the following statements about stored procedures is TRUE?
4. Question 34: Which of the following statements about triggers are TRUE? (Choose two.)
5. Question 35: What type of function is created using the following command? CREATE FUNCTION TAN (X DOUBLE) RETURNS DOUBLE - LANGUAGE SQL - CONTAINS SQL - NO EXTERNAL ACTION…
6. Question 36: Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
7. Question 37: DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibili…
8. Question 38: Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT="˜NPS'
9. Question 39: Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
10. Question 40: Which of the following statements will successfully create a table that scores index data in a different table space than the table data?