Practice exam questions

The following practice exam questions test your knowledge of material that this chapter covers.

1:Which statement does not describe a general recommendation for managing application and query performance?

  1. Use as many ORDER BY clauses as possible in the query.

  2. Keep SQL queries as simple as possible.

  3. Avoid selecting any columns of data that you don't really need.

  4. Use no unnecessary GROUP BY clauses in the query.

2:A database designer is faced with complaints about response time of queries and needs to be responsive to the users. However, the DBA also is charged with ensuring that users cannot update data that is being used by other applications. Which recommendation below is not consistent with supporting goals of increased ...

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.

Start your free trial