Free IBM C2090-320 Exam Actual Questions

The questions for C2090-320 were last updated On Nov 18, 2024

Question No. 1

You want to limit the access of a table to allow users to only see certain columns and/or rows.

Which of the following options CANNOT be used to accomplish this?

Show Answer Hide Answer
Correct Answer: C

Question No. 2

Which authorizations can change the value of the subsystem parameter SYSADM using the --SET SYSPARM command? (Choose two.)

Show Answer Hide Answer
Correct Answer: D, E

Question No. 3

An array value CANNOT be specified using which of the following methods?

Show Answer Hide Answer
Correct Answer: D

Question No. 4

The following definition for COL1 is given by this statement:

CREATE TABLE... (COL1 BINARY (05))

Which of the following statements will successfully insert data into the table?

Show Answer Hide Answer
Correct Answer: C

Question No. 5

Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

Show Answer Hide Answer
Correct Answer: A