Skip to main content

C2090-611 Real Exam Questions

DB2 10.1 DBA for Linux UNIX and Windows

118 questions available · Page 1 of 12

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which command will define the alternate diagnostic data directory path as /db2data/db2dump2?

  1. A

    db2set ALT_DIAGPATH=/db2data/db2dump2

  2. B

    db2set SECONDARY_DIAGPATH=/db2data/db2dump2

  3. C

    UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

  4. D

    UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

Show answer and explanation

Correct answer: C

Question 2 Single choice

Which High Availability Disaster Recovery (HADR) synchronization mode provides the shortest transaction response time but has the highest probability of transaction losses if the primary system fails?

  1. A

    SYNC (synchronous)

  2. B

    ASYNC (asynchronous)

  3. C

    NEARSYNC (near synchronous)

  4. D

    SUPERASYNC (super asynchronous)

Show answer and explanation

Correct answer: D

Question 3 Single choice

Which authority is required to revoke SECADM authority?

  1. A

    DBADM

  2. B

    SECADM

  3. C

    SYSADM

  4. D

    SQLADM

Show answer and explanation

Correct answer: B

Question 4 Single choice

If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

  1. A

    Crash recovery

  2. B

    Version recovery

  3. C

    Disaster recovery

  4. D

    Roll-forward recovery

Show answer and explanation

Correct answer: A

Question 5 Single choice

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

  1. A

    DBADM

  2. B

    SYSADM

  3. C

    SQLADM

  4. D

    SECADM

Show answer and explanation

Correct answer: D

Question 6 Single choice

Which statement about DB2 aggregate registry variables is true?

  1. A

    An aggregate registry variable that is explicitly set by an application cannot be overwritten.

  2. B

    An aggregate registry variable overrides any corresponding explicitly set registry variable.

  3. C

    A registry variable that is explicitly set by an application can only be overwritten by aggregate registry

    variable.

  4. D

    A registry variable that is implicitly configured through an aggregate registry variable may also be

    explicitly defined.

Show answer and explanation

Correct answer: D

Question 7 Single choice

A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO

What is the recommended way to convert the database MYDB to an automatic storage database?

  1. A

    Use the ALTER DATABASE statement to add storage paths to the database.

  2. B

    Use the CREATE STOGROUP statement to define a new storage group in the database and to assign

    storage paths to the new storage group.

  3. C

    Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE

    configuration parameter for the database toYES.

  4. D

    Use the DROP DATABASE command to drop the database; then, recreate the database by executing

    a CREATE DATABASE commandstatement that does not contain the AUTOMATIC STORAGE NO
    option.

Show answer and explanation

Correct answer: B

Question 8 Single choice

What is the MAX_LOG database configuration parameter used for?

  1. A

    To limit how many log files a single transaction can span.

  2. B

    To limit the percentage of primary log space a running transaction can consume.

  3. C

    To limit the total number of primary and secondary log files a database can consume.

  4. D

    To limit the total number of secondary log files a transaction can consume before infinite logging is

    enabled.

Show answer and explanation

Correct answer: B

Question 9 Single choice

Which action can a DBA take to retrieve bufferpool metrics information?

  1. A

    Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the BP_HITRATIO

    table function.

  2. B

    Ensure the MON_ACT_METRICS configuration parameter is enabled and query the BP_HITRATIO

    administrative view.

  3. C

    Ensure the MON_OBJ_METRICS configuration parameter is enabled and query the

    MON_GET_BUFFERPOOL table function.

  4. D

    Ensure the MON_ACT_METRICS configuration parameter is enabled and query the

    MON_GET_BUFFERPOOL administrative view.

Show answer and explanation

Correct answer: C

Question 10 Single choice

How can you remove all effects of compression from an index?

  1. A

    Execute the ALTER INDEX statement to turn compression off.

  2. B

    Execute the ALTER TABLE statement to turn compression off.

  3. C

    Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to

    removed the compression dictionary.

  4. D

    Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command

    to tell the DB2 optimizer thatcompression is no longer used.

Show answer and explanation

Correct answer: C