Which SQL/XML publishing function can be used toconvert XML data into other formats, including other XML schemas?
Answer : D
Which High Availability Disaster Recovery (HADR)synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?
Answer : D
A user with SYSADM authority executes the following commands at host SERVER1:
Answer : D
Explanation:
QUESTIONNO: 23 -
Which registry variable is used to enable transparent Lightweight Directory Access Protocol
(LDAP)?
A. DB2LDAP -
B. DB2AUTH -
C. CLNT_PW_PLUGIN -
D. SRVCON_PW_PLUGIN -
Answer: B -
How can you remove all effects of compression from an index?
Answer : C
Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or
SECADM authority to other users, groups, or roles?
Answer : D
Whichtype of table space can be associated with only one storage group?
Answer : A
If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL
What willhappen?
Answer : B
What authority is required to grant a user ACCESSCTRL authority?
Answer : C
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?
Answer : B
Which command will enableautomatic reorg on a database?
Answer : D
A table named CUSTOMER and an index named CUST_IDX were created as follows:
Answer : C
Which registry variable should be used tospecify that 20 percent of each index page is to be left as as free space when building any index in any database?
Answer : C
What authority must be held to create a trusted context?
Answer : C
What are two types of check options that can be used to create views? (Choose two.)
Answer : A,E
Which statement about triggers is FALSE?
Answer : D