Get 100% Passing Success With True C2090-600 Exam! [Oct-2021]
IBM C2090-600 PDF Questions - Exceptional Practice To IBM DB2 11.1 DBA for LUW
NEW QUESTION 28
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 29
What is an advantage of using range partitioned tables?
- A. Table data is automatically and continuously clustered, requiring minimal reorganization
- B. Ability to run utilities against the partitions in parallel
- C. Increased query performance through data partition elimination
- D. Block indexes are much smaller than RID indexes, providing better performance
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0605ahuja2/#query
NEW QUESTION 30
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 31
Which statement about NOT ENFORCED unique constraints is TRUE?
- A. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned
- B. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index
- C. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan
- D. NOT ENFORCED unique constraints can not be defined on primary key columns
Answer: D
NEW QUESTION 32
Which statement about the db2move command is TRUE?
- A. The LOAD actions can be run from a client machine.
- B. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
- C. Loading data into tables containing XML columns is only supported for the LOAD actions.
- D. Object ownership cannot be changed after a successful schema copy operation.
Answer: C
Explanation:
Explanation/Reference:
Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21665891
NEW QUESTION 33
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 34
What does dsmtop use to gather metrics?
- A. the system catalog
- B. db2dart
- C. db2pd
- D. monitoring table functions
Answer: D
NEW QUESTION 35
Which DB2 Explain Facility tool uses the Explain tables to display access plain information?
- A. db2advis
- B. db21ook
- C. db2exfmt
- D. db2expln
Answer: D
NEW QUESTION 36
A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.
Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?
- A. RUNSTATS ON TABLE sales IN PLACE AND INDEXES ALL;
- B. RUNSTATS ON TABLE sales AND INDEXES ALL; REORGCHK ON TABLE sales;
- C. REORG TABLE sales AND INDEXES ALL; RUNSTATS ON TABLE sales AND INDEXES ALL;
- D. REORG TABLE sales INPLACE; REORG INDEXES ALL FOR TABLE sales; RUNSTATS ON TABLE sales AND IN DEXES ALL;
Answer: C
NEW QUESTION 37
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)
- A. DATETIME
- B. BLOB
- C. VARCHAR
- D. XML
- E. CLOB
Answer: A,C
Explanation:
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 38
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 39
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?
- A. To prune the contents of a synopsis table.
- B. To prune the contents of a staging table.
- C. To prune the contents of a declared global temporary table.
- D. To prune the contents of a materialized query table (MQT).
Answer: B
NEW QUESTION 40
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
- A. The routine cannot contain comments.
- B. The routine must be generated with IBM Database Conversion Workbench (DCW).
- C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
- D. The routine must return either an integer or a null.
- E. The routine cannot contain argument lists or variable arguments (varargs).
Answer: D,E
Explanation:
Explanation
Explanation/Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.apdv.porting.doc/doc/r_sql_compat_nzplsql.html/
NEW QUESTION 41
When operating in NPS compatibility mode, which of the following are limitations for using a routine written in NZPLSQL? (Choose two.)
- A. The routine cannot contain comments.
- B. The routine must be generated with IBM Database Conversion Workbench (DCW).
- C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
- D. The routine must return either an integer or a null.
- E. The routine cannot contain argument lists or variable arguments (varargs).
Answer: D,E
NEW QUESTION 42
What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?
- A. SYSFUN
- B. SYSCAT
- C. SYSIBM
- D. SYSIBMADM
Answer: C
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.2.0/
com.ibm.swg.im.infosphere.biginsights.commsql.doc/doc/r0059071.html
NEW QUESTION 43
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 44
Which phase of the LOAD utility is unique to loading column organized tables?
- A. LOAD
- B. ANALYZE
- C. DELETE
- D. BUILD
Answer: B
Explanation:
Explanation/Reference:
Reference: https://www.ibm.com/support/knowledgecenter/en//SSEPGG_11.1.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/t0061530.html (about this task)
NEW QUESTION 45
......
C2090-600 dumps - ActualTorrent - 100% Passing Guarantee: https://www.actualtorrent.com/C2090-600-questions-answers.html