C2090-600 PDF Dumps

										
											Q1.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

 solution: D

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/
doc/c0021495.html (protecting rows)


Q2.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

 solution: A



Q3.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

 solution: B

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.5.0/
com.ibm.db2.luw.admin.cmd.doc/doc/r0002025.html


Q4.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

 solution: B

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.ref.doc/
doc/r0000915.html


Q5.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

 solution: A



Q6.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;

 solution: A



Q7.Which of the following are valid Explain operators? (Choose two.)
 - A:   CTQ
 - B:   XSCAN
 - C:   IXSCAN
 - D:   SELECT
 - E:   COLSCAN

 solution: B, C

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/
com.ibm.db2.luw.admin.explain.doc/doc/r0052023.html


Q8.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 operations
db2tc dump db2trc.dmp
db2tc format db2tc.dmp db2tc.fmt
db2tc off
 - C:   BACKUP DATABASE mydb NO TABLESPACE TO /outdir
 - D:   db2set DB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).

Run the desired operations.
Afterwards, issue db2trc dump 

 solution: B



Q9.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_percent

FROM TABLE(sysproc.mon_tbsp_utilization()) AS t
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;
 - B:   SELECT tbsp_name, tbsp_utilization_percent

FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;
 - C:   SELECT tbsp_name, tbsp_utilization_percent

FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;
 - D:   SELECT tbsp_name, tbsp_utilization_percent

FROM sysibmadm.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0;

 solution: C



Q10.When operating in NPS compatibility mode, which of the following are limitations for using a routine written in
NZPLSQL? (Choose two.)
 - A:   The routine cannot contain comments.
 - B:   The routine must return either an integer or a null.
 - C:   The routine must be cross-compatible with Oracle PL/SQL syntax rules.
 - D:   The routine cannot contain argument lists or variable arguments (varargs).
 - E:   The routine must be generated with IBM Database Conversion Workbench (DCW).

 solution: B, D

Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/
com.ibm.db2.luw.apdv.porting.doc/doc/r_sql_compat_nzplsql.html/