C2090-600 Exam - IBM DB2 11.1 DBA for LUW

NEW QUESTION 1
What is the result of the following scenario?

• A. The row is updated to (2, NULL)


• B. The row is updated to (2, 110.00)


• C. SQL0407N Assignment of a NULL value to a NOT NULL column is not allowed


• D. The CREATE TRIGGER statement will fail because amt is defined as NOT NULL

Answer: B

NEW QUESTION 2
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 3
When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

• A. The PAGESIZE database configuration parameter is set to 32K.


• B. The AUTO_REORG database configurationparameter is set to NO.


• C. The DFT_EXTENT_SZ database configuration parameter is set to 8.


• D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.


• E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

Answer: DE

NEW QUESTION 4
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. All data, both new and existing, will becompressed.


• B. Only new or updated data for XML columns will be compressed.


• C. New and existing XML columns will be compressed but other columns remain unchanged.


• D. Existing data will remain uncompressed because the RESETDICTIONARY option of theREORG command was not used.

Answer: D

NEW QUESTION 5
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 there is no WITH CHECK OPTION on view V3.


• C. The insert will result in an error as it violates the WITH CHECK OPTION on view V2.


• D. The insert will succeed as the default WITH CHECK OPTION is LOCAL on view V2.

Answer: C

NEW QUESTION 6
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 –list –filesystem datafs


• B. db2cluster –cfs –display –filesystem datafs


• C. db2cluster –cfs –listconfig –filesystem datafs


• D. db2cluster –cfs –displayconfig –filesystem datafs

Answer: A

NEW QUESTION 7
How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

• A. Set the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.


• B. Set the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.


• C. Set the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.


• D. Use AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

Answer: B

NEW QUESTION 8
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 9
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 10
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 11
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. Friday


• B. Monday


• C. Saturday


• D. Wednesday

Answer: A

NEW QUESTION 12
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

NEW QUESTION 13
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 14
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 15
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. INGEST


• C. IMPORT


• D. TRANSPORT

Answer: C

NEW QUESTION 16
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 17
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 18
Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

• A. db2val


• B. db2set


• C. db2look


• D. db2greg

Answer: B

NEW QUESTION 19
Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

• A. To prunethe contents of a staging table.


• B. To prune the contents of a synopsis table.


• C. To prune the contents of a materialized query table (MQT).


• D. To prune the contents of a declared global temporary table.

Answer: A

NEW QUESTION 20
Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

• A. Select from the ADMIN_GET_ENCRYPTION_INFO table function


• B. Run the db2ckbkp command and verify the compression settings


• C. Checkthe encrypted database parameter in database configuration


• D. Check ENCROPTS database configuration parameter for encryption options

Answer: D

NEW QUESTION 21
Which statement about label-based access control (LBAC) is TRUE?

• A. LBAC protection can be applied to a nickname


• B. LBAC cannot be used to restrict access to a staging table


• C. LBAC cannot be used to restrict access to data of columns and rows in the same table


• D. LBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer: D

NEW QUESTION 22
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 23
......