DB2 9.7 DBA for Linux UNIX and Windows (000-541) Free Practice Test

Question 1

For which two purposes would you run the db2look tool? (Choose two.)

A. To extract the definition of objects in a database and generate DDL statements to recreate them.

B. To extract the data offline from a given page in a table and store the data in a delimited file.

C. To extract the data from several tables in a database, ready to be imported or loaded.

D. To extract the statistics information for a series of objects in a database and generate UPDATE statements to manually update the statistics

Correct Answer: A,D

Question 2

You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.)

A. The DISCOVERJNST parameter is enabled.

B. The database does not exist.

C. The database has not been cataloged.

D. A network failure exists between the control center client and the database

E. The DISCOVER_DB parameter is disabled.

Correct Answer: B,D,E

Question 3

Which group of memory consumers can be adjusted by the Self-Tuning Memory Manager (STMM)?

A. bufferpools, lock memory, sort memory, package cache

B. buffer pools, database heap, utility heap, lock memory

C. buffer pools, utility heap, sort memory, package cache

D. buffer pools, database heap, utility heap, package cache

Correct Answer: A

Question 4

The SELF_TUNING_MEM database configuration (db cfg) parameter is set to ON.
Which three statements will cause the memory tuner to actively tune memory within the database? (Choose three.)

A. Any two of LOCKLIST, SHEAPTHRES_SHR,PCKCACHESZ are set to AUTOMATIC.

B. At least one buffer pool has its size set to AUTOMATIC.

C. The SORTHEAP db cfg parameter is set to AUTOMATI

D. One dbcfg parameter is set to AUTOMATIC or the size of at least one buffer pool is set to AUTOMATIC, and the DAT ABAS E_M E M O R Y db cfg parameter is set to a numeric value or to AUTOMATIC.

E. MAXLOCKS is set to AUTOMATIC.

Correct Answer: A,C,D

Question 5

If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?

A. A set of dynamic SQL statements that are stored in a file named db2advise.in that is to be executed against a database named SAMPLE

B. A set of dynamic SQL statements that have been captured by the snapshot monitor for a database named SAMPLE.

C. A set of dynamic SQL statements that have been stored in the SYSCAT.WORKLOADS catalog view of a database named SAMPLE.

D. A set of dynamic SQL statements that have been captured by the Query Patroller for a database named SAMPLE.

Correct Answer: B

Question 6

What are three authorization categories in DB2? (Choose three.)

A. System-level

B. Object-level

C. Network-level

D. Database-level

E. Instance-level

Correct Answer: A,B,D

Question 7

A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

A. SYSPR0C.DB2SECURITYU\BEL

B. SYSPR0C.DB2LBACU\BEL

C. SYSIBM.DB2LBACLABEL

D. SYSIBM.DB2SECURITYLABEL

Correct Answer: D

Question 8

Which two SOL statements are explainable statements? (Choose two.)

A. VALUES

B. INSERT

C. CALL

D. FETCH

Correct Answer: A,B

Question 9

Index TAB 1X1 was created as shown below:
CREATE INDEX tablxl ON tab1(col_1)
Which modification to index TAB 1X1 can be performed with an ALTER INDEX statement?

A. ALTER INDEXtablxl PCTFREE 40

B. ALTER INDEXtablxl CLUSTER

C. ALTER INDEXtablxl COMPRESS YES

D. ALTER INDEXtablxl ADD COLUMN (col_2)

Correct Answer: C

Welcome to TestSimulate

IBM DB2 9.7 DBA for Linux UNIX and Windows (000-541) Free Practice Test