C2090-611 Online Practice Questions and Answers

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

Which command can be used to restore a corrupted database using only the recovery history file?

A. RESTART DATABASE

B. RECOVER DATABASE

C. RESTORE DATABASE

D. ROLLFORWARD DATABASE

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

A. db2set ALT_DIAGPATH=/db2data/db2dump2

B. db2set SECONDARY_DIAGPATH=/db2data/db2dump2

C. UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

D. UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

An existing non-automatic storage database named MYDB has been successfully converted to an automatic storage database. What must be done to convert any existing DMS table spaces to automatic storage table spaces?

A. Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC STORAGE IMMEDIATE.

B. Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO AUTOMATIC STORAGE.

C. Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP clause specified for each DMS table space that is to beconverted.

D. Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC STORAGE clause specified for each DMS table space that isto be converted.

Which statement about BEFORE triggers is FALSE?

A. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.

B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.

C. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.

D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.

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 is true about Insert Time Clustering (ITC) tables?

A. An existing MDC table can be converted to an ITC table.

B. ITC tables have similar characteristics to MDC tables, except they don't use block indexes.

C. The ITC table is an MDC table defined with a single TIMESTAMP type column in the ORGANIZE BY clause.

D. ITC tables are created with the CREATE TABLE command by specifying the ORGANIZE BY INSERT TIME clause.

Which command is used to import connectivity configuration information from a file known as a configuration profile?

A. db2ca

B. db2cfexp

C. db2cfimp

D. db2cfgimp

The following statement is run:

Which statement about the ACCT_BALANCE column is true?

A. Values stored in the ACCT_BALANCE column are visible to all users.

B. Values stored in the ACCT_BALANCE column are not visible to any user.

C. Values stored in the ACCT_BALANCE column are only visible to users with the ACCOUNTING role.

D. Values stored in the ACCT_BALANCE column are not visible to users with the ACCOUNTING role.

Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?

A. DB2_INDEX_DEFAULT

B. DB2_EXTENDED_OPTIMIZATION

C. DB2_INDEX_PCTFREE_DEFAULT

D. DB2_ENABLE_AUTOCONFIG_DEFAULT