Explanation
Explanation/Reference:
QUESTION 8
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
A. REORG TABLE sales INPLACE RESETDICTIONARY
B. REORG TABLE sales INPLACE REBUILDDICTIONARY
C. REORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY
D. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 9 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?
A. SG1
B. SG2
C. IBMSTOGROUP
D. IBMDEFAULTTSG
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
Reference: https://www.tutorialspoint.com/db2/db2_storagegroups.htm
QUESTION 10
If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?
A. Set the DB2COMM registry variable to DB2COMM=SSL
B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP
C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT
D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT
Correct Answer: B
Section: (none)
Explanation