[2026] IBM Certified Database Administrator - DB2 10 for z/OS

문제1

What is the one significant difference between sequenceobjects and identity columns?

A. Identity columns can be defined on tables and sequence objects cannot.

B. Identity columns can cache values and sequence objects cannot.

C. Sequence object values can be used as primary keys and identity column values cannot.

D. Sequence objects can have a character data type and identity columns cannot.

정답: A

문제2

What is the DSNZPARM thatdetermines the maximum amount of temporary storage in the work file data base for a single user at any given time?

A. MAXKEEPD

B. MAXRBLK

C. MAXDBAT

D. MAXTEMPS

정답: D

문제3

The frequency of data being changed for several tables in the new Billing application is very unpredictable. A different approach to manage Runstats for these objects is desired.
To provide additional information on update patterns for the new Billing Application, the DBA can use what information to better understand the unpredictable workload patterns on the tablespaces?

A. SYSIBM.SYSSTATS

B. SYSIBM.SYSCOPY

C. SYSIBM.SYSTABLESPACESTATS

D. SYSIBM.SYSTABLES

정답: C

문제4

An EBCDIC table t1 and a UNICODE table t2 are joined by t1.col1=t2.col2. Which statement is true?

A. col2 is converted to EBCDIC

B. SQLCode-270: Function not supported

C. col2 and col1 are converted to UTF-32

D. col1 is converted to UNICODE

정답: D

문제5

When planning for disaster recovery, which two items are NOT required to send to the remote site? (Choose two.)

A. Backups of the DB2 catalog and directory.

B. Image copies of indexes.

C. A copy of your ICF catalog.

D. Image copies of table spaces.

E. DB2 archive logs.

정답: B,C

문제6

An object (table space, index space or a physical partition of a table space or index space) is in AREST or RESTP status. If backout activity is not already underway, what should occur?

A. Issue a RECOVER POSTPONED command.

B. Issue a START command with ACCESS(RW).

C. Recycle the system with the system parameter LBACKOUT=NO.

D. Issue a STOPcommand and then a START command with ACCESS(RW).

정답: A

문제7

Compression is desired for index IX1. The current definition of IX1 is as follows: CREATE INDEX IX1 ON TAB1(COL1 ASC) USING STOGROUP STG1 BUFFERPOOL BP1 ; Which of the following activities must be performed first in order to compress the existing index IX1?

A. Compress the tablespace.

B. Copy the index.

C. REBUILD the index.

D. ALTER the index to use a page size larger than 4K.

정답: D

문제8

Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?

A. ALTER TABLE TB1 ADD COLUMN COLC DATE;

B. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS
SECURITY LABEL;

C. ALTER TABLE TB1 AUDIT CHANGES;

D. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;

정답: A

문제9

The following SQL statement is issued: SELECT col1 FROM tb1 ORDER BY col1 ASC The following results are received: 1111 AAAA Which statement is true?

A. This is expected behavior and independent of the encoding scheme.

B. Theencoding scheme of the table is EBCDIC.

C. This could never happen, this is an error and must be reported.

D. The encoding scheme of the table is UNICODE.

정답: D

IBM Certified Database Administrator - DB2 10 for z/OS - 000-612무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트