READ Free Dumps For IBM- C2090-311
| Question ID 20867 | Which two sources can be used to provide input to the InfoSphere Optim Query Workload |
| Option A | db2pd |
| Option B | Routines |
| Option C | EXPLAIN tables |
| Option D | Snapshot monitor |
| Option E | ACTIVITIES event monitors |
| Correct Answer | C,D |
| Question ID 20868 | Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true? |
| Option A | EHL is enabled by default in DB2 10.5 pureScale environments. |
| Option B | There are three EHL states available: SHARED, DIRECT_ACCESS and NONSHARED. |
| Option C | Only regular tables, temporary tables, and non-partitioned indexes can take advantage of EHL. |
| Option D | EHL is designed to improve DB2 pureScale performance by avoiding CF communications for tables that are accessed from only one member. |
| Correct Answer | A |