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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • Your current backup strategy is to run COPY SHRLEVEL CHANGE for all your table spa...

  • The -DIS UTIL(REORGON) command was entered for a REORG utility with SHRLEVEL CHANG...

  • What is one of the first key steps in preparing to use the BACKUP SYSTEM utility?

  • The application will be handling a large volume of input data that will need to be...

  • Which option allows the UNLOAD utility to unload LOBs into output files together w...

  • Which two of the following DB2 performance features will ignore clustering in favo...

  • When DB2 detects at runtime requiring a large amount of data to be read, which pre...

  • In order to retain an access path across a rebind which of the following commands ...

  • The available window to reorganize table spaces is being reduced. What data can pr...

  • In using plan stability, what storage space requirement should be of carefully mon...

  • What two parameters allow DB2 to keep a copy of a dynamically prepared statement i...

  • What START TRACE command provides detailed lock suspend and lock contention trace ...

  • What would be a reason for altering the clustering index of a table?

  • What is the DSNZPARM that determines the maximum amount of temporary storage in th...

  • What DB2 command when issued displays what migration mode the catalog is in?

  • Which authority level allows a user to run utilities that change the data in an ap...

  • When creating a stored procedure that will access non DB2 resources using the auth...

  • Which connection type can exploit trusted connections?

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

  • Given that the following table (TB1) has been created with this statement: CREATE ...

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
    2 views
    people
    0 takers
    folder
    IBM

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings