Online Access Free C2090-546 Practice Test

Which of the following is possible using pureXML feature in partitioned database environment?

• A.Using LOAD command with ANYORDER file type and the ALL_PARTITIONS modifier when loading XML data.
• B.Using LOAD command with CURSOR file type and PARTITION_ONLY mode when loading XML data.
• C.Using LOAD command with the ANYORDER modifier when loading XML data.
• D.Using LOAD command with CURSOR file type and LOAD_ONLY mode when loading XML data.

Index INDEX1 has been created as follows: CREATE INDEX index1 ON table_x (cola) Which of the following actions can be done through an ALTER INDEX statement?

• A.Change the PCTFREE specification.
• B.Make the COMPRESS attribute YES or NO.
• C.Make this index the clustering index.
• D.Add a column to the index key.

What DB2 feature must NOT be activated in order to enable Secure Sockets Layer (SSL) support?

• A.High Availability Disaster Recovery (HADR)
• B.Kerberos Authentication
• C.Work Load Manager (WLM)
• D.Connection Concentrator

A DB2 9.7 database has been enabled for Oracle compatibility. What is the command to disable all compatibility features?

• A.db2set DB2_COMPATIBILITY_VECTOR=
• B.db2set DB2_COMPATIBILITY_VECTOR=DB2
• C.db2set DB2_COMPATIBILITY_VECTOR_ORACLE=OFF
• D.db2set DB2_COMPATIBILITY_VECTOR=ORA

User USER1 is a member of the SYSADM group for instance INST1 in DB2 9.7. Database DB_1 was just created within INST1 by user USER2. What additional authorities must be directly granted to USER1 in order for USER1 to retain the same privileges they would have had if database DB_1 had been created with DB2 9.5 by USER2?

• A.DBADM, DATAACCESS
• B.DBADM, SECADM, ACCESSCTRL
• C.DBADM, DATAACCESS, ACCESSCTRL
• D.SECADM, DATAACCESS, ACCESSCTRL