[Oct-2021] Valid Way To Pass IBM Exam Dumps with C2090-600 Exam Study Guide
All C2090-600 Dumps and IBM DB2 11.1 DBA for LUW Training Courses Help candidates to study and pass the Exams hassle-free!
NEW QUESTION 30
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 31
The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)
- A. You can change the principal standby of the primary without first stopping HADR on the primary.
- B. You can remove the primary database from the target list of a standby although the standby is connected to the primary.
- C. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
- D. The target list can contain IP addresses that are either 1Pv4, or 1Pv6, or a combination of the two.
- E. You cannot remove a standby from the list if it is connected to the primary. To disconnect a standby, simply deactivate it. The you can remove it from the primary's target list.
Answer: A,E
NEW QUESTION 32
Which of the following enables the user to connect to the HADR standby database and execute select statements?
- A. HADR_SPOOL_LIMIT
- B. DB2_HADR_ROS
- C. DB2 - HADR- PEER - WAIT- LIMIT
- D. DB2_HADR_SOSNDBUF
Answer: B
NEW QUESTION 33
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:
db2set -i DB2_FMP COMM_HEAPSZ=256000 - B. As the db2 instance owner (db2inst1) execute the command:
exportDB2_FMP COMM_HEAPSZ=256000 - C. Add to the following line to the user profile (db2inst1): DB2_FMP COMM_HEAPSZ=256000
- D. As the db2 instance owner (db2inst1) execute the command:
db2set -i db2inst1 DB2_FMP COMM_HEAPSZ=256000
Answer: A
NEW QUESTION 34
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: https://www.ibm.com/developerworks/data/tutorials/dm-1108db2purescalepd/
NEW QUESTION 35
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 the default WITH CHECK OPTION is LOCAL on view V2.
- C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.
- D. The insert will succeed as there is no WITH CHECK OPTION on view V3.
Answer: C
NEW QUESTION 36
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_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0; - B. SELECT tbsp_name, tbsp_utilization_percent
FROM syscat.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1; - C. SELECT tbsp_name, tbsp_utilization_percent
FROM sysibmadm.mon_tbsp_utilization
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 0; - D. SELECT tbsp_name, tbsp_utilization_percent
FROM TABLE(sysproc.mon_tbsp_utilization()) AS t
WHERE tbsp_utilization_percent > 95
AND tbsp_auto_resize_enabled = 1;
Answer: B
NEW QUESTION 37
What does dsmtop use to gather metrics?
- A. the system catalog
- B. db2dart
- C. db2pd
- D. monitoring table functions
Answer: D
NEW QUESTION 38
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
Explanation:
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 39
What levels of authority are needed to create a storage group? (Choose two.)
- A. SQLADM
- B. SYSMAINT
- C. SYSADM
- D. SYSCTRL
- E. DBADM
Answer: C,D
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.sql.ref.doc/doc/r0058606.html
NEW QUESTION 40
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 41
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?
- A. db2advis
- B. db2expln
- C. db2dart
- D. db2pd
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 42
Which statement about Data Server Manager (DSM) is TRUE?
- A. DSM cannot be used for database administration
- B. DSM can be used for configuration management of DB2 Data Server drivers
- C. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
- D. DSM can be used for reviewing audit trails
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1503db2-data-server/ index.html (conclusion)
NEW QUESTION 43
Which of the following statements is TRUE?
- A. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
- B. REORGCHK can only be used for user tables, not for system tables.
- C. REORGCHK automatically runs tables reorganization.
- D. REORGCHK uses only current table and index statistics.
Answer: D
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.cmd.doc/doc/r0001971.html
NEW QUESTION 44
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 DB CFG USING MON_OBJ_METRICS BASE
- C. UPDATE DB CFG USING MON_ACT_METRICS BASE
- D. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
Answer: D
NEW QUESTION 45
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 -listconfig -filesystem datafs
- B. db2cluster -cfs -list -filesystem datafs
- C. db2cluster -cfs -displayconfig -filesystem datafs
- D. db2cluster -cfs -display -filesystem datafs
Answer: B
NEW QUESTION 46
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. TRANSPORT
- C. IMPORT
- D. INGEST
Answer: C
NEW QUESTION 47
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?
- A. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC
- B. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90
- C. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES
- D. UPDATE DB CFG USING CF_LOCK_SZ AUTOMATIC
Answer: B
NEW QUESTION 48
Which of the following enables the user to connect to the HADR standby database and execute select statements?
- A. HADR_SPOOL_LIMIT
- B. DB2_HADR_ROS
- C. DB2_HADR_PEER_WAIT_LIMIT
- D. DB2_HADR_SOSNDBUF
Answer: B
Explanation:
Explanation/Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1205hadrstandby/
NEW QUESTION 49
......
Get Latest [Oct-2021] Conduct effective penetration tests using ITexamReview C2090-600
