C2090-600 PDF Dumps
How to use our free ibm C2090-600 PDF Dumps
Our Free C2090-600 PDF dumps are based on the full C2090-600 mock exams which are available on our Web Site.
The ibm C2090-600 PDF consists in questions and answers with detailed explanations.
You can use the PDF C2090-600 practice exam as a study material to pass the C2090-600 exam, and don't forget to try also our C2090-600 testing engine Web Simulator.
- - Download as PDF file format from those pages:
Java 8 PDF Dumps | Spring Core PDF Dumps | Oracle 12c PDF Dumps | Microsoft PDF Dumps | Cisco PDF Dumps | PMI PDF Dumps | Salesforce PDF Dumps | VMware PDF Dumps | Cloudera PDF Dumps | Amazon PDF Dumps | APICS PDF Dumps | C++ PDF Dumps | CompTIA PDF Dumps | ECCouncil PDF Dumps | ISC PDF Dumps | Palo Alto Networks PDF Dumps - - or -
- - Use it with our Free Web Simulator from those pages:
Java 8 Practice Exams | Spring Core Practice Exams | Oracle 12c Practice Exams | Microsoft Practice Exams | Cisco Practice Exams | PMI Practice Exams | Salesforce Practice Exams | VMware Practice Exams | Cloudera Practice Exams Amazon PDF Dumps | APICS PDF Dumps | C++ PDF Dumps | CompTIA PDF Dumps | ECCouncil PDF Dumps | ISC PDF Dumps | Palo Alto Networks 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 dumpsolution: 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/