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

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

created by Fisher BRink (@fisher) at Feb. 8, 2016
  • A database named MYDB is created in instance DB2INST1, which has been configured t...

  • A DBA has configured an Oracle data source in a federated database (that reference...

  • If table space TBSP1 is using automatic storage, and the existing storage paths ar...

  • A database named MYDB was created by executing the following command: CREATE DATAB...

  • Which data organization schemes are supported?

  • How can you change an existing non-partitioned index for a partitioned table to a ...

  • The DBA needs to create a table with key columns YEARDAY, YEAR, and DAY. This tabl...

  • Given the following statement:Which statement will successfully add a new partitio...

  • A Windows user with a local database is not able to connect to a zOS database. The...

  • Which command CANNOT be used to explicitly build a compression dictionary for a ta...

  • Which statement about compression and temporary tables is NOT correct?

  • What steps, in the correct order, are performed by the SQL and XQuery compilers to...

  • Which database manager configuration parameter is used to set an instance-wide sof...

  • When an agent that is connected to the database finishes its work of successfully ...

  • Which of the following techniques will ensure that you CANNOT encounter two active...

  • A database recovery operation (RECOVER DATABASE) failed during the roll forward ph...

  • A primary and standby database are enabled for HADR and are in peer state. The HAD...

  • Which method should be used to construct an LBAC security component that represent...

  • You have a database with eight partitions on a single server. Immediately after ex...

  • Which action can be performed by the ALTER TABLESPACE statement?

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

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

Ratings

star_borderstar_borderstar_borderstar_borderstar_border
ratings