Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB? A. CONNECT TO mydb PRUNE HISTORY TO /outdir B. db2trc on -db mydb -m "backup,load"run the desired…
Which of the following are valid Explain operators? (Choose two.) A. CTQ B. XSCAN C. IXSCAN D. SELECT E. COLSCAN
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES…
Which options are valid for an online reorganization operation? A. FULL and RECLAIM EXTENTS B. CLASSIC and RECLAIM EXTENTS C. FULL and CLEANUP OVERFLOWS D. CLEAN OVERFLOWS and RECLAIM EXTENTS
Which statement regarding event monitors is TRUE? A. Event monitor data can be reviewed while the event monitor is active B. Event monitors must always be started manually after activating a database C. Event monitors must write data to .EVT…
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server? A. db2val B. db2set C. db2look D. db2greg
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster? A. db2cluster -cfs -list -filesystem datafs B. db2cluster -cfs -display -filesystem datafs C. db2cluster -cfs -listconfig -filesystem datafs…
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 a staging table C. LBAC cannot be used to restrict access to data…
Which security mechanism is responsible for verifying that users are indeed who the claim to be? A. Authentication B. Roles and privileges C. Mandatory access control D. Discretionary access control
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios? A. When the registry variable DB2_AUTORECLAIMSPACE=YES B. After termination all the back-end processes using TERMINATE command C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to…