Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
A. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
B. db2setDB2_BCKP PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>
C. CONNECT TO mydbPRUNE HISTORY TO /outdir
D. db2trc on -db mydb -m "backup,load"run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
正解:D
質問 2:
You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?
A. INGEST
B. LOAD
C. TRANSPORT
D. IMPORT
正解:D
質問 3:
Which statement about label-based access control (LBAC) is TRUE?
A. LBAC protection can be applied to a nickname
B. LBAC cannot be used to restrict access to data of columns and rows in the same table
C. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type
D. LBAC cannot be used to restrict access to a staging table
正解:C
質問 4:
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
A. db2expln
B. db2pd
C. db2advis
D. db2dart
正解:A
質問 5:
Which of the following statements is TRUE?
A. REORGCHK uses only current table and index statistics.
B. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
C. REORGCHK can only be used for user tables, not for system tables.
D. REORGCHK automatically run stables reorganization.
正解:A
質問 6:
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
A. Using or altering the default service classes and workloads
B. Granting, altering, or revoking workload privileges
C. Creating, activating, stopping or dropping workload management event monitors
D. Creating service classes, service subclasses, and workloads
E. Creating, using, or altering thresholds
正解:B,D
Tanimura -
試験に出てくる内容のほとんどがこの問題集に収めていて、本当に助けになりました。これを使ってC2090-600不合格になるわけがないよ