C2090-616 Free Practice Test

Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

1. A. Implicit casting
2. B. Double-dot notation
3. C. Use of bitmap indexes
4. D. Selecting from the DUAL table

Correct Answer: D

Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

1. A. No other applications can access the table
2. B. Only uncommitted read (UR) applications can access the table
3. C. The lock owner and other applications can read, but not update, the locked table
4. D. The lock owner can both read and update dat
5. E. Other applications can read the table
6. F. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Correct Answer: AE

Which of the following authorities is sufficient for connecting to a database?

1. A. SQLADM
2. B. CONNECT
3. C. DATAACESS
4. D. ACCESSCTRL

Correct Answer: D

Which operation typically requires a Share (S) lock?

1. A. INSERT
2. B. SELECT
3. C. DELETE
4. D. UPDATE

Correct Answer: D

A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?

1. A. Shadow tables
2. B. Range-partitioned tables
3. C. Materialized query tables
4. D. Multidimensional clustering tables

Correct Answer: A