- All Exams Instant Download
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?
A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes). Sunday C Delta Monday C Incremental Tuesday C Delta Wednesday C Delta Thursday C Incremental Friday C Delta Saturday C Full Which...
Which statement about NOT ENFORCED unique constraints is TRUE?
Which statement about NOT ENFORCED unique constraints is TRUE?A . NOT ENFORCED unique constraints can not be defined on primary key columnsB . The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access planC . When attempting to insert data that does not conform...
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?A . db2valB . db2setC . db2lookD . db2gregView AnswerAnswer: D
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?
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 mydbPRUNE HISTORY TO /outdirB . db2trc on Cdb mydb Cm “backup,load”run the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc offC . BACKUP DATABASE mydb...
Which options are valid for an online reorganization operation?
Which options are valid for an online reorganization operation?A . FULL and RECLAIM EXTENTSB . CLASSIC and RECLAIM EXTENTSC . FULL and CLEANUP OVERFLOWSD . CLEAN OVERFLOWS and RECLAIM EXTENTSView AnswerAnswer: C
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?
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 table. Which of the following commands should be used by...
What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?
A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?A . All data, both new and existing, will becompressed.B . Only new or updated data for XML columns...
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?A . When the registry variableDB2_AUTORECLAIMSPACE=YESB . After termination all the back-end processes using TERMINATE commandC . After setting the database configuration parameter AUTO_DEL_REC_OBJ to OND . When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creationView...
Which statement regarding event monitors is TRUE?
Which statement regarding event monitors is TRUE?A . Event monitor data can be reviewed while the event monitor is activeB . Event monitors must always be started manually after activating a databaseC . Event monitors must write data to .EVT files before the data can be loaded into database tablesD...
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?A . db2cluster Ccfs Clist Cfilesystem datafsB . db2cluster Ccfs Cdisplay Cfilesystem datafsC . db2cluster Ccfs Clistconfig Cfilesystem datafsD . db2cluster Ccfs Cdisplayconfig Cfilesystem datafsView AnswerAnswer: A
