IBM C2090-312 IBM DB2 11 DBA for z/OS Exam Practice Test

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

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

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

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

MONITOR THREAD

MONITOR IDLE THREADS

MONITOR CONNECTIONS

MONITOR ACTIVE THREADS

CLASS(2, 7,8)

CLASS(1, 2,3)

CLASS(1, 5,10)

CLASS(1, 2, 3,7,8)

Issue the ACCESS command with appropriate keywords.

Issue the ARCHIVE command with the appropriate keywords.

Issue the STOP command for the appropriate set of statistics.

Issue the ALTER command with the appropriate memory location.

Changes to the BSDS.

RECOVER to CURRENT.

REORG with RBALRSN_CONVERSION EXTENDED.

SQL update activities (INSERT. UPDATE, DELETE, MERGE).

The first nn UPDATE operation(s) will use an indirect reference.

Only the first nn UPDATE operation(s) on the table will be processed.

nn% space is reserved per page for future UPDATE operations to reduce indirect reference.

nn row locations per page are kept for future UPDATE operations to reduce indirect reference.

A trigger can use global variables and change their contents.

A trigger can use global variables but cannot change their contents.

A trigger cannot use global variables but can change their contents.

A trigger cannot use global variables and cannot change their contents.

A one-to-one relationship.

A one-to-many relationship.

A many-to-one relationship.

A many-to-many relationship.

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.

DIST

IRLM

DBM1

MSTR