最新的高品質 A2090-919 考試練習題庫

IBM A2090-919 考試概覽:

IBM A2090-919 考試大綱主題:

最新的 Certified Administrator A2090-919 免費考試真題：

1. Which two options can be used to monitor PDQ resources? (Choose two.)

A) onstat -g ath.
B) onstat -p.
C) onstat -D.
D) SET EXPLAIN output.
E) onstat -l.

2. Which statement about mapped user functionality is true?

A) Mapped users are allowed to run with multiple names.
B) The DBSA can grant database server access to externally authenticated users with no local account.
C) Mapped users cannot execute distributed operations.
D) The DBSA can control the access to tables at a row level using security labels.

3. What is used during Fast Recovery to return pages to the original state?

A) External Tables
B) Logical Log
C) Temporary DBSpaces
D) Physical Log

4. What two conditions must be met for direct I/O to occur? (Choose two.)

A) When the table is too big to fit in the bufferpool.
B) When the I/O is to raw disk space.
C) When the DIRECT_IO configuration parameter is set to 1.
D) When the I/O is to cooked disk space.
E) When doing I/O operations on temporary dbspaces.

5. Which user isolation level may cause concurrency problems with SELECT statements?

A) Dirty Read Last Committed
B) Committed Read Last Committed
C) Dirty Read
D) Committed Read

問題與答案：