Question 6 of 55

What is an advantage of using range partitioned tables?

    Correct Answer: B

    Range partitioned tables can significantly improve query performance by enabling partition elimination. This allows the database to scan only the relevant partitions instead of the entire table when executing queries, thus reducing the amount of data scanned and improving efficiency.

Question 7 of 55

A table named MYTABLE contains an XML column and an XML storage object dictionary already exists. What is the effect of enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY?

    Correct Answer: A

    Enabling compression and then running the command REORG TABLE mytable KEEPDICTIONARY will result in all data, both new and existing, being compressed. The KEEPDICTIONARY option instructs the command to retain and utilize the existing compression dictionary, thus compressing the data that was present before the reorganization as well as any new data added afterwards.

Question 8 of 55

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

    Correct Answer: C

    To resolve the problem without preventing users from changing data in the SALES table, the command should allow write access while resetting the compression dictionary. The command 'REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY' meets this criteria, as it resets the dictionary and permits ongoing write access during the reorganization process. This ensures minimal disruption to the database operations while optimizing performance by creating a new, efficient compression dictionary.

Question 9 of 55

If the following SQL statements are executed:

CREATE DATABASE testdb AUTOMATIC STORAGE NO;

CONNECT TO testdb;

CREATE STOGROUP sg1 ON /data1;

CREATE STOGROUP ibmstogroup ON /data2;

CREATE STOGROUP sg2 ON /data3;

Which storage group is the default storage group for the TESTDB database?

    Correct Answer: A

    When a database is created with the AUTOMATIC STORAGE NO clause, it does not automatically assign a default storage group. The first storage group created with the CREATE STOGROUP statement becomes the default storage group. In this case, the first storage group created after connecting to the TESTDB database is SG1, thus making SG1 the default storage group for the TESTDB database.

Question 10 of 55

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

    Correct Answer: A

    To enable Secure Sockets Layer (SSL) for DB2, you must set the DB2COMM registry variable to include SSL. This parameter ensures that DB2 will communicate using SSL, which is necessary for encrypting data in transit. Option A, which sets the DB2COMM registry variable to 'DB2COMM=SSL', is correct for meeting the requirement for SSL. It ensures that SSL is a communication protocol used by the DB2 instance, fulfilling the requirement for encrypting data in transit.