Answers to practice exam questions
A1: | Answer: A. The other options describe valid general recommendations. Using an excessive number of ORDER BY clauses can negatively affect application and query performance. |
A2: | Answer: C. Options A, B, and D identify valid recommendations for this situation. Option C is not a good recommendation because keeping tables that are used by the same applications together in the database can promote concurrency. |
A3: | Answer: A. DB2 uses share locks, update locks, and exclusive locks, but not priority locks. |
A4: | Answer: C. The statements in the other options are true. Option C is partially false because with RR isolation level, applications can read before the application reaches a commit point but they cannot update ... |
Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.