Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis: db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?
A. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
C. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
正解:A
質問 2:
Which operation can be performed by executing an ALTER STOGROUP statement?
A. Reduce the current high water mark of all table spaces that have been assigned to a storage group.
B. Make an existing storage group the default storage group.
C. Change the name of an existing storage group.
D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.
正解:B
質問 3:
An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?
A. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.
B. By creating a SYSADM ROLE and capturing SYSADMIN and CHECKING event records.
C. By creating a SYSADM ROLE and capturing SYSMAINT event records.
D. By creating a AUDIT POLICY and associating it with SYSMAINT, SYSADMIN and CHECKING event records.
正解:A
質問 4:
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
質問 5:
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
質問 6:
Which table function can be used to determine whether all of a particular table space data objects have been moved from one storage group toWhich table function can be used to determine whether all of a particular table space? data objects have been moved from one storage group to another?
A. MON_GET_TABLESPACE
B. ADMIN_GET_STORAGE_PATHS
C. MON_GET_REBALANCE_STATUS
D. ADMIN_GET_STOGROUP_INFO
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 7:
Which statement about Range Clustered Tables (RCT) is correct?
A. Storage space is not pre-allocated for an RCT.
B. The ALTER TABLE statement can be used to change the physical structure of an RCT.
C. The minimum value of a key column for an RCT cannot be a negative value.
D. When defining a range of key values for an RCT, a minimum value is optional.
正解:D
質問 8:
On which two operating systems can DB2 pureScale run? (Choose two.)
A. Windows
B. HP-UX
C. AIX
D. Solaris
E. Linux
正解:C,E
質問 9:
A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?
A. ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE
B. ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5
C. ALTER TABLESPACE ts1 REBALANCE
D. ALTER STOGROUP med_sg DROP '/db2fs4'
正解:C
みや** -
試験問題にはこのPass4TestのC2090-614教科書の細かい内容まで出ました。過去問を解くのと合わせて、本をかなり読み込む方が良いと思います。