Assessment: DB2 9.7 DBA for Linux UNIX and Windows

Question 1

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. SYSIBM.DB2SECURITYLABEL

B. SYSIBM.DB2LBACLABEL

C. SYSPROC.DB2LBACU\BEL

D. SYSPROC.DB2SECURITYU\BEL

Correct Answer: A

Question 2

A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?

A. Executes the first SOL statement in the workload file 100 times.

B. Executes an index analysis for the first SQL statement in the workload file 100 times.

C. Executes both SQL statements in the workload file 100 times.

D. Executes up to 100 combinations of optimizations for both SQL statements in the workload file

Correct Answer: C

Question 3

Which command will reorg all indexes for a table named TABA?

A. REORG INDEXES FORtaba

B. REORG TABLEtaba AND INDEXES ALL

C. REORG INDEXES ALL FOR TABLEtaba

D. REORG TABLEtaba INDEXES INPLACE

Correct Answer: C

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. The SORTHEAP db cfg parameter is set to AUTOMATI

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

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

D. MAXLOCKS is set to AUTOMATIC.

E. 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.

Correct Answer: A,C,E

Question 5

A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)

A. Existing SQL procedures must be dropped and re-created in the new database before they can be used

B. Incremental backups are not allowed until a non-incremental backup is taken.

C. Incremental backup images for the original database can be used to restore the new database.

D. Existing packages will be copied to the new database and can be used immediately.

Correct Answer: A,B

Question 6

You are running a LOAD utility and have not provided an exception table. What will happen if duplicates for a unique key get Inserted during the LOAD phase due to duplicates in the input file?

A. LOAD will complete but the table being loaded will be placed in SET INTEGRITY PENDING state

B. LOAD will fail and generate an error message.

C. LOAD will create the exception table.

D. LOAD will eliminate the duplicate rows from the table and give a warning message.

Correct Answer: D

Question 7

For which two events is it recommended to execute RUNSTATS? (Choose two.)

A. When a table is created.

B. When LOAD with STATISTICS has been run.

C. When a table is altered by adding new columns.

D. When row compression has been enabled.

Correct Answer: B,D

IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows - A2090-541 Exam Practice Test

Latest Update

Useful Links

Contact Us