DB2 11.1 Fundamentals for LUW - C2090-616 Exam Practice Test

Question 1

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?

A. Selecting from the DUAL table

B. Use of bitmap indexes

C. Double-dot notation

D. Implicit casting

Correct Answer: A

Question 2

BLU Acceleration is included in which of the following edition of DB2 LUW? (Choose two.)

A. Enterprise Server Edition

B. Workgroup Server Edition

C. DB2 Direct Advanced Edition

D. Direct Standard Edition

E. Advanced Enterprise Server Edition

Correct Answer: A,B

Question 3

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

A. Faster response time of long-running or complex queries with I/O spread across many computers

B. Management of very large data sets

C. Easy scalability

D. Increased throughput of many concurrent short running queries

E. Continuously available dataset solution

Correct Answer: A,B

Question 4

Which operation typically requires a Share (S) lock?

A. UPDATE

B. DELETE

C. INSERT

D. SELECT

Correct Answer: A

Question 5

Which of the following is TRUE about DB2 OLAP functions?

A. They return scalar values and not array values

B. OLAP functions are not supported in a common table expression (CTE)

C. OLAP aggregation functions are not supported with column organized tables

D. There are no DB2 monitor elements specific to OLAP functions

Correct Answer: B

Question 6

Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

A. Foreign key

B. Primary key

C. Informational constraint

D. NOT NULL

Correct Answer: B

Question 7

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

A. Insert time clustering table

B. Identity Column

C. Sequence

D. Row Identifier

Correct Answer: C

IBM DB2 11.1 Fundamentals for LUW - C2090-616 Exam Practice Test

Latest Update

Useful Links

Contact Us