Free IBM C2090-320 Exam Actual Questions

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

Question No. 1

Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would provide the locking you need with optimistic locking?

Show Answer Hide Answer
Correct Answer: C

Question No. 2

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. 3

Why would an SQL statement receive an SQLCODE of +100? (Choose two)

Show Answer Hide Answer
Correct Answer: A, C

Question No. 4

Which statement about an application-period temporal table is TRUE?

Show Answer Hide Answer
Correct Answer: C

Question No. 5

Which types of user-defined data types are supported? (Choose two.)

Show Answer Hide Answer
Correct Answer: B, D