DB2 10 DBA for z/OS v6.0 (C2090-612)

Page:    1 / 9   
Total 136 questions

During a recovery of a table space in a data sharing environment, what value is used to coordinate the log records across the DB2 members?

  • A. RBA
  • B. LRSN
  • C. ROWID
  • D. SYSPITRT


Answer : B

In order to retain an access path across a rebind which of the following commands could be used?

  • A. BIND PLAN
  • B. REBIND PACKAGE(PK1) REOPT(ONCE)
  • C. BIND PACKAGE (PK1) EXPLAIN(YES)
  • D. REBIND PACKAGE (PK1) PLANMGMT(BASIC)


Answer : D

Which ALTER TABLE statement will generate a new table space version?

  • A. ALTER TABLE ... ADD PARTITION ...
  • B. ALTER TABLE ... ADD COLUMN COL2 ...
  • C. ALTER TABLE ... DATA CAPTURE CHANGES ...
  • D. Altering an already existing VARCHAR column on the table to shorten its maximum length.


Answer : B

Which stored procedures need to be set up properly in order to register an XML schema?

  • A. XSR_ADD_SCHEMA
  • B. XSR_REGISTER and XSR_COMPLETE
  • C. XSR_REGISTER, XSR_VALIDATE and XSR_COMPLETE
  • D. The commands to register a XML schema do not invoke stored procedures.


Answer : B

Which trace gives information about frequent log space shortages?

  • A. Audit trace class(8)
  • B. Statistics trace class(3)
  • C. Accounting trace class(10)
  • D. Performance trace class(4)


Answer : B

Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)
A. SECADM authority.
B. ACCESSCTRL authority.
C. DATAACCESS authority.
D. SYSADM authority when SEPARATE_SECURITY=NO.
E. The owner of the object as he/she has that authority implicitly.



Answer : A,D Topic 2, Volume B

Your table space DB1.TS1 is currently index-partitioned. Which steps should be performed at a minimum to make it a partitioned-by-range table space?

  • A. Issue ALTER TABLESPACE with a valid SEGSIZE > 0
  • B. Make the table space table-partitioned, then issue ALTER TABLESPACE with a validSEGSIZE > 0
  • C. Drop the partitioning index, ALTER the table definition by adding partition ranges to the existing table definition, then issue ALTER TABLESPACE with a valid SEGSIZE > 0
  • D. Drop the partitioning index, ALTER the table definition by addingpartition ranges to the existing table definition, create a partitioned index and issue ALTER TABLESPACE with a valid SEGSIZE > 0


Answer : B

A LOB column with BLOB(40) INLINE LENGTH 40 has been defined. Which statement is correct?

  • A. The data is only stored in the auxiliary table.
  • B. The data is only stored in the base table.
  • C. The complete data is storedboth in auxiliary and in base table.
  • D. The first part of the data is stored in the base table and second part is stored in the auxiliary table.


Answer : B

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

  • A. Identity columns can cache values and sequence objects cannot.
  • B. Identity columns can be defined on tables and sequence objects cannot.
  • C. Sequence objects can have a character data type and identity columns cannot.
  • D. Sequence object values can be used as primary keys and identity column values cannot.


Answer : B

Altering the DSSIZE is allowed for what type of table space?

  • A. XML table space.
  • B. Universal table space.
  • C. Segmented table space.
  • D. DSSIZEcannot be altered.


Answer : B

What WLM action will establish performance objectives for DDF threadsand their related address space?

  • A. Insure the NUMTCB is set to a value greater than 10.
  • B. Specify DDF for the value of APPLENV to the name of the WLM environment.
  • C. Execute the WLM_REFRESH stored procedure for the DDF application environment.
  • D. Createa WLM service definition that assigns service classes to the DDF threads.


Answer : D

When determining what page size will be best for index compression, which utility can be used to provide information on space saved and potential buffer space wasted for each of the different page sizes?

  • A. DIAGNOSE
  • B. DSN1COMP
  • C. DSN1PRNT
  • D. DSN1LOGP


Answer : B

Click on the exhibit to view properly coded XML data. Some employees have been assigned assistants. Which two are the leanest, most efficient XML indexes to get both the names and phone numbers of employees who are not assistants?

  • A. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USINGXMLPATTERN '//phone' as sql varchar(20);
  • B. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '//name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/phone' as sql varchar(20);
  • C. CREATE INDEX empname1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '//phone' as sql varchar(20);
  • D. CREATE INDEX empname1 ON dept(info) GENERATE KEY USINGXMLPATTERN '/deptinfo/employee/name' as sql varchar(20); CREATE INDEX empphone1 ON dept(info) GENERATE KEY USING XMLPATTERN '/deptinfo/employee/phone' as sql varchar(20);


Answer : D

DB2 workfiles are critical to performance of applications. Which of the following will NOT assist withachieving best performance for workfile usage?

  • A. Create several 4K and 32K workfiles.
  • B. Assign workfiles to their own bufferpools.
  • C. Assign workfiles to their own DASD volumes.
  • D. Create one large workfile for the data sharing group.


Answer : D

When is changing an index from non-clustering to clustering NOT allowed?

  • A. If the table space isdefined as member cluster.
  • B. If the data is not ordered by the new clustering index.
  • C. If the new clustering index is for a table that uses hash organization.
  • D. If the new clustering index OBID is greater than the old clustering index OBID.


Answer : C

Page:    1 / 9   
Total 136 questions