DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (000-546) Free Practice Test

Question 1

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 be removed from the recovery history file; physical log files, backup images, and load copy images will not be removed.

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; backup images and load copy images will be deleted.

D. Entries will remain in the recovery history file; physical log files, backup images, and load copy images will be deleted.

Correct Answer: B

Question 2

Which function/stored procedure CANNOT be used to view audit facility data?

A. SYSPROC.AUDIT_AUTH

B. SYSPROC.AUDIT_DELIM_EXTRACT

C. SYSPROAUDIT_LIST_LOGS

D. SYSPROC.AUDIT_ARCHIVE

Correct Answer: A

Question 3

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. 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.

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 the INDEX_TS table space for XML_INDEX.

D. An error will be returned because it is not possible to create an index for an XML column like COL2

Correct Answer: C

Question 4

When storing XML data in a DB2 database, which statement is valid?

A. A table with an XML column can be defined in a non-Unicode database but the database must be converted to Unicode before the XML columns can be used.

B. A table with an XML column can be defined in a non-Unicode database but the table containing the XML column will be stored in Unicode.

C. A table with an XML column can only be defined in a Unicode database.

D. A table with an XML column can be defined in a non-Unicode database.

Correct Answer: D

Question 5

Table TAB_A and index TABA_IDX were created by executing these SQL statements:

If this SQL statement is executed after 100,000 records have been inserted into table TAB_A:
ALTER INDEX taba_idx COMPRESS NO;
Which statement correctly describes what will happen to index TABA_IDX?

A. The index will be uncompressed immediately.

B. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO and both the table and the index have been REORGed.

C. The index will remain compressed until it is REORGed.

D. The index will remain compressed until the COMPRESS attribute for table TAB_A has been set to NO.

Correct Answer: C

Question 6

Regardless of the value set for the mon_obj_metrics parameter, data is always collected for monitor elements reported by which of the two following table functions? (Choose two.)

A. MON_GET_TABLESPACE

B. MON_GET_BUFFERPOOL

C. MON_GET_TABLE

D. MON_GET_CONTAINER

E. MON_GET_INDEX

Correct Answer: C,E

Question 7

Which SQL statement will archive the audit log for the connected database?

A. SELECT * FROM TABLE(SYSPROAUDIT_ARCHIVE(NULL, NULL)) AS t1

B. CALL SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)

C. SELECT * FROM TABLE(SYSPROC.AUDIT_ARCHIVE_LOG(' ', -1)) AS t1

D. CALL SYSPROC.AUDIT_ARCHIVE(NULL, NULL)

Correct Answer: D

Question 8

Which two are valid BASED UPON CONNECTION attributes for a trusted context? (Choose two.)

A. Application program name

B. Database role

C. Date and time

D. Data stream encryption

E. System authorization id

Correct Answer: D,E

Welcome to TestSimulate

IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade (000-546) Free Practice Test