IBM Certified Database Administrator - DB2 10 for z/OS (000-612) Free Practice Test

Question 1

For monitoring space growth over time, which statistics should NOT be considered?

A. SYSIBM.SYSTABLEPART_HIST
CARDF, SPACEF
SYSIBM.SYSINDEXPART_HIST
CARDF, SPACEF

B. SYSIBM.SYSTABLESPACESTATS
SPACE
SYSIBM.SYSINDEXSPACESTATS
SPACE

C. SYSIBM.SYSTABLEPART
CARDF, SPACEF
SYSIBM.SYSINDEXPART
CARDF, SPACEF

D. SYSIBM.SYSTABLESPACE
DSSIZE, AVGROWLEN
SYSIBM.SYSINDEXES
PIECESIZE, AVGKEYLEN

Correct Answer: D

Question 2

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATETABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on COL1 on TB1?

A. ALTER TABLESPACE TS1
MAXPARTITIONS 15;

B. CREATE INDEX IX1 ON TB1
(COL1);

C. REORG TABLESPACE TS1;

D. COMMIT;

Correct Answer: B

Question 3

Which of the following does NOT make a view a read-only view?

A. Any FROM clause, after the first, identifies more than one table or view, or identifies a table function, a nested table expression, or a common table expression.

B. The outer fullselect contains a GROUP BY clause.

C. The first SELECT clause specifies the keyword DISTINCT.

D. The only table referenced is asystem maintained temporal table and a period- specification is specified.

Correct Answer: A

Question 4

What trace class will show deadlock information?

A. Performance class 8.

B. Accounting class 1.

C. Audit class 3.

D. Statistic class 3.

Correct Answer: D

Question 5

Which of the following types of table spaces allow multiple tables?

A. Segmented

B. Partition-by-growth

C. Partition-by-range

D. LOB table space

Correct Answer: A

Question 6

The application will be handling a large volume of input data that will need to be added to or update 4 differenttables. On average, there will be 50 million input records daily. To ensure that the application process to SQL INSERT and SQL UPDATE(or SQL MERGE) delivers a high level of availability to the tables involved in this application process, what is a key component of the application coding?

A. Execute the SQL INSERT before the SQL UPDATE.

B. Run a QUIESCE utility before the process starts.

C. Provide an effective commit / restart process.

D. Issue a LOCK TABLE for all 4 tables.

Correct Answer: C

Question 7

What is the maximum levels of backup that DB2 plan stability can support?

A. 4

B. 3

C. 1

D. 2

Correct Answer: B

Question 8

You want to ALTER a table space specifying MAXPARTITIONS 256. For which table space type does the ALTER fail?

A. Classic partitioned table space with one table.

B. Segmented table space withone table.

C. Partitioned-by-growth table space with one table.

D. Simple table space with one table.

Correct Answer: A

Question 9

When is a merge scan join a well performing access path?

A. When the query references at least two dimensions and the STARJOIN subsystem parameter is 1.

B. When the number of qualifying rows of the inner and outer table are both large.

C. When the number of rows in the outer table is small and the number of pages accessed in the inner table is small.

D. When the matching columns of the inner table are in a non-clustering index or the outer table has duplicatequalifying rows.

Correct Answer: B

Question 10

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired.
To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

A. SYSIBM.SYSCOPY

B. SYSIBM.SYSSTATS

C. SYSIBM.SYSTABLESPACESTATS

D. SYSIBM.SYSTABLES

Correct Answer: C

Welcome to TestSimulate

IBM Certified Database Administrator - DB2 10 for z/OS (000-612) Free Practice Test