C2090-600 Exam - Free IBM Questions and Answers

Question #11 (Topic: )

Where does the DB2 Problem Determination tool (db2pd) get information from?

A. DB2memory sets B. the db2diag.log file C. Monitoring table functions D. A set of pre-defined event monitors

Answer: A

Question #12 (Topic: )

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

A. XML B. REAL C. NUMBER D. VRCHAR2 E. VARBINARY

Answer: C,E

Question #13 (Topic: )

If Secure Sockets Layer is a requirement, which of the following parameters must be set to
encrypt data in transit?

A. Set the DB2COMM registry variable to DB2COMM=SSL B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer: B

Question #14 (Topic: )

What is the result of the following scenario?
[IBM-C2090-600-7.0/IBM-C2090-600-6_2.png]

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

Answer: B

Question #15 (Topic: )

Given the following:
[IBM-C2090-600-7.0/IBM-C2090-600-7_2.png]
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.

Answer: C

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