What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?
A. EXECUTE
B. CONTEXT
C. VALIDATE
D. AUDIT
正解:A
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
Where is the HADR_TARGET_LIST configuration parameter set?
A. On the tertiary standby databases.
B. On all participating databases.
C. On the primary database only.
D. On the auxiliary standby databases only.
正解:B
質問 3:
Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
B. It can be used to merge offline backups to build full offline table space backups.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
正解:D
質問 4:
In which situation would you NOT use a redirected restore?
A. To move table space containers onto different physical devices.
B. To restore a backup image from one operating system to another.
C. To restore a backup image to a target machine that is different from the source machine.
D. To redefine the paths of a defined storage group.
正解:B
質問 5:
Which category must be enabled before db2audit will record the creation of new buffer pools?
A. OBJCREATE
B. SECMAINT
C. OBJMAINT
D. CHECKING
正解:C
質問 6:
What will occur when a database administrator adds a new automatic storage path to an existing storage group?
A. Existing table spaces will not consume storage on the new path.
B. The storage group will be placed in "Rebalance Pending" mode.
C. New table spaces will start consuming storage on the new path.
D. DB2 will verify that space is available on the storage path specified.
正解:A
質問 7:
Which statement about SMS table spaces is correct?
A. Tables, large objects (LOBs), and indexes can each reside in separate SMS table spaces.
B. Extents are more likely to be contiguous with SMS table spaces than they are with DMS table spaces.
C. SMS table spaces are recommended when you have small tables that are not likely to grow quickly.
D. The system catalog cannot be stored in an SMS table space.
正解:C
質問 8:
Given the following output:
Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
A. EXPLAIN_FROM_ACTIVITY
B. EXPLAIN_FROM_SECTION
C. EXPLAIN_FROM_DATA
D. EXPLAIN_FROM_CATALOG
正解:A
質問 9:
Which statement about compression dictionaries is FALSE?
A. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.
B. Page-level dictionaries are automatically created or recreated by the database manager
as pages are filled.
C. Page-level dictionaries are stored in hidden rows within the table.
D. Table-level dictionaries are stored in hidden rows within the table.
正解:A
中*舞 -
重要なC2090-614知識を整理している。ありがたい。まるで嘘のような的中率でした。ありがとうございます。