Chat with us

Read online free dumps for IBM- C2090-312

Here you can read online questions and answers for IBM Exam C2090-312 (IBM DB2 11 DBA for z/OS Exam ) 100% free...

Question ID 22099

Which two options can be specified in order to access a system-period temporal table for a specific point in
time guaranteeing accurate results?

Option A

A period-specification placed in the FROM clause of a subselect.

Option B

A period-specification placed in the WHERE clause of a subselect

Option C

A SELECT statement predicate against the transaction start ID of the base table.

Option D

A predicate against the start and end columns of the base table placed in the WHERE clause of a
subselect.

Option E

A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to a
SELECT against the temporal table.

Correct Answer C,E
Description
Update Date and Time 2018-03-17 06:19:02

Question ID 22100

As part of a health check, it is determined that the statistics feedback should be externalized more
frequently. Optimizer statistics recommendations can be immediately externalized to the DB2 catalog by
performing what action?

Option A

Issue the ACCESS command with appropriate keywords.

Option B

Issue the ARCHIVE command with the appropriate keywords.

Option C

Issue the STOP command for the appropriate set of statistics.

Option D

Issue the ALTER command with the appropriate memory location.

Correct Answer A
Description
Update Date and Time 2018-03-17 06:19:55