C2090-612 DB2 10 DBA for z OS (Exam 2)

C2090-612 DB2 10 DBA for z OS (Exam 2)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • When is a merge scan join a well performing access path?

  • When determining what page size will be best for index compression, which utility ...

  • The new billing application is seeing Class 2 Elapsed Time being made up of mainly...

  • What must be in place for the support of index compression?

  • How do you enable parallelism in a dynamic SQL statement?

  • The access path chosen for a query shows a table space scan, when it appears that ...

  • You have been asked to find packages that use isolation level UR in dynamic SQL. W...

  • Which of the following techniques CANNOT be used to implement DB2 based row level ...

  • If security administration is separated from system and database administration, v...

  • Which DSNZPARM parameter controls the number of locks that may be acquired on a ta...

  • In order to communicate a DISPLAY DATABASE (DB1) SPACENAM (TS1) command execution ...

  • What is a potential consideration when using triggers?

  • Given the following CREATE TABLE statement: CREATE TABLE TB1 (C1 CHAR(4), C2 XML, ...

  • You want to ALTER a table space specifying MAXPARTITIONS 256. For which table spac...

  • Compression is desired for index IX1. The current definition of IX1 is as follows:...

  • A table is created using the ORGANIZED BY HASH UNIQUE syntax, what action should o...

  • Why does the following DDL command fail? CREATE INDEX X1 ON T1 (COL1, COL2, COL3,B...

  • Which of the following tasks cannot be done via a single ALTER TABLE statement?

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

  • When these two commands are issued in sequence, one after the other: STOP FUNCTION...

Be the first to review
Login and Review
  • info
    Quiz Info
  • date_range
    Feb. 8, 2016, 3:45 a.m.
    help_outline
    20 questions
    dvr
    0 completed
    remove_red_eye
    0 views
    people
    0 takers
    folder
    IBM

  • C2090-612 DB2 10 DBA for z OS (Exam 2) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings