Skip to main content

C2090-541 Real Exam Questions

DB2 9.7 DBA for Linux UNIX and Windows

101 questions available · Page 1 of 11

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

A database named FINANCE must be available to users 24x7x365.

Which command should be used to create a backup image of the FINANCE database without having a significant impact on running applications?

  1. A

    BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_PRIORITY 15

  2. B

    BACKUP DATABASE finance ONLINE TO /mnt/backup PARALLELISM 5

  3. C

    BACKUP DATABASE finance ONLINE TO /mnt/backup UTIL_IMPACT_LIM 50

  4. D

    BACKUP DATABASE finance ONLINE TO /mnt/backup COMPRESS

Show answer and explanation

Correct answer: A

Question 2 Single choice

Due to an application error, some data was deleted from a very large table residing in table space TS1. The table space was then renamed TS2 before the error was detected. Rather than try and rebuild this table, it was decided that database DB1 would be restored and then rolled forward to a point-in-time (PIT) before the delete operation took place. Unfortunately the PiT roll forward was done to a time that was too early and some critical transactions were missing when the database was brought back on-line.

Which steps must be taken to ensure that the critical transactions which are currently missing from the database are correctly applied to the database and that table space TS1 is renamed TS2?

  1. A

    1. Restore database DB1.
    2. Roll forward to the correct point-in-time.
    3. Rename TS1 to TS2.

  2. B

    1. Restore table space TS1 from the DB1 backup image.
    2. Roll forward to the correct point-in-time.
    3. Rename table space TS1 to TS2.
    4. Re-run the batch processes.

  3. C

    1, Restore database DB1
    2. Roll forward to end of logs.

  4. D

    1. Restore table space TS1 from the DB1 backup image.
    2. Roll forward to end of logs.

Show answer and explanation

Correct answer: A

Question 3 Single choice

Which DB2 monitoring tool command can collect data on databases, sessions, buffer pools, tables, and dynamic SQL?

  1. A

    db2dart

  2. B

    db2fodc

  3. C

    db2top

  4. D

    db2pm

Show answer and explanation

Correct answer: C

Question 4 Single choice

Which SQL statement will execute successfully?

  1. A

    CREATE TABLE customer
    (custid INTEGER,
    custinfo XML NOT NULL PRIMARY KEY)

  2. B

    CREATE TABLE customer
    (custid INTEGER,
    custinfo XML(1 M) NOT NULL PRIMARY KEY)

  3. C

    CREATE TABLE customer
    (custid INTEGER NOT NULL PRIMARY KEY,
    custinfo XML)

  4. D

    CREATE TABLE customer
    (custid INTEGER NOT NULL PRIMARY KEY,
    custinfo XML( 10000))

Show answer and explanation

Correct answer: C

Question 5 Multiple choice

Which two tasks can DB2 Workload Management do? (Choose two.)

  1. A

    Audit users, who did what and when.

  2. B

    Automatically change DB2 dbm and db configuration.

  3. C

    Limit the number of disruptive database activities that can run concurrently

  4. D

    Stop the execution of activities that exceed defined boundaries.

Show answer and explanation

Correct answers: C, D

Question 6 Single choice

What will collect information about dynamic and static SQL statements?

  1. A

    MON_GET_PKG_CACHE_STMT table function

  2. B

    SNAP_GET_DYN_SQL table function

  3. C

    SNAPDYN_SOL administrative view

  4. D

    MON GET WORKLOAD table function

Show answer and explanation

Correct answer: A

Question 7 Multiple choice

A database named FINANCE resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database.

Which two actions must be performed before a backup image can be created in this manner? (Choose two.)

  1. A

    The TOOLS catalog must be created for the instance to which the database belongs.

  2. B

    DB2 Advanced Copy Services (ACS) must be installed, activated, and configured.

  3. C

    The DB2 High Availability (HA) features must be available for the server.

  4. D

    Workload Manager must be installed on the server.

Show answer and explanation

Correct answers: B, C

Question 8 Multiple choice

What are three authorization categories in DB2? (Choose three.)

  1. A

    System-level

  2. B

    Database-level

  3. C

    Network-level

  4. D

    Object-level

  5. E

    Instance-level

Show answer and explanation

Correct answers: A, B, D

Question 9 Single choice

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement shown below is run? SET CURRENT MDC ROLLOUT MODE IMMEDIATE

  1. A

    MDC rollout optimization is not used. The RID indexes are updated immediately during the delete process.
    The deleted blocks are available for reuse after the transaction commits.

  2. B

    MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after the transaction commits.

  3. C

    MDC rollout optimization is not used. The DELETE statement is processed in the same way as a DELETE statement that does not qualify for rollout.

  4. D

    MDC rollout optimization is used. The RID indexes are updated immediately during the delete process. The deleted blocks are available for reuse after an online REORG with the new RECLAIM EXTENTS clause.

Show answer and explanation

Correct answer: B

Question 10 Multiple choice

For which two events is it recommended to execute RUNSTATS? (Choose two.)

  1. A

    When a table is created.

  2. B

    When row compression has been enabled.

  3. C

    When LOAD with STATISTICS has been run.

  4. D

    When a table is altered by adding new columns.

Show answer and explanation

Correct answers: B, C