A2090-541 Exam Training Practice Tests (IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows)]

Question 1

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 have been captured by the Query Patroller for 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 are stored in a file named db2advise.in that is to be executed against a database named SAMPLE D. A set of dynamic SQL statements that have been stored in the SYSCAT.WORKLOADS catalog view of a database named SAMPLE.

Correct Answer: B

Question 2

If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?

A. The damaged table space must be restored from the latest backup and any active transaction logs in the log path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database. B. The damaged table space must be restored from the latest backup image. Once restored from the backup image, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized. C. The damaged table space will require that the entire database be restored from the latest backup image because the database is non-recoverable and will not be accessible. D. The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created.

Correct Answer: D

Question 3

Which command is used to configure the administrative task scheduler to execute tasks?

A. db2set D B 2_AT S_E NAB LE=YE S B. db2setDB2 SCHEDULE ENABLE=YES C. db2set D B 2_EXE C_S C H E D U LE_E NAB LE=YE S D. db2set D B 2_EXE C_AT S_E NAB LE=YE S

Correct Answer: A

Question 4

Which three commands will apply the specified action to all objects in schema PAY1 in database PRODDB? (Choose three.)

A. GRANT SELECT ON TABLEpayl * TO USER userl B. RUNSTATS ON SCHEMApayl D REORGCHK UPDATE STATISTICS ON SCHEMA payl C. GRANT DROPIN ON SCHEMApayl TO USER userl D. db2look-dproddb -z payl

Correct Answer: C,D

Question 5

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

A. REORG TABLEtaba INDEXES INPLACE B. REORG TABLEtaba AND INDEXES ALL C. REORG INDEXES FORtaba D. REORG INDEXES ALL FOR TABLEtaba

Correct Answer: D

Question 6

Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ;
CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK
OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ;
Which statement will fail?

A. INSERT INTO v1 VALUES (5) B. INSERT INTO v3 VALUES (200) C. INSERT INTO v2 VALUES (35) D. INSERT INTO v3 VALUES (25)

Correct Answer: D

Question 7

Tables TABLE_A and TABLE_B in database TESTDB have the same data structure (same columns with the same definitions). You wish to unload the data from the two tables into a single file In PC/IXF format.
Which command(s) can be used to do this?

A. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a, table_b B. EXPORT TO combined.ixf OF IXF SELECT * FROM table a INTERSECT SELECT * FROM table b C. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a: EXPORT APPEND TO combined.ixf OF IXF SELECT * FROM table_b; D. EXPORT TO combined.ixf OF IXF SELECT * FROMtable_a UNION ALL SELECT * FROM table_b

Correct Answer: D

Question 8

A database named FINANCE must be available to users 24x7x365. Which command should be used to create a backup image of the FINANCE database without having a significant impact on running applications?

A. BACKUP DATABASE finance ONLINE TO /mnt/backup COMPRESS B. BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_PRIORITY 15 C. BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_LIM 50 D. BACKUP DATABASE finance ONLINE TO /mnt/backup PARALLELISM 5

Correct Answer: B

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