A2090-544 Online Practice Questions and Answers

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.

B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

Which statement is true about clustering indexes in a partitioned database?

A. The partitioning key column(s) should be added to the clustering index with the INCLUDE option.

B. The clustering index column(s) should be suffixed by the partitioning key column(s).

C. The clustering index column(s) should be prefixed by the partitioning key column(s).

D. The partitioning key column(s) should be added immediately after the column in the clustering index with the highest cardinality.

Which of the following techniques will ensure that you CANNOT encounter two active primary servers in an HADR pair?

A. Set ALTERNATER SERVER to fixed IP Addresses on both servers.

B. Use a virtual IP Address for both servers.

C. Use a virtual IP Address in the CATALOG DATABASE command.

D. Catalog both servers separately and use a fixed IP address for both servers.

If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

A. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.

B. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.

C. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.

D. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.

What is a method for enabling non-buffered I/O at the table space level in a DB2 database?

A. Set the DB2_DIRECT_IO configuration parameter to YES.

B. Set the DB2_FILESYSTEM_CACHE configuration parameter to YES.

C. Use the USE DIRECT IO clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

D. Use the NO FILE SYSTEM CACHING clause with the CREATE TABLESPACE or ALTER TABLESPACE command.

A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups

taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a

Saturday prior to the full backup being taken.

What is the fastest way to restore the database?

A. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

B. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

C. RESTORE DB proddb TAKEN AT (Friday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);

D. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

Which statement is correct about statistical views?

A. A statistical view is created by executing runstats on a regular view.

B. A statistical view holds information about the system catalog statistical tables.

C. A statistical view provides the optimizer with additional correlation statistics.

D. A statistical view provides the optimizer with more accurate cardinality estimates.

A table named TAB_A was created with the COMPRESS YES option specified and populated with 100,000 rows. If a DBA wants to create an index on table TAB_A, which statement is true?

A. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option with the CREATE INDEX statement that is used to create it.

B. The index will automatically be compressed since the table it is associated with is compressed; the ALTER INDEX command does not have to be executed.

C. In order for the index to be compressed, it must be enabled for compression by specifying the COMPRESS YES option in the CREATE INDEX statement used to create it; however, the index will not be compressed until the ALTER INDEX command is used to create an index compression dictionary.

D. The index will automatically be enabled for compression because the associated table is compressed; however, the index will not be compressed until it is REORGed.

At which two levels can events be audited? (Choose two.)

A. Instance level

B. Database level

C. Server level

D. Operating System level

E. Node level

A Windows user with a local database is not able to connect to a zOS database. The System Database Directory and the Node Directory have the correct entries. Other users can connect to the database from their workstations without problems. What should be done resolve the problem?

A. Uncatalog and re-catalog the directory entries for the zOS database and try again.

B. Catalog the zOS database in the Local Database Directory.

C. Catalog the zOS database in the Database Connection Services Directory.

D. Catalog the zOS database in the Distributed Data Facility Directory.