C2090-541試験無料問題集（104題）「IBM DB2 9.7 DBA for Linux UNIX and Windows 認定」

出題：1

Which HADR feature minimizes the impact of software maintenance on the Standby server?

A. Configure AUTOMATIC maintenance and perform a roll forward.

B. Configure all AUTOMATIC features.

C. Configure all AUTOMATIC maintenance parameters.

D. Configure AUTOMATIC maintenance and perform a rolling upgrade

正解：D 解答を投票する

出題：2

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

A. REORG TABLEtaba AND INDEXES ALL

B. REORG INDEXES FORtaba

C. REORG INDEXES ALL FOR TABLEtaba

D. REORG TABLEtaba INDEXES INPLACE

正解：C 解答を投票する

出題：3

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 backup images for the original database can be used to restore the new database.

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

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

正解：A,C 解答を投票する

出題：4

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

A. DEADLOCKS event monitor

B. DB2DETAILDEADLOCK event monitor

C. DB2_CAPTURE_LOCKTIMEOUT registry variable

D. LOCKING event monitor

正解：D 解答を投票する

出題：5

You are asked to create a new database called PRODDB where no privileges will be automatically granted to PUBLIC Which CREATE statement will accomplish this?

A. CREATE DATABASEproddb RESTRICTIVE

B. CREATE DATABASEproddb REVOKE ALL FROM PUBLIC

C. CREATE DATABASEproddb SECURE

D. CREATE DATABASEproddb GRANT PUBLIC NO

正解：A 解答を投票する

出題：6

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

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

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 statistics information for a series of objects in a database and generate UPDATE statements to manually update the statistics

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

正解：C,D 解答を投票する

C2090-541試験無料問題集「IBM DB2 9.7 DBA for Linux UNIX and Windows 認定」