Labour Day Special - 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sdisc65

Note! C2090-600 has been withdrawn.

C2090-600 Practice Exam Questions with Answers IBM DB2 11.1 DBA for LUW Certification

Question # 6

Which of the following are all valid types of trigger?

A.

AFTER, ATOMIC, BEFORE

B.

AFTER, ATOMIC, INSTEAD OF

C.

AFTER, BEFORE, INSTEAD OF

D.

ATOMIC, BEFORE, INSTEAD OF

Full Access
Question # 7

Given the following:

C2090-600 question answer

What will be the result of the following SQL statement?

INSERT INTO v3 (col1) values (30);

A.

The insert will succeed as it passes validation.

B.

The insert will succeed as there is no WITH CHECK OPTION on view V3.

C.

The insert will result in an error as it violates the WITH CHECK OPTION on view V2.

D.

The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Full Access
Question # 8

If the following SQL statements are executed:

CREATE DATABASE testdb AUTOMATIC STORAGE NO;

CONNECT TO testdb;

CREATE STOGROUP sg1 ON ‘/data1’;

CREATE STOGROUP ibmstogroup ON ‘/data2’;

CREATE STOGROUP sg2 ON ‘/data3’;

Which storage group is the default storage group for the TESTDB database?

A.

SG1

B.

SG2

C.

IBMSTOGROUP

D.

IBMDEFAULTTSG

Full Access
Question # 9

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

A.

The page size is too small.

B.

The extent size is too small.

C.

Low cardinality of the dimension(s) chosen.

D.

High cardinality of the dimension(s) chosen.

Full Access