C2090-600 exam

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 . SG1B . SG2C . IBMSTOGROUPD ....

Which of the following statements about compression for BLU MPP tables is TRUE?A . Compression must be explicitly enabled for BLU MPP tablesB . Compression requires decompression to evaluate partition joinsC . Unique compression dictionaries are generated for each partitionD . Each table has a single compression dictionary that getsreplicated...

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...

What is an advantage of using range partitioned tables?A . Abilityto run utilities against the partitions in parallelB . Increased query performance through data partition eliminationC . Block indexes are much smaller than RID indexes, providing better performanceD . Table data is automatically and continuously clustered, requiring minimal reorganizationView AnswerAnswer:...

Which of the following are valid Explain operators? (Choose two.)A . CTQB . XSCANC . IXSCAND . SELECTE . COLSCANView AnswerAnswer: B,A

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=SSLB . Set the DB2COMM registry variable to DB2COMM=SSL, TCPIPC . Set the AUTHENTICATION configuration parameter to DATA_ENCRYPTD . Set the AUTHENTICATION configuration...

Which security mechanism is responsible for verifying that users are indeed who the claim to be?A . AuthenticationB . Roles and privilegesC . Mandatory access controlD . Discretionary access controlView AnswerAnswer: A

Assuming no database connections exist, which of the following will dynamically change the LOCKLIST database configuration parameter for a database named SAMPLE to AUTOMATIC?A . UPDATE DB CFG FOR sample USING LOOCKLIST AUTOMATIC IMMEDIATEB . UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATEC . CONNECT TO sample; UPDATE...

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)A . Catalog a storage access alias in the DB2 databaseB . Create an FTP account on IBM Softlayer Object StorageC . Use the DB2REMOTE parameter of...

Which statement about label-based access control (LBAC) is TRUE?A . LBAC protection can be applied to a nicknameB . LBAC cannot be used to restrict access to a staging tableC . LBAC cannot be used to restrict access to data of columns and rows in the same tableD . LBAC...