IBM C2090-312 - IBM DB2 11 DBA for z/OS Exam
Page: 1 / 14
Total 67 questions
Question #1 (Topic: )
Which statement is true?
A. Unicode and EBCDIC have a different collating sequence.
B. The collating sequence for ASCII and EBCDIC is identical.
C. The collating sequence for Unicode and EBCDIC is identical.
D. If you use BETWEEN in your SQL statement, the collating sequence does not matter for the predicate evaluation.
Answer: A
Question #2 (Topic: )
Which two options can be specified in order to access a system-period temporal table for a
specific point in time guaranteeing accurate results?
specific point in time guaranteeing accurate results?
A. A period-specification placed in the FROM clause of a subselect.
B. A period-specification placed in the WHERE clause of a subselect
C. A SELECT statement predicate against the transaction start ID of the base table.
D. A predicate against the start and end columns of the base table placed in the WHERE clause of a subselect.
E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a SELECT against the temporal table.
Answer: C,E
Question #3 (Topic: )
Which is NOT a valid privilege/authority for executing CREATE TYPE (array)?
A. SYSADM
B. SYSOPR
C. SYSCTRL
D. CREATEIN on the schema
Answer: A
Question #4 (Topic: )
Which DB2 Client command can be used to identify the Client's version?
A. db2fm
B. db2look
C. db2level
D. db2ldcfg
Answer: C
Question #5 (Topic: )
The degree of parallelism can vary for the REBUILD INDEX utility.
What action should be taken to limit the use of real memory using the REBUILD INDEX
utility?
What action should be taken to limit the use of real memory using the REBUILD INDEX
utility?
A. Increase the value of the PARALLEL option.
B. Decrease the value of the PARALLEL option.
C. Increase the value in the CURRENT DEGREE special register.
D. Decrease the value in the CURRENT DEGREE special register.
Answer: A