C2090-600 Online Practice Questions and Answers

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

A. SELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

B. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

C. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

D. SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

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 command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC

B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES

C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

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

What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

A. It does not acquire locks on the table

B. It does not require additional temporary disk space

C. It enables the user to control when the table will be offline

D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Which statement about the db2move command is TRUE?

A. The LOAD actions can be run from a client machine.

B. Object ownership cannot be changed after a successful schema copy operation.

C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

D. Loading data into tables containing XML columns is only supported for the LOAD actions.

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 statements is TRUE?

A. REORGCHK automatically runstables reorganization.

B. REORGCHK uses only current table and index statistics.

C. REORGCHK can only be used for user tables, not for system tables.

D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

A. Set the DB2COMM registry variable to DB2COMM=SSL

B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

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,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