Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C2090-312 Questions and Answers

Note! Following C2090-312 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

C2090-312 Questions and Answers

Question # 6

Which DB2-supplied stored procedure captures statistics and DDL for DB2 objects, extracts subsystem parameters and explain information for queries and applications, and returns the results in a data set or as a result set?

A.

ADMIN_INFO_SQL

B.

ADMIN_JOB_QUERY

C.

ADMIN_INFO_SYSPARM

D.

ADMIN UPDATESYSPARM

Full Access
Question # 7

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?

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.

Full Access
Question # 8

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.

Full Access
Question # 9

Which DB2 subsystem parameter limits the number of concurrent active TSO requests?

A.

IDBACK

B.

IDFORE

C.

MAXDBAT

D.

CONDBAT

Full Access
Question # 10

Which SQL statement can be used to create a data type that will represent possible speed limit values, with valid values not greater than 99, and to create a table that contains route numbers and the maximum speed limit for each route?

A.

CREATE TYPE SPEEDJJMIT AS SMALLINT; CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT, MAX_SPEED SPEEDJJMIT);

B.

CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEEDJJMIT);

C.

CREATE TYPE SPEEDJJMIT AS DECIMAL(2.0); CREATE TABLE STATEJHIGHWAYS (ROUTE_NO SMALLINT. SPEED_LIMIT);

D.

CREATE TYPE SPEEDJJMIT USING DECIMAL(2.0); CREATE TABLE STATE_HIGHWAYS (ROUTE_NO SMALLINT. MAX_SPEED SPEED_LIMIT);

Full Access