IBM C2090-600 IBM DB2 11.1 DBA for LUW Online Training
IBM C2090-600 Online Training
The questions for C2090-600 were last updated at Dec 25,2024.
- Exam Code: C2090-600
- Exam Name: IBM DB2 11.1 DBA for LUW
- Certification Provider: IBM
- Latest update: Dec 25,2024
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 Ccfs Clist Cfilesystem datafs
- B . db2cluster Ccfs Cdisplay Cfilesystem datafs
- C . db2cluster Ccfs Clistconfig Cfilesystem datafs
- D . db2cluster Ccfs Cdisplayconfig Cfilesystem 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 sales AND 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 Cdb mydb Cm “backup,load”run 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>
Latest C2090-600 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
