C2090-611 Online Practice Questions and Answers

What is the MAX_LOG database configuration parameter used for?

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

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

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

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

Where are column mask definitions stored?

A. In the table definition

B. In the system catalog

C. In the table space metadata

D. In the database configuration file

Which authorities can be audited with the AUDIT statement?

A. SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.

B. SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.

C. SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.

D. DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

A. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;ALTER TABLESPACE my_ts REBALANCE;

B. ALTER TABLEPACE my_ts MANAGED BY DATABASE;ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE;ALTER TABLESPACE my_ts REBALANCE;

C. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot;ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';ALTER TABLESPACE my_ts REBALANCE;

D. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;ALTER STOGROUP sg_hot DROP '/db2/filesystem1', '/db2/filesystem2';ALTER TABLESPACE my_ts REBALANCE;

Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

A. db2pd

B. db2dart

C. db2look

D. db2mimic

What is an informational constraint?

A. A constraint that defines a relationship to a federated object.

B. A constraint that is used by the optimizer but is not enforced.

C. A constraint that provides Information to the RUNSTATS utility.

D. A constraint that is created from information supplied to the design advisor.

Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

A. CLIENT

B. SERVER

C. LDAP_PLUGIN

D. DATA_ENCRYPT

E. KERBEROS_PLUGIN

Which statement regarding snapshot administrative views and snapshot monitor table functions is true?

A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.

B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.

C. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.

D. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.

Which tool should be used to give you lock wait information from the DB2 memory sets?

A. db2pd

B. db2mtrk

C. db2fodc

D. db2support

When the ALTER TABLE DETACH operation is used to detach a single data partition from a partitioned table, at what point does the newly detached data partition become accessible as a standalone table?

A. After a SET INTEGRITY statement is executed.

B. After a truncate table operation is performed in the background.

C. Immediately after the ALTER TABLE DETACH statement is executed.

D. Immediately after asynchronous partition detach processing completes for this data partition.

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?

A. Crash recovery

B. Version recovery

C. Disaster recovery

D. Roll-forward recovery

What authority must be held to create a trusted context?

A. DBADM

B. SQLADM

C. SECADM

D. CONNECT

Given the following command: LOAD FROM newrows.del OF DEL INSERT INTO mytab ALLOW READ ACCESS Which statement(s) must be executed before applications can query the newly loaded data?

A. SET INTEGRITY FOR mytab IMMEDIATE CHECKED

B. ALTER TABLE mytab CHECK (COL IS VALIDATED)

C. ALTER TABLE mytab ALLOW READ ACCESS IMMEDIATE CHECKED

D. ALTER TABLE mytab ALLOW READ ACCESS;SET INTEGRITY FOR mytab IMMEDIATE UNCHECKED;

Which statement about triggers is FALSE?

A. A statement-level trigger fires only once for each SQL statement.

B. A trigger's code block can be executed either before or after a triggering event.

C. A row-level trigger fires once for each row that is affected by a triggering event.

D. A table-level trigger fires once for each table that is affected by a triggering event.

How can you obtain information about any changes that have been made by the Self-Tuning Memory Manager (STMM)?

A. By using the change history event monitor.

B. By using the DB2 problem determination tool.

C. By examining the contents of the system catalog.

D. By examining the DB2 administration notification log file.