[Aug-2021] IBM Certified Database Administrator C2090-600 Exam Practice Dumps
2021 C2090-600 Premium Files Test pdf - Free Dumps Collection
NEW QUESTION 13
Which data types are only valid when DB2_COMPATIBILITY_VECTOR=ORA? (Choose two.)
- A. REAL
- B. XML
- C. NUMBER
- D. VARBINARY
- E. VRCHAR2
Answer: C,D
NEW QUESTION 14
Which statement about the DB2_BCKP_COMPRESSION registry variable is TRUE?
- A. If set, backup images created with the BACKUP command are automatically compressed.
- B. It only has effect when applied to a database in which all tables have been compressed.
- C. It specifies the compression mode to use for DB2 backups.
- D. It does not apply to table space backups.
Answer: A
NEW QUESTION 15
Which statement regarding event monitors is TRUE?
- A. Event monitors are used to obtain information about how a database system looks at a specific point in time
- B. Event monitors must always be started manually after activating a database
- C. Event monitor data can be reviewed while the event monitor is active
- D. Event monitors must write data to .EVT files before the data can be loaded into database tables
Answer: B
NEW QUESTION 16
Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?
- A. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
- B. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation
- C. After termination all the back-end processes using TERMINATE command
- D. When the registry variable DB2_AUTORECLAIMSPACE=YES
Answer: A
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/ doc/c0061069.html
NEW QUESTION 17
Which phase of the LOAD utility is unique to loading column organized tables?
- A. LOAD
- B. ANALYZE
- C. DELETE
- D. BUILD
Answer: B
NEW QUESTION 18
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. Existing data will remain uncompressed because the RESETDICTIONARY option of the REORG command was not used.
- B. All data, both new and existing, will be compressed.
- C. Only new or updated data for XML columns will be compressed.
- D. New and existing XML columns will be compressed but other columns remain unchanged.
Answer: A
NEW QUESTION 19
What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?
- A. NONE
- B. LOCAL
- C. GLOBAL
- D. DOMAIN
Answer: C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/t0006033.html
NEW QUESTION 20
Which security mechanism is responsible for verifying that users are indeed who the claim to be?
- A. Discretionary access control
- B. Authentication
- C. Roles and privileges
- D. Mandatory access control
Answer: B
NEW QUESTION 21
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. SG2
- B. IBMDEFAULTTSG
- C. IBMSTOGROUP
- D. SG1
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.tutorialspoint.com/db2/db2_storagegroups.htm
NEW QUESTION 22
You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?
- A. db2cluster -cm -list -alert
- B. db2cluster -cm -verify -resource
- C. db2cluster -verify -configuration
- D. db2cluster -verify
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/tutorials/dm-1108db2purescalepd/
NEW QUESTION 23
What does dsmtop use to gather metrics?
- A. the system catalog
- B. db2dart
- C. db2pd
- D. monitoring table functions
Answer: D
NEW QUESTION 24
Which of the following are all valid types of trigger?
- A. ATOMIC, BEFORE, INSTEAD OF
- B. AFTER, ATOMIC, INSTEAD OF
- C. AFTER, BEFORE, INSTEAD OF
- D. AFTER, ATOMIC, BEFORE
Answer: C
Explanation:
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_9.8.0/com.ibm.db2.luw.admin.dbobj.doc/ doc/c0020224.html
NEW QUESTION 25
When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density.
What can cause an MDC table to use much more space?
- A. The page size is too small.
- B. High cardinality of the dimension(s) chosen.
- C. The extent size is too small.
- D. Low cardinality of the dimension(s) chosen.
Answer: B
NEW QUESTION 26
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. 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.
- C. Once the first QUIESCE completes, there are no running transactions involving tab1, but there might be running transactions against other tables in TS1.
- 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: B
NEW QUESTION 27
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 MONITOR SWITCHES USING BUFFERPOOL ON
- B. UPDATE DBM CFG USING DFT_MON_BUFPOOLON
- C. UPDATE DB CFG USING MON_OBJ_METRICS BASE
- D. UPDATE DB CFG USING MON_ACT_METRICS BASE
Answer: B
NEW QUESTION 28
Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)
- A. Creating service classes, service subclasses, and workloads
- B. Using or altering the default service classes and workloads
- C. Creating, using, or altering thresholds
- D. Creating, activating, stopping or dropping workload management event monitors
- E. Granting, altering, or revoking workload privileges
Answer: A,E
NEW QUESTION 29
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 ALLOW WRITE ACCESS REBUILDDICTIONARY
- C. REORG TABLE sales INPLACE REBUILDDICTIONARY
- D. REORG TABLE sales INPLACE RESETDICTIONARY
Answer: A
NEW QUESTION 30
......
Get ready to pass the C2090-600 Exam right now using our IBM Certified Database Administrator Exam Package: https://www.dumpsquestion.com/C2090-600-exam-dumps-collection.html