Ready to Pass Your Certification Test

What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

Which DB2 Explain Facility tool uses the Explain tables to display access plain information?

Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)

If the following SQL statements are executed:How many rows will be added to the DEPARTMENT table?

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

Given the following:What will be the result of the following SQL statement?INSERT INTO v3 (col1) values (30);