C2090-616 Free Practice Test

What is the primary use case for creating an index with the RANDOM option on a table?

1. A. Maximize performance with OLTP random key queries
2. B. Maximize performance when inserting into an expression based index containing the RAND() function
3. C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment
4. D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Correct Answer: C

Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

1. A. COMMIT
2. B. SAVEPOINT
3. C. ROLLBACK WORK
4. D. UPDATE TERMINATE

Correct Answer: C

The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

1. A. SYSCAT.DBAUTH
2. B. SYSIBMADM.GRANTS
3. C. SYSIBMADM.PRIVILEGES
4. D. SYSCAT.USER_TAB_PRIVS

Correct Answer: A

The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?

1. A. Shadow Table
2. B. Temporal Table
3. C. Range-Partitioned Table
4. D. Multidimensional Clustered Table

Correct Answer: B

Which of the following set operators can be used to find all rows that are common in 2 queries?

1. A. UNION
2. B. UNION ALL
3. C. EXCEPT ALL
4. D. INTERSECT ALL

Correct Answer: B