NEW QUESTION NO: 20
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
A. XML
B. BLOB
C. CLOB
D. VARCHAR
E. DATETIME
Answer: D,E
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0061454.html

NEW QUESTION NO: 21
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 ALLOW WRITE ACCESS RESETDICTIONARY
B. REORG TABLE sales INPLACE RESETDICTIONARY
C. REORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY
D. REORG TABLE sales INPLACE REBUILDDICTIONARY
Answer: A

NEW QUESTION NO: 22
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 running transactions 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. This ensures none of the application changes were applied.
D. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might be some uncommitted data in TS1.
Answer: C

NEW QUESTION NO: 23
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 applied to 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 NO: 24
Which statement regarding event monitors is TRUE?
A. Event monitor data can be reviewed while the event monitor is active
B. Event monitors must always be started manually after activating a database
C. Event monitors must write data to .EVT files before the data can be loaded into database tables
D. Event monitors are used to obtain information about how a database system looks at a specific point in time
Answer: B
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.sql.ref.doc/doc/r0000915.html

NEW QUESTION NO: 25
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
A. XML
B. REAL
C. NUMBER
D. VRCHAR2
E. VARBINARY
Answer: C,E
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/
com.ibm.db2.luw.apdv.porting.doc/doc/r0052867.html

NEW QUESTION NO: 26
Which ALTER TABLE statements will put a table named TAB1 in "reorg-pending" state? (Choose two.)
A. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)
B. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
C. ALTER TABLE tab1 DROP COLUMN col1
D. ALTER TABLE tab1 APPEND ON
E. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
Answer: C,E

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

NEW QUESTION NO: 28
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: B,D
Explanation/Reference:
Reference: ftp://ftp.software.ibm.com/ps/products/db2/info/vr101/pdf/en_US/DB2WorkloadMgmnt- db2wlme1011.pdf (page 23)

NEW QUESTION NO: 29
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. Wednesday
B. Friday
C. Saturday
D. Monday
Answer: B

NEW QUESTION NO: 30
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)
A. The DFT_EXTENT_SZ database configuration parameter is set to 8.
B. The PAGESIZE database configuration parameter is set to 32K.
C. The INTRA_PARALLEL database manager configuration parameter is set to NO.
D. The AUTO_REORG database configuration parameter is set to NO.
E. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.
Answer: C,E

https://www.newpassleader.com/IBM/C2090-600-exam-preparation-materials.html