최신IBM DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade - C2090-546무료샘플문제

A. A table with an XML column can only be defined in a Unicode database.

B. A table with an XML column can be defined in a non-Unicode database but the database must be converted to Unicode before the XML columns can be used.

C. A table with an XML column can be defined in a non-Unicode database but the table containing the XML column will be stored in Unicode.

D. A table with an XML column can be defined in a non-Unicode database.

A. -f

B. -r

C. -l

D. -o

A. The table space TBS_1 is managed by automatic storage, online and all its containers are relocated to the database assigned automatic storage paths.

B. The table space TBS_1 is managed by automatic storage, in a backup pending state and all its containers are relocated to the database assigned automatic storage paths.

C. The table space TBS_1 is managed by automatic storage, online and still using its old containers.

D. The table space TBS_1 is managed by automatic storage and in a rebalance pending state waiting for the REBALANCE command.

A. GRANT DATAACCESS ON DATABASE TO user1

B. GRANT WLMADM ON DATABASE TO user1

C. GRANT ACCESSCTRL ON DATABASE TO user1

D. GRANT SQLADM ON DATABASE TO user1

A. Entries will be removed from the recovery history file; physical log files, backup images, and load copy images will not be removed.

B. Entries will remain in the recovery history file; physical log files, backup images, and load copy images will be deleted.

C. Entries will be removed from the recovery history file; physical log files, backup images, and load copy images will be removed.

D. Entries will remain in the recovery history file; backup images and load copy images will be deleted.

A. CONCURRENTDBCOORDACTIVITIES

B. CPUTIMEINSC

C. REMAPACTIVITY

D. ACTIVITYTOTALTIME

E. SQLROWSREADINSC

A. One compression dictionary is built for relational data, XML data is not compressed.

B. One compression dictionary is built for both relational data and for XML data.

C. One compression dictionary is built for relational data, one compression dictionary is built for XML data, and one compression dictionary is built for both relational and XML data.

D. One compression dictionary is built for relational data and one compression dictionary is built for the XML data.

A. Unit of work total memory usage.

B. Unit of work total CPU usage.

C. Deadlocks, lock timeouts, and lock waits.

D. Memory consumption by static SQL statements.

E. Memory consumption by static and dynamic SQL statements.