You are creating a table with 1 LOB column. The size of the LOB column is less than the size of the LOB descriptor. When creating this table you did not specify an INLINE LENGTH. Which option is correct?
A. Both the LOB descriptor and the LOB data will be stored in the base table.
B. The ALTER TABLE .. INLINE LENGTH .. command is required so the LOB data can be included in the base table.
C. Only the LOB descriptor will be stored in base table and the LOB data will be stored in the LOB storage object.
D. Only the LOB data will be stored in the base table.
正解:D
質問 2:
Which two of the following can now be monitored with DB2 v9.7? (Choose two.)
A. Unit of work total memory usage.
B. Memory consumption by static SQL statements.
C. Unit of work total CPU usage.
D. Memory consumption by static and dynamic SQL statements.
E. Deadlocks, lock timeouts, and lock waits.
正解:C,E
質問 3:
If table TAB_A has just been created as follows:
Which command will create a compression dictionary for table TAB_A?
A. LOAD FROM data.del OF DEL INSERT INTO tab_a
B. REORG TABLE tab_a
C. DELETE FROM tab_a
D. UPDATE tab_a SET c1 = c1*1.1
正解:A
質問 4:
A table named TAB_A has a primary key and 2 additional indexes that were created by the DBA. If the ADMIN_MOVE_TABLE procedure is used to MOVE table TAB_A from a table space named TS4K to a table space named TS16K, how many indexes will be on the table after the procedure finishes running?
A. 0
B. 1
C. 3
D. 2
正解:C
質問 5:
Which two authorities can grant SELECT privilege on a table? (Choose two.)
A. DATAACCESS authority on the database.
B. SECADM authority on the database.
C. ACCESSCTRL authority on the database.
D. DBADM authority on the database.
E. SYSADM authority on the instance.
正解:B,C
質問 6:
Which category is used to audit the running of SQL statements?
A. EXECUTE
B. CONTEXT
C. SQLMAINT
D. OBJMAINT
正解:A
岛本** -
いちばんやさしいC2090-546で学習してからがちょうどくらいだと思います。知識は勉強してからチャレンジもあります