000-614 by IBM Actual Free Exam Questions And Answers

Question 1

Which category must be enabled before db2audit will record the creation of new buffer pools?

A. OBJMAINT

B. OBJCREATE

C. SECMAINT

D. CHECKING

Discussion 0

Correct Answer: A Vote an answer

Question 2

A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows:

What can be done to improve the performance of a query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?

A. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in theREPL_SALES table, and collect statistics on REPL_SALES table.

B. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.

C. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID.

D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in theREPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which statement about partitioned indexes is FALSE?

A. Each index partition contains references only to data in its corresponding data partition.

B. A partitioned index is made up of a set of index partitions, each of which contains the index entries for a single data partition

C. When attaching new partitions, the SET INTEGRITY statement must be run before data in the newly attached partition will be reflected in the corresponding partition index.

D. Both system- and user-generated indexes can be partitioned.

Discussion 0

Correct Answer: C Vote an answer

Question 4

Which statement about compression dictionaries is FALSE?

A. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

B. Table-level dictionaries are stored in hidden rows within the table.

C. Page-level dictionaries are automatically created or recreated by the database manager
as pages are filled.

D. Page-level dictionaries are stored in hidden rows within the table.

Discussion 0

Correct Answer: A Vote an answer

Question 5

The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?

A. CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER

B. CREATE INDEX bonus_salary_idx ON employee (bonus, salary)

C. CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER

D. CREATE INDEX salary_bonus_idx ON employee (salary, bonus)

Discussion 0

Correct Answer: C Vote an answer

Question 6

What statement regarding Asynchronous index cleanup (AIC) is correct?

A. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

B. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).

C. AIC activates a newly attached partition after the index entries have been synchronized.

D. AIC removes all invalid index entries that refer to the attached partitions.

Discussion 0

Correct Answer: A Vote an answer

Question 7

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)

A. MAXLOCKS

B. LOCKLIST

C. MAXAGENTS

D. MAXAPPLS

E. LOCKTIMEOUT

Discussion 0

Correct Answer: A,B Vote an answer

Question 8

The following statement was used to create a table space named TBSP1 in a non-partitioned database:

Which statement(s) will successfully lower the high water mark in table space TBSP1 and return unused storage space to the operating system?

A. ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8); ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK;

B. ALTER TABLESPACE tbsp1 REDUCE MAX

C. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK

D. ALTER TABLESPACE tbsp1 LOWER HIGH WATER MARK; ALTER TABLESPACE tbsp1 REDUCE (ALL CONTAINERS 8);

Discussion 0

Correct Answer: D Vote an answer

Question 9

The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement will create an index for optimal query performance and ensure uniqueness of the SALES_ID column?

A. CREATE UNIQUE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

B. CREATE INDEX sales_idx ON sales (sales_id) INCLUDE (sales_date, sales_person)

C. CREATE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

D. CREATE UNIQUE INDEX sales_idx ON sales (sales_id, sales_date, sales_person)

Discussion 0

Correct Answer: A Vote an answer

IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows - 000-614 Exam Practice Test

Contact Us

Useful Links

Latest Updated