New Year Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

  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

Go to page:
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
Go to page:

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