Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 IN DB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATETABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ; COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 on COL1 on TB1?
A. ALTER TABLESPACE TS1
MAXPARTITIONS 15;
B. CREATE INDEX IX1 ON TB1
(COL1);
C. COMMIT;
D. REORG TABLESPACE TS1;
正解:B
質問 2:
Which clone table statement iscorrect?
A. The clone and base tables must have different schema names.
B. A clone table can have its own indexes.
C. A clone table has its own catalog statistics.
D. The clone and base tables share a table space.
正解:D
質問 3:
A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should occur?
A. Create a clustering index on the hash columns.
B. Specify the column names to be hashed.
C. Create a unique index on the hash columns.
D. Create a unique clustering index on the hash columns.
正解:B
質問 4:
Which statement applies to the command STOP DB(MYDB*) SP(*) AT(COMMIT)?
A. Does not apply tothreads that were defined with RELEASE(COMMIT).
B. Applies to both RELEASE(COMMIT) and RELEASE(DEALLOCATE) at the next
COMMIT point.
C. Does not apply to threads that were defined with RELEASE(DEALLOCATE).
D. Applies to RELEASE(COMMIT) at the next COMMIT point and to
RELEASE(DEALLOCATE) at thread end.
正解:B
質問 5:
Altering the DSSIZE is allowed for what type of table space?
A. Universal table space.
B. Segmented table space.
C. DSSIZEcannot be altered.
D. XML table space.
正解:A
質問 6:
Whenspecifying "A" for the acceptance option in the column SECURITY_IN in the SYSIBM.LUNAMES catalog table, which statement is correct?
A. For outbound requests, the encrypted password is extracted from RACF.
B. An inbound ID is subject to translation.
C. A request does not need an authentication token.
D. With this option, VTAM cannot be defined with SECACPT=ALREADYV.
正解:C
質問 7:
If security administration isseparated from system and database administration, via zparm, which level of authority is required to define roles or trusted contexts?
A. INSTALL SYSOPR
B. SYSADM
C. SECADM
D. DBADM
正解:C
質問 8:
What should be implemented in order to audit all the activity of the install SYSADM?
A. A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
B. Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
C. The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID.
D. DATA CAPTURE CHANGES should be set on all tables.
正解:A
質問 9:
Which option allows the UNLOAD utility to unload LOBs into output files together with non- LOB data?
A. SPANNED YES
B. DSNTYPE HFS on the TEMPLATE
C. DELIMITED
D. DSNTYPE LIBRARY or PDS on the TEMPLATE
正解:A