最新的IBM C2090-541免費考試真題

問題1

Which method may be used to collect deadlock information in DB2 97?

A. DB2_CAPTURE_LOCKTIMEOUT registry variable

B. DEADLOCKS event monitor

C. DB2DETA1LDEADLOCK event monitor

D. LOCKING event monitor

正確答案: D

問題2

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

A. Database-level

B. Object-level

C. System-level

D. Network-level

E. Instance-level

正確答案: A,B,C

問題3

You have a job scheduled to run every Saturday; the scheduler is turned off on Friday and then restarted on Monday. The job scheduled for Saturday is now a job that is scheduled in the past. Which configuration parameters will allow your Saturday job to run when the scheduler is restarted?

A. EXEC_EXP_TASK=YES SCHED ENABLE=ON

B. AUTORESTART=NO SCHED_ENABLE=ON

C. AUTORESTART=YES SCHED_ENABLE=ON

D. EXEC_EXP_TASK=NO SCHED_ENABLE=ON

正確答案: A

問題4

Due to an application error, some data was deleted from a very large table residing in table space TS1. The table space was then renamed TS2 before the error was detected. Rather than try and rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was done to a time that was too early and some critical transactions were missing when the database was brought back on-line. Which steps must be taken to ensure that the critical transactions which are currently missing from the database are correctly applied to the database and that table space TS1 is renamed TS2?

A. 1. Restore database DB1.
2.Roll forward to the correct point-in-time.
3.Rename TS1 to TS2.

B. 1, Restore database DB1
2. Roll forward to end of logs.

C. 1. Restore table space TS1 from the DB1 backup image.
2. Roll forward to end of logs.

D. 1. Restore table space TS1 from the DB1 backup image.
2.Roll forward to the correct point-in-time.
3.Rename table space TS1 to TS2.
4.Re-run the batch processes.

正確答案: A

問題5

Which two can be replicated using HADR? (Choose two.)

A. LOAD operations

B. CREATE TABLE... NOT LOGGED INITIALLY operations

C. database configuration changes

D. Data Definition Language (DDL) statements

正確答案: A,D

問題6

Which SQL statement will execute successfully?

A. CREATE TABLE customer
(custid INTEGER,
custinfo XML(1 M) NOT NULL PRIMARY KEY)

B. CREATE TABLE customer
(custid INTEGER NOT NULL PRIMARY KEY,
custinfo XML)

C. CREATE TABLE customer
(custid INTEGER,
custinfo XML NOT NULL PRIMARY KEY)

D. CREATE TABLE customer (custid INTEGER NOT NULL PRIMARY KEY, custinfo XML( 10000))

正確答案: B

最新的IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541免費考試真題

聯系我們

站內鏈接

最新更新