IBM Information Management C2090-312 Updated Exam

IBM DB2 11 DBA for z/OS Questions and Answers

Question 9

You want to determine which objects of your database DB1 are in LPL. What command should be used?

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(')

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(')

-DIS DB(DB1) SP(') ADVISORY(LPL) LIMIT(") SCOPE(GROUP)

-DIS DB(DB1) SP(') RESTRICT(LPL) LIMIT(') SCOPE(GROUP)

Question 10

Which statement is true?

Unicode and EBCDIC have a different collating sequence.

The collating sequence for ASCII and EBCDIC is identical.

The collating sequence for Unicode and EBCDIC is identical.

If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.