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

出題：1

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. GRANT DROPIN ON SCHEMApayl TO USER userl

C. db2look-dproddb -z payl

D. RUNSTATS ON SCHEMApayl D REORGCHK UPDATE STATISTICS ON SCHEMA payl

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

出題：2

Which three types of work can be defined for a Workload Management service class set? (Choose three.)

A. Delete

B. Unload

C. Load

D. Write

E. Read

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

出題：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 three table features can be used concurrently in the same table? (Choose three.)

A. primary key index

B. range-clustered tables

C. MDC tables

D. partitioned tables

E. local indexes

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

出題：5

How do you turn on Self-Tuning Memory Manager (STMM)?

A. UPDATE DB CFG FOR USING SELF_TUNING_MEM ON

B. db2set AUTOMATIC MEMORY=ON

C. UPDATE DB CFG FOR USING AUTOMATIC_MEMORY ON

D. db2set SELF_TUNING_MEM=ON

正解：A 解答を投票する

出題：6

Click the Exhibit button.

IBM 000-541: Practice Exam
Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

A. Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.

B. The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.

C. At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.

D. Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.

正解：A 解答を投票する

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