Download IBM.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 |
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
