Cyber Monday Special Sale - 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: spcl70

Note! C2090-600 has been withdrawn.

Practice Free C2090-600 IBM DB2 11.1 DBA for LUW Exam Questions Answers With Explanation

We at Crack4sure are committed to giving students who are preparing for the IBM C2090-600 Exam the most current and reliable questions . To help people study, we've made some of our IBM DB2 11.1 DBA for LUW exam materials available for free to everyone. You can take the Free C2090-600 Practice Test as many times as you want. The answers to the practice questions are given, and each answer is explained.

Get Full 60 Questions Search Other IBM Exam
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

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.

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

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.