IBM DB2 11 DBA for z/OS - C2090-312무료 덤프문제 풀어보기

A. SYSADM

B. SYSOPR

C. CREATEIN on the schema

D. SYSCTRL

A. The table space is placed in CHKP status.

B. It is checked against only new rows as they are added to the table.

C. It is checked against only all existing rows in the table.

D. It is rejected by the database system.

A. SYSIBM.SYSTATFEEDBACK

B. SYSIBM.SYSGUERYSEL

C. SYSIBM.SYSOUERYPREDICATE

D. SYSIBM.SYSVARIABLES_TEXT

A. If the partitioning key is ascending, DB2 prevents the INSERT of a row with a null value for the key column.

B. If the partitioning key is ascending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the first partition.

C. If the partitioning key is descending, DB2 allows the INSERT of a row with a null value for the key column. The row is inserted into the last partition.

D. If the partitioning key is descending, DB2 prevents the INSERT of a row with a null value for the key column.

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

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

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

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

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

A. REBINDEXPLAIN(YES)

B. REBINDCOPY

C. REBINDEXPLAIN(NO)

D. REBIND EXPLAIN(ONLY)

A. -DISPLAY DB(DB1)SPACENAM(TS1)

B. RUNSTATS TABLESPACE DB1TS1

C. -SET LOG LOGLOAD(O)

D. -ACCESS DB(DB1) SPACENAM(TSI) MODE(STATS)