IBM c2090-600 practice test

Automatic space reclamation for column-organized tables can be accomplished in which of the
following scenarios?

• A. When the registry variableDB2_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 ON
• D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

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

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 of columns and rows in the same table
• D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

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
• D. db2cluster –cfs –displayconfig –filesystem datafs

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 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 files before the data can be loaded into database tables
• D. Event monitors are used to obtain information about how a database system looks at a specific point in time

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

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 the DBA to improve the performance of the
queries run against the SALES table?

• A. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
• B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;
• C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
• D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Which of the following are valid Explain operators? (Choose two.)

• A. CTQ
• B. XSCAN
• C. IXSCAN
• D. SELECT
• E. COLSCAN

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 /outdir
• B. db2trc on db mydb m backup,loadrun the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
• C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>