NEW QUESTION 1
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

• A. When the registry variableDB2_AUTORECLAIMSPACE=YES
• B. After termination all the back-end processes using TERMINATE command
• C. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
• D. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Answer: C

NEW QUESTION 2
Which of the following enables the user to connect to the HADR standby database and execute select statements?

• A. DB2_HADR_ROS
• B. HADR_SPOOL_LIMIT
• C. DB2_HADR_SOSNDBUF
• D. DB2_HADR_PEER_WAIT_LIMIT

Answer: A

NEW QUESTION 3
Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

• A. SELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
• B. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;
• C. SELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;
• D. SELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

Answer: C

NEW QUESTION 4
Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

• A. db2cluster –cfs –list –filesystem datafs
• B. db2cluster –cfs –display –filesystem datafs
• C. db2cluster –cfs –listconfig –filesystem datafs
• D. db2cluster –cfs –displayconfig –filesystem datafs

Answer: A

NEW QUESTION 5
Which statement about label-based access control (LBAC) is TRUE?

• A. LBAC protection can be applied to a nickname
• B. LBAC cannot be used to restrict access to a staging table
• C. LBAC cannot be used to restrict access to data of columns and rows in the same table
• D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer: D

NEW QUESTION 6
Which ALTER TABLE statements will put a table named TAB1 in “reorg-pending” state? (Choose two.)

• A. ALTER TABLE tab1 APPEND ON
• B. ALTER TABLE tab1 DROP COLUMN col1
• C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
• D. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
• E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

Answer: BC

NEW QUESTION 7
Which phase of the LOAD utility is unique to loading column organized tables?

• A. LOAD
• B. BUILD
• C. DELETE
• D. ANALYZE

Answer: D

NEW QUESTION 8
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

• A. Select from the ADMIN_GET_ENCRYPTION_INFO table function
• B. Run the db2ckbkp command and verify the compression settings
• C. Checkthe encrypted database parameter in database configuration
• D. Check ENCROPTS database configuration parameter for encryption options

Answer: D

NEW QUESTION 9
Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

• A. CONNECT TO mydbPRUNE HISTORY TO /outdir
• B. db2trc on –db mydb –m “backup,load”run the desired operationsdb2tc dumpdb2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off
• C. BACKUP DATABASE mydb NO TABLESPACE TO /outdir
• D. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump <outfile>

Answer: B

NEW QUESTION 10
What is the result of the following scenario?

• A. The row is updated to (2, NULL)
• B. The row is updated to (2, 110.00)
• C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed
• D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Answer: B

NEW QUESTION 11
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 IMMEDIATE
• B. UPDATE DB CFG FOR sample USING LOOCKLIST 8192 AUTOMATIC IMMEDIATE
• C. CONNECT TO sample;UPDATE DB CFG FOR sample USINGLOCKLIST AUTOMATIC IMMEDIATE;CONNECT RESET;
• D. ATTACH TO db2inst1;UPDATE DB CFG FOR sample USING LOCKLIST AUTOMATIC;DETACH;

Answer: C

NEW QUESTION 12
What is an advantage of using range partitioned tables?

• A. Abilityto run utilities against the partitions in parallel
• B. Increased query performance through data partition elimination
• C. Block indexes are much smaller than RID indexes, providing better performance
• D. Table data is automatically and continuously clustered, requiring minimal reorganization

Answer: B

NEW QUESTION 13
Given the following:

What will be the result of the following SQL statement? INSERT INTO v3 (col1) values (30);

• A. The insert will succeed as it passes validation.
• B. The insert will succeed as there is no WITH CHECK OPTION on view V3.
• C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
• D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Answer: C

NEW QUESTION 14
Which statement about Data Server Manager (DSM) is TRUE?

• A. DSM can be used for reviewing audit trails
• B. DSM cannot be used for database administration
• C. DSM can be used for configuration management of DB2 Data Server drivers
• D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue

Answer: D

NEW QUESTION 15
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

• A. Creating, using, or altering thresholds
• B. Granting, altering, or revoking workload privileges
• C. Using or altering the default service classes and workloads
• D. Creating service classes, service subclasses, and workloads
• E. Creating, activating, stopping or dropping workload management event monitors

Answer: BD

NEW QUESTION 16
Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

• A. A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.
• B. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.
• C. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.
• D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

Answer: C

NEW QUESTION 17
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?

• A. All data, both new and existing, will becompressed.
• B. Only new or updated data for XML columns will be compressed.
• C. New and existing XML columns will be compressed but other columns remain unchanged.
• D. Existing data will remain uncompressed because the RESETDICTIONARY option of theREORG command was not used.

Answer: D

NEW QUESTION 18
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

Answer: B

NEW QUESTION 19
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

• A. It does not acquire locks on the table
• B. It does not require additional temporary disk space
• C. It enables the user to control when the table will be offline
• D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Answer: D

NEW QUESTION 20
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

Answer: C

NEW QUESTION 21
Which operation can be performed with trusted context privileges that are acquired through a role?

• A. DML operations
• B. DDL operations
• C. Server maintenance operations
• D. Security administration operations

Answer: A

NEW QUESTION 22
When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is activity occurring in the database. Which command must be executed to enable the table function to return actual data?

• A. UPDATE DB CFG USING MON_OBJ_METRICS BASE
• B. UPDATE DB CFG USING MON_ACT_METRICS BASE
• C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
• D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON

Answer: C

NEW QUESTION 23
......