1.
Which SQL data type CANNOT be used to store XML indexed values?
2.
Which table space is NOT created by default when the CREATE DATABASE command is executed?
3.
When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?
4.
Which statement is true about Insert Time Clustering (ITC) tables?
5.
Which statement regarding compression for temporary tables is true?
6.
Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?
7.
If the following command is executed: CREATE DATABASE sample RESTRICTIVE Which statement is true?
8.
Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?
9.
Which command is used to import connectivity configuration information from a file known as a configuration profile?
10.
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?