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=ORA
B. db2set DB2_COMPATIBILITY_VECTOR=
C. db2set DB2_COMPATIBILITY_VECTOR=DB2
D. db2set DB2_COMPATIBILITY_VECTOR_ORACLE=OFF
正解:B
質問 2:
A DBA sets the AUTO_DEL_REC_OBJ database configuration parameter to ON. When the PRUNE HISTORY command is executed with the AND DELETE option specified, what will occur?
A. Entries will remain in the recovery history file; backup images and load copy images will be deleted.
B. Entries will be removed from the recovery history file; physical log files, backup images, and load copy images will be removed.
C. Entries will remain in the recovery history file; physical log files, backup images, and load copy images will be deleted.
D. Entries will be removed from the recovery history file; physical log files, backup images, and load copy images will not be removed.
正解:B
質問 3:
Which of the following statements will load XML data with white spaces removed into the table DB2USER.T1?
A. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLPARSE STRIP WHITESPACE XMLVALIDATE USING SCHEMA s1.schema_a INSERT INTO db2user.t1
B. LOAD FROM data1.del OF DEL XML FROM /home/user/xml SKIP WHITESPACE XMLVALIDATE USING SCHEMA s1.schema_a INSERT INTO db2user.t1
C. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLPARSE SKIP WHITESPACE XMLVALIDATE USING SCHEMA s1.schema_a INSERT INTO db2user.t1
D. LOAD FROM data1.del OF DEL XML FROM /home/user/xml XMLDATA STRIP WHITESPACE XMLVALIDATE USING SCHEMA s1.schema_a INSERT INTO db2user.t1
正解:A
質問 4:
Click on the Exhibit button Given the following DDL statements:
If COL2 contains XML documents similar to the scenario, what is the end result of the CREATE INDEX statement?
A. An error will be returned because it is not possible to create an index for an XML column like COL2
B. TBSP11 and TBSP12 will each contain one local index for XML_INDEX since the local indexes will physically reside in the same table spaceas the related data.
C. A non-partitioned index will be created in table space TBSP21 since the INDEX IN clause of the table definition is ignored and XML_INDEX willautomatically be created within the first index partition listed in the create table statement.
D. A non-partitioned index will be created in the INDEX_TS table space for XML_INDEX.
正解:D
質問 5:
Given the following GRANT commands:
Assuming that user BOB belongs to the group STAFF and STAFF has no other privileges aside from what is defined above, what is the highest level of privilege that BOB has on the database?
A. ACCESSCTRL
B. CONNECT
C. DATAACCESS
D. DBADM
正解:C
質問 6:
Which two database manager configuration parameters were added to support encryption? (Choose two.)
A. SSL_CLNT_KEYDB
B. SSL_CLIENT_KEYDB
C. SSL_CLNT_STASH
D. SSL_CLIENT_STASH
E. SSL_CLIENT_KEYSTASH
正解:A,C
質問 7:
If table space TS is created as follows: CREATE TABLESPACE ts MANAGED BY DATABASE USING (FILE '/data.dat' 12 M); If table space TS contains 4 MB of data and the hight water mark is at 6 MB, and the following statements are executed: ALTER TABLESPACE ts LOWER HIGH WATER MARK; ALTER TABLESPACE ts REDUCE (ALL CONTAINERS 5 M); What are the expected results?
A. The high water mark for all containers used for table space TS is lowered by 5 MB.
B. The size of all containers is only reduced by 5 MB if the high water mark is lowered.
C. The high water mark for table space TS is lowered and the size of all containers is reduced by 5 MB.
D. The high water mark for all containers used by table space TS is only lowered if the size of all containers can be reduced by 5 MB.
正解:C
質問 8:
Which two are valid BASED UPON CONNECTION attributes for a trusted context? (Choose two.)
A. Data stream encryption
B. Application program name
C. System authorization id
D. Database role
E. Date and time
正解:A,C