Download DB2 10.1 Advanced DBA for Linux UNIX and Windows.C2090-614.TestKing.2019-02-22.108q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-614 |
| Exam Name: | DB2 10.1 Advanced DBA for Linux UNIX and Windows |
| Date: | Feb 22, 2019 |
| File Size: | 667 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?
- Check constraints
- Default constraints
- Informational constraints
- Referential integrity constraints
Correct answer: C
Question 2
Given the following database design:
A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?
- Create a replicated summary table for the SALES table using the table space TS_REPL.
- Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
- Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
- Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
Correct answer: B
Question 3
Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?
- EXPLAIN_FROM_DATA
- EXPLAIN_FROM_ACTIVITY
- EXPLAIN_FROM_SECTION
- EXPLAIN_FROM_CATALOG
Correct answer: C
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!