Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows (A2090-611) Free Practice Test

Question 1

By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

A. Reorganize the table to cluster its index according to that query plan.

B. Drop and recreate the index.

C. Reorganize the table to cluster its data according to that index.

D. Drop and reload the table.

Correct Answer: C

Question 2

Which statement about primary keys is true?

A. A table can have multiple primary keys.

B. A primary key accepts one, and only one, NULL value.

C. A unique index, with matching columns of the primary key, must be created before a primary key can be created.

D. A unique bidirectional index is automatically created for the columns of the primary key, if an appropriate unique index does not already exist.

Correct Answer: D

Question 3

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?

A. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.

B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.

C. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.

D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.

Correct Answer: B

Question 4

Table TAB1 was created as follows:

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compression?

A. CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES;

B. CREATE INDEX tab1_idx ON tab1(col1); REORG INDEX tab1_idx FOR TABLE tab1;

C. CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES; REORG INDEX tab1_idx FOR TABLE tab1;

D. CREATE INDEX tab1_idx ON tab1(col1);

Correct Answer: D

Question 5

Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?

A. XSLPARSE

B. XSLELEMENT

C. XSLTRANSFORM

D. XSLCONVERT

Correct Answer: C

Question 6

If you are running DB2 in clustered environment, what utility should you use to get the status of cluster?

A. db2clust

B. db2haicu

C. db2istat

D. db2hastat

Correct Answer: B

Question 7

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?

A. HSJOIN

B. IXSCAN

C. NLJOIN

D. TBSCAN

Correct Answer: B

Question 8

What authority is required to grant a user ACCESSCTRL authority?

A. SECADM

B. SQLADM

C. DBADM

D. DATAACCESS

Correct Answer: A

Question 9

A table named SALES was created as follows:

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

A. Associate the SEC_POLICY security policy with the SALES table.

B. Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

C. Add a column with the DB2SECURITYLABEL data type to the SALES table.

D. Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.

Correct Answer: B

Question 10

Which statement about Binary XML is FALSE?

A. Binary XML format is only used for data transmission.

B. Binary XML data refers to data that is in the XDBX format.

C. Only textual XML data format is supported by Binary XML.

D. The binary format provides a faster way to transmit and receive XML data.

Correct Answer: C

Welcome to TestSimulate

IBM Assessment: DB2 10.1 DBA for Linux, UNIX, and Windows (A2090-611) Free Practice Test