New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best70

Dumpsbuddy Logo
  1. Home
  2. IBM
  3. IBM Analytics: Platform Analytics
  4. C2090-616
  5. DB2 11.1 Fundamentals for LUW Questions and Answers
Note! IBM has retired the C2090-616 Exam Contact us through Live Chat or email us for more information.

C2090-616 DB2 11.1 Fundamentals for LUW Questions and Answers

Questions 4

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?

Options:

A.

Shadow Table

B.

Temporal Table

C.

Range-Partitioned Table

D.

Multidimensional Clustered Table

Buy Now
Questions 5

What type of function is created using the following command?

CREATE FUNCTION TAN (X DOUBLE)

RETURNS DOUBLE

LANGUAGE SQL

CONTAINS SQL

NO EXTERNAL ACTION

DETERMINISTIC

RETURN SIN(X)/COS(X)

Options:

A.

Row

B.

Table

C.

Scalar

D.

External

Buy Now
Questions 6

What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?

Options:

A.

32672 bytes

B.

65344 bytes

C.

98016 bytes

D.

130688 bytes

Buy Now
Questions 7

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

Options:

A.

NOT NULL

B.

Foreign key

C.

Primary key

D.

Informational constraint

Buy Now
Questions 8

Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?

Options:

A.

DB2 HADR

B.

DB2 pureScale

C.

DB2 Express-C

D.

DS2 Database Partitioning Feature

Buy Now
Questions 9

Which of the following is TRUE about indexes on column organized tables?

Options:

A.

No indexes are allowed

B.

Indexes are only allowed on numeric columns

C.

Indexes are automatically created to enforce unique constraints

D.

An index is only allowed on the synopsis table supporting a column organized table

Buy Now
Exam Code: C2090-616
Exam Name: DB2 11.1 Fundamentals for LUW
Last Update: Dec 22, 2024
Questions: 63