All About Download C2090-600 Testing Bible

NEW QUESTION 1
For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

• A. XML
• B. BLOB
• C. CLOB
• D. VARCHAR
• E. DATETIME

Answer: DE

NEW QUESTION 2
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 3
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 4
Which tool can be used to get database design recommendations based on SQL statements stored in the database package cache?

• A. db2pd
• B. db2dart
• C. db2expln
• D. db2advis

Answer: C

NEW QUESTION 5
Which options are valid for an online reorganization operation?

• A. FULL and RECLAIM EXTENTS
• B. CLASSIC and RECLAIM EXTENTS
• C. FULL and CLEANUP OVERFLOWS
• D. CLEAN OVERFLOWS and RECLAIM EXTENTS

Answer: A

NEW QUESTION 6
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 7
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 8
Which of the following are valid Explain operators? (Choose two.)

• A. CTQ
• B. XSCAN
• C. IXSCAN
• D. SELECT
• E. COLSCAN

Answer: BC

NEW QUESTION 9
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 10
Which phase of the LOAD utility is unique to loading column organized tables?

• A. LOAD
• B. BUILD
• C. DELETE
• D. ANALYZE

Answer: D

NEW QUESTION 11
Where does the DB2 Problem Determination tool (db2pd) get information from?

• A. DB2memory sets
• B. the db2diag.log file
• C. Monitoring table functions
• D. A set of pre-defined event monitors

Answer: A

NEW QUESTION 12
What is the main benefit of performing an ADMIN_MOVE_TABLE operation in multiple steps?

• A. It does not acquire locks on the table
• B. It does not require additional temporary disk space
• C. It enables the user to control when the table will be offline
• D. It allows the ADMIN_MOVE_TABLE procedure to be used in HADR environments

Answer: D

NEW QUESTION 13
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 14
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 15
Which ALTER TABLE statements will put a table named TAB1 in “reorg-pending” state? (Choose two.)

• A. ALTER TABLE tab1 APPEND ON
• B. ALTER TABLE tab1 DROP COLUMN col1
• C. ALTER TABLE tab1 ALTER COLUMN col1 SET NOT NULL
• D. ALTER TABLE tab1 DETACH PARTITION part1 INTO tab_part1
• E. ALTER TABLE tab1 ADD CONSTRAINT pk_tab1 PRIMARY KEY (col1)

Answer: BC

NEW QUESTION 16
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 17
Which statement about the db2move command is TRUE?

• A. The LOAD actions can be run from a client machine.
• B. Object ownership cannot be changed after a successful schema copy operation.
• C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.
• D. Loading data into tables containing XML columns is only supported for the LOAD actions.

Answer: D

NEW QUESTION 18
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 19
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 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 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 22
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 23
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 24
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 25
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 26
......