A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 1)

A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 1)

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • An employee is not able to connect to the PRODDB database using the correct user I...

  • While attempting to establish connectivity between a Windows client and a UNIX ser...

  • A DBA has established connectivity to a DB2 for z/OS database and is exploiting a ...

  • Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

  • What determines the degree of inter-partition parallelism used?

  • A journaling application inserts data with continually increasing sequential keys ...

  • Which command will prevent prefetching during crash recovery?

  • Which two operators would indicate inter-partition parallelism in an Optimizer Pla...

  • A table named TAB_A was created with the COMPRESS YES option specified and populat...

  • Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value o...

  • If you know that the table space containers for your database reside on RAID-5 3+p...

  • Which statement is true about clustering indexes in a partitioned database?

  • Which conditions must be met to implement HADR?

  • Which command will back up a database named SAMPLE to a TSM server using two concu...

  • What is the proper set of steps to execute a redirected restore and change the con...

  • Given the following output from the GET DATABASE CONFIGURATION command:Which of th...

  • What are two authorities and/or privileges required for replaying SQL audit logs? ...

  • At which two levels can events be audited? (Choose two.)

  • What will the db2audit facility do when a DB2 database instance is stopped?

  • If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_E...

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

  • A2090-544 Assessment DB2 9.7 Advanced DBA for LUW - Assessment (Exam 1) QR code

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings