IBM DB2 10.1 DBA for Linux, UNIX, and Windows - 000-611 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

When a table space is moved to a new storage group, what action will occur for the containers in the old storage group?

A. They are automatically moved to the new table space. B. They are marked as "Dropped Pending." C. They are automatically dropped. D. They are marked as "Move Pending."

Discussion 0

Correct Answer: B Vote an answer

Question 2

If the following statement is executed:

What indexes will be created for table TAB1?

A. 1 dimension-block index and 3 composite-block indexes B. 3 dimension-block indexes and 1 composite-block index C. 3 dimension-block indexes and 3 composite-block indexes D. 1 dimension-block index and 1 composite-block index

Discussion 0

Correct Answer: B Vote an answer

Question 3

The following statement is run:

Which statement about the ACCT_BALANCE column is true?

A. Values stored in the ACCT_BALANCE column are visible to all users. B. Values stored in the ACCT_BALANCE column are not visible to any user. C. Values stored in the ACCT_BALANCE column are only visible to users with the ACCOUNTING role. D. Values stored in the ACCT_BALANCE column are not visible to users with the ACCOUNTING role.

Discussion 0

Correct Answer: A Vote an answer

Question 4

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

A. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED B. ALTER TABLE mytab CHECK (COL IS VALIDATED) C. SET INTEGRITY FOR mytab IMMEDIATE CHECKED D. ALTER TABLE mytab ALLOW READ ACCESS;
SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;

Discussion 0

Correct Answer: C Vote an answer

Question 5

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?

A. RESTORE DATABASE B. RESTART DATABASE C. ROLLFORWARD DATABASE D. RESTORE TABLESPACE

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which SQL data type CANNOT be used to store XML indexed values?

A. REAL B. INTEGER C. DECIMAL D. DOUBLE

Discussion 0

Correct Answer: A Vote an answer

Question 7

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

A. To terminate a failed INGEST command. B. To restart a failed INGEST command from the beginning. C. To restart a failed INGEST command from the last commit point. D. To clean up the log records of a failed INGEST command.

Discussion 0

Correct Answer: C Vote an answer

Question 8

Which statement about referential constraints is true?

A. A referential constraint can be defined on both tables and views. B. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables. C. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query. D. A referential constraint can be defined against a catalog table.

Discussion 0

Correct Answer: B Vote an answer

Question 9

Which statement regarding snapshot administrative views and snapshot monitor table functions is true?

A. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition. B. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions. C. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions. D. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.

Discussion 0

Correct Answer: C Vote an answer