Which command will enable automatic reorg on a database?

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

Which registry variable should be used to specify that 20 percent of each index page is to be left as as free
space when building any index in any database?

Which statement about triggers is FALSE?

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ
ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

Which statement about primary keys is true?

Which statement about referential constraints is true?

What are two types of check options that can be used to create views? (Choose two.)

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL
What will happen?