最新的IBM DB2 11.1 DBA for LUW - C2090-600免費考試真題

A. db2trc on -db mydb -m "backup,load"run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

B. BACKUP DATABASE mydb NO TABLESPACE TO /outdir

C. db2setDB2_BCKP PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>

D. CONNECT TO mydbPRUNE HISTORY TO /outdir

A. UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATE

B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE

C. CONNECT TO sample; UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;

D. ATTACH TO db2instl;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

A. AFTER, BEFORE, INSTEAD OF

B. AFTER, ATOMIC, BEFORE

C. ATOMIC, BEFORE, INSTEAD OF

D. AFTER, ATOMIC, INSTEAD OF

A. Block indexes are much smaller than RID indexes, providing better performance

B. Table data is automatically and continuously clustered, requiring minimal reorganization

C. Ability to run utilities against the partitions in parallel

D. Increased query performance through data partition elimination

A. Event monitors must write data to .EVT files before the data can be loaded into database tables

B. Event monitors are used to obtain information about how a database system looks at a specific point in time

C. Event monitors must always be started manually after activating a database

D. Event monitor data can be reviewed while the event monitor is active

A. Using or altering the default service classes and workloads

B. Creating, using, or altering thresholds

C. Creating service classes, service subclasses, and workloads

D. Granting, altering, or revoking workload privileges

E. Creating, activating, stopping or dropping workload management event monitors