NEW QUESTION 1
The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following commands before running the application. The first QUIESCE completes at time “pit”.
BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET
Which of the following is TRUE?

• A. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.
• B. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.
• C. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE.There might besome uncommitted data in TS1.
• D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLIN
• E. Thisensures none of the application changes were applied.

Answer: D

NEW QUESTION 2
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

• A. db2pd
• B. db2dart
• C. db2expln
• D. db2advis

Answer: C

NEW QUESTION 3
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 4
A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity (inserts, updates, and deletes).
Sunday – Delta Monday – Incremental Tuesday – Delta Wednesday – Delta Thursday – Incremental Friday – Delta
Saturday – Full
Which day would you expect a RECOVER DATABASE following that day’s backup to take the longest time to complete?

• A. Friday
• B. Monday
• C. Saturday
• D. Wednesday

Answer: A

NEW QUESTION 5
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 database
• B. Create an FTP account on IBM Softlayer Object Storage
• C. Use the DB2REMOTE parameter of the LOAD command
• D. Establish a remote connection to IBM Softlayer Object Storage using DB2 Connect
• E. Create a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer: AC

NEW QUESTION 6
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

• A. db2val
• B. db2set
• C. db2look
• D. db2greg

Answer: B

NEW QUESTION 7
On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

• A. As the db2 instance owner (db2inst1) execute the command:exportDB2_FMP_COMM_HEAPSZ=256000
• B. Add to the following line to the userprofile (db2inst1): DB2_FMP_COMM_HEAPSZ=256000
• C. As the db2 instance owner (db2inst1) execute the command:db2set –i DB2_FMP_COMM_HEAPSZ=256000
• D. As the db2 instance owner (db2inst1)execute the command:db2set –i db2inst1 DB2_FMP_COMM_HEAPSZ=256000

Answer: C

NEW QUESTION 8
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?

• A. It does not apply to table space backups.
• B. It specifies the compression mode to use for DB2 backups.
• C. It only has effect when appliedto a database in which all tables have been compressed.
• D. If set, backup images created with the BACKUP command are automatically compressed.

Answer: D

NEW QUESTION 9
Where does the DB2 Problem Determination tool (db2pd) get information from?

• A. DB2memory sets
• B. the db2diag.log file
• C. Monitoring table functions
• D. A set of pre-defined event monitors

Answer: A

NEW QUESTION 10
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

• A. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
• B. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
• C. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
• D. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC

Answer: C

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

Answer: C

NEW QUESTION 12
You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

• A. LOAD
• B. INGEST
• C. IMPORT
• D. TRANSPORT

Answer: C

NEW QUESTION 13
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 14
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 15
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 16
Which statement about NOT ENFORCED unique constraints is TRUE?

• A. NOT ENFORCED unique constraints can not be defined on primary key columns
• B. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
• C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned
• D. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer: A

NEW QUESTION 17
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 18
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 19
Which of the following statements about compression for BLU MPP tables is TRUE?

• A. Compression must be explicitly enabled for BLU MPP tables
• B. Compression requires decompression to evaluate partition joins
• C. Unique compression dictionaries are generated for each partition
• D. Each table has a single compression dictionary that getsreplicated across all partitions

Answer: D

NEW QUESTION 20
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 21
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 22
......