Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

Dumpsbuddy Logo
  1. Home
  2. IBM
  3. IBM Information Management
  4. C2090-312
  5. IBM DB2 11 DBA for z/OS Questions and Answers
Note! IBM has retired the C2090-312 Exam Contact us through Live Chat or email us for more information.

C2090-312 IBM DB2 11 DBA for z/OS Questions and Answers

Questions 4

You must be able to process recoveries for DB2 objects to any point in time between now and two weeks ago.

What is the recommended amount of recovery data needed?

Options:

A.

One set of SHRLEVEL(CHANGE) full image copies every two weeks that are kept for at least two weeks.

B.

One set of SHRLEVEL(CHANGE) full image copy at least every week that are kept for at least three weeks as well as the active/archive logs during that time.

C.

One set of SHRLEVEL(CHANGE) full images copies at least every week that are kept for at least two weeks as well as the active/archive logs during that time.

D.

One set of SHRLEVEL(CHANGE) full images copies during week#1 and one set of

SHRLEVEL(REFERENCE) incremental images copies during week #2, all are kept for at least two weeks.

Buy Now
Questions 5

When would DB2 NOT use list prefetch?

Options:

A.

Fast log apply operations.

B.

Reading leaf pages of a disorganized index.

C.

RUNSTATS TABLESPACE without table sampling.

D.

Incremental image copies of a table space defined with TRACKMOD YES.

Buy Now
Questions 6

You want to convert a segmented table space into a partition-by-growth table space. You execute the following ALTER statement:

ALTER TABLESPACE DB1TS1 MAXPARTITIONS 5;

What should be your next step?

Options:

A.

COPY the table space.

B.

REORG the table space.

C.

REBUILD all of the indexes.

D.

DROP the segmented table space.

Buy Now
Questions 7

What does the UNLOAD utility allow you to unload?

Options:

A.

Index entries from an index image copy.

B.

Rows from an image copy after the table has been dropped.

C.

Rows from an image copy after columns have been dropped.

D.

Rows from a sequential image copy created by the COPYTOCOPY utility.

Buy Now
Questions 8

What is a general recommendation for when to rebind?

Options:

A.

After a backup is taken.

B.

After a subsystem restart.

C.

Before maintenance is applied.

D.

After a major change in data volume.

Buy Now
Questions 9

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

Options:

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.

Buy Now
Questions 10

Which DB2 Client command can be used to identify the Client's version?

Options:

A.

db2fm

B.

db2look

C.

db2level

D.

db2ldcfg

Buy Now
Exam Code: C2090-312
Exam Name: IBM DB2 11 DBA for z/OS
Last Update: Apr 14, 2023
Questions: 67