we provide Validated IBM C2090-600 free question which are the best for clearing C2090-600 test, and to get certified by IBM IBM DB2 11.1 DBA for LUW. The C2090-600 Questions & Answers covers all the knowledge points of the real C2090-600 exam. Crack your IBM C2090-600 Exam with latest dumps, guaranteed!
NEW QUESTION 1
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 2
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 3
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. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;
- B. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;
- C. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;
- D. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;
Answer: A
NEW QUESTION 4
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 return either an integer or a null.
- C. The routine must be cross-compatible with Oracle PL/SQL syntax rules.
- D. The routine cannot contain argument lists or variable arguments (varargs).
- E. The routine must be generated with IBM Database Conversion Workbench (DCW).
Answer: BD
NEW QUESTION 5
If the following SQL statements are executed:
How many rows will be added to the DEPARTMENT table?
- A. 1
- B. 2
- C. 3
- D. 4
Answer: D
NEW QUESTION 6
Which statement about Data Server Manager (DSM) is TRUE?
- A. DSM can be used for reviewing audit trails
- B. DSM cannot be used for database administration
- C. DSM can be used for configuration management of DB2 Data Server drivers
- D. DSM can be used to efficiently monitor, analyze, identify, and solve a performance issue
Answer: D
NEW QUESTION 7
Which security mechanism is responsible for verifying that users are indeed who the claim to be?
- A. Authentication
- B. Roles and privileges
- C. Mandatory access control
- D. Discretionary access control
Answer: A
NEW QUESTION 8
What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?
- A. NONE
- B. LOCAL
- C. DOMAIN
- D. GLOBAL
Answer: D
NEW QUESTION 9
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. SG1
- B. SG2
- C. IBMSTOGROUP
- D. IBMDEFAULTTSG
Answer: C
NEW QUESTION 10
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 11
Which of the following are valid Explain operators? (Choose two.)
- A. CTQ
- B. XSCAN
- C. IXSCAN
- D. SELECT
- E. COLSCAN
Answer: BC
NEW QUESTION 12
Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?
- A. A local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.
- B. If a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.
- C. A master key must be generated and placed in an existing local keystore before a new encrypted database will be created.
- D. After a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.
Answer: C
NEW QUESTION 13
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 DB CFG USING MON_OBJ_METRICS BASE
- B. UPDATE DB CFG USING MON_ACT_METRICS BASE
- C. UPDATE DBM CFG USING DFT_MON_BUFPOOL ON
- D. UPDATE MONITOR SWITCHES USING BUFFERPOOL ON
Answer: C
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 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 16
Which of the following statements about audit policies is TRUE?
- A. Audit policy changes are applied instantly and affect all inflight transactions.
- B. Multiple audit policies can be associated with the same table at the same time.
- C. The audit policy applied to a table is automatically applied to any view based on that table.
- D. If a user is switched within a trusted connection, the applicable audit policies are re- evaluated for the new user without regard to audit policies for the original user.
Answer: D
NEW QUESTION 17
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 18
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. The target list can contain IP addresses that are either IPv4, or IPv6, or a combination of the two.
- C. You can remove the primarydatabase from the target list of a standby although the standby is connected to the primary.
- D. You cannot dynamically update the HADR_TARGET_LIST configuration parameter for a standby unless you have enabled the HADR read standby feature.
- E. You cannot remove a standby from the list if it is connected to the primar
- F. To disconnect a standby, simply deactivate i
- G. The you can remove it from the primary’s target list.
Answer: AE
NEW QUESTION 19
Which of the following statements is TRUE?
- A. REORGCHK automatically runstables reorganization.
- B. REORGCHK uses only current table and index statistics.
- C. REORGCHK can only be used for user tables, not for system tables.
- D. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required.
Answer: B
NEW QUESTION 20
Which operation can be performed with trusted context privileges that are acquired through a role?
- A. DML operations
- B. DDL operations
- C. Server maintenance operations
- D. Security administration operations
Answer: A
NEW QUESTION 21
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 22
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 23
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 24
Which of the following are all valid types of trigger?
- A. AFTER, ATOMIC, BEFORE
- B. AFTER, ATOMIC, INSTEAD OF
- C. AFTER, BEFORE, INSTEAD OF
- D. ATOMIC, BEFORE, INSTEAD OF
Answer: C
NEW QUESTION 25
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 26
......
100% Valid and Newest Version C2090-600 Questions & Answers shared by Exambible, Get Full Dumps HERE: https://www.exambible.com/C2090-600-exam/ (New 60 Q&As)