Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-600
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-600.html

IBM DB2 11.1 DBA for LUW

Question No: 21

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

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

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

  3. 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.

  4. 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

Question No: 22

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?

  1. REORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

  2. REORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

  3. RUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

  4. RUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer: A

Question No: 23

Which of the following are all valid types of trigger?

  1. AFTER, ATOMIC, BEFORE

  2. AFTER, ATOMIC, INSTEAD OF

  3. AFTER, BEFORE, INSTEAD OF

  4. ATOMIC, BEFORE, INSTEAD OF

Answer: C

Question No: 24

Which phase of the LOAD utility is unique to loading column organized tables?

  1. LOAD

  2. BUILD

  3. DELETE

  4. ANALYZE

Answer: D

Question No: 25

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

  1. The page size is too small.

  2. The extent size is too small.

  3. Low cardinality of the dimension(s) chosen.

  4. High cardinality of the dimension(s) chosen.

Answer: D

Question No: 26

What is the default value of the DB2 registry variable DB2LDAP_SEARCH_SCOPE?

  1. NONE

  2. LOCAL

  3. DOMAIN

  4. GLOBAL

Answer: D

Question No: 27

Which is the correct way to back up only metadata about database backups, table space backups, and table load operations for database MYDB?

  1. CONNECT TO mydbPRUNE HISTORY TO /outdir

  2. db2trc on -db mydb -m 鈥渂ackup,load鈥漴un the desired operationsdb2tc dump db2trc.dmpdb2tc format db2tc.dmp db2tc.fmtdb2tc off

  3. BACKUP DATABASE mydb NO TABLESPACE TO /outdir

  4. db2setDB2_BCKP_PAGE_VERIFICATION=TRUE must be issued first (no instance restart is needed).Run the desired operations.Afterwards, issue db2trc dump lt;outfilegt;

Answer: B

Question No: 28

If the following SQL statements are executed:

Ensurepass 2018 PDF and VCE

How many rows will be added to the DEPARTMENT table?

  1. 1

  2. 2

  3. 3

  4. 4

Answer: D

Question No: 29

The DBA is concerned about a new application potentially corrupting a set of tables in table space TS1 in database DB1. TAB1 is a table in TS1. The DBA performs the following

commands before running the application. The first QUIESCE completes at time 鈥減it鈥?

BACKUP DATABASE DB1 TABLESPACE (TS1) ONLINE QUIESCE TABLESPACES FOR TABLE tab1 EXCLUSIVE QUIESCE TABLESPACES FOR TABLE tab1 RESET

Which of the following is TRUE?

  1. The QUIESCE EXCLUSIVE is recorded in the History File once the QUIESCE RESET completes.

  2. Once the first QUIESCE completes, there are no runningtransactions involving tab1, but there might be running transactions against other tables in TS1.

  3. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. There might besome uncommitted data in TS1.

  4. After application corruption, the DBA restores a backup of TS1 and issues ROLLFORWARD DATABASE TO pit AND COMPLETE TABLESPACE (ts1) ONLINE. This ensures none of the application changes were applied.

Answer: D

Question No: 30

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

  1. The PAGESIZE database configuration parameter is set to 32K.

  2. The AUTO_REORG database configurationparameter is set to NO.

  3. The DFT_EXTENT_SZ database configuration parameter is set to 8.

  4. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

  5. The INTRA_PARALLEL database manager configuration parameter is set to NO.

Answer: D,E

100% Ensurepass Free Download!
Download Free Demo:C2090-600 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-600 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.