Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. IBM
  3. IBM Certified Database Administrator DB2 11.1 for Linux UNIX and Windows
  4. C2090-600 - IBM DB2 11.1 DBA for LUW
Note! Following C2090-600 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-600 Exam Dumps - IBM DB2 11.1 DBA for LUW

Question # 4

Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)

A.

XML

B.

REAL

C.

NUMBER

D.

VRCHAR2

E.

VARBINARY

Full Access
Question # 5

Which statement about the db2move command is TRUE?

A.

The LOAD actions can be run from a client machine.

B.

Object ownership cannot be changed after a successful schema copy operation.

C.

Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

D.

Loading data into tables containing XML columns is only supported for the LOAD actions.

Full Access
Question # 6

You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

A.

db2cluster -verify

B.

db2cluster -cm -list -alert

C.

db2cluster -verify -configuration

D.

db2cluster -cm -verify -resource

Full Access
Question # 7

For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

A.

XML

B.

BLOB

C.

CLOB

D.

VARCHAR

E.

DATETIME

Full Access
Question # 8

Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

A.

db2pd

B.

db2dart

C.

db2expln

D.

db2advis

Full Access
Question # 9

What is the result of the following scenario?

A.

The row is updated to (2, NULL)

B.

The row is updated to (2, 110.00)

C.

SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed

D.

The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Full Access

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps