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

DB2 10.1 DBA for Linux, UNIX, and Windows

Question No: 11 – (Topic 1)

Which statement describes a way to minimize the impact of a RUNSTATS operation?

  1. Reduce I/O by using a shadow table space for statistics collection.

  2. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.

  3. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.

  4. Limit the number of pages and rows processed by using page-level or row-level table sampling.

Answer: D

Question No: 12 – (Topic 1)

Which statements will enable automatic storage in storage group SG_HOT for a given database managed table space MY_TS and remove all existing non-automatic storage containers from the table space?

  1. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTERTABLESPACE my_ts REBALANCE;

  2. ALTER TABLEPACE my_ts MANAGED BY DATABASE;

    ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;

  3. ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE STOGROUP sg_hot;

    ALTER STOGROUPsg_hot DROP #39;/db2/filesystem1#39;, #39;/db2/filesystem2#39;; ALTER TABLESPACE my_ts REBALANCE;

  4. ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot; ALTER STOGROUP sg_hot DROP #39;/db2/filesystem1#39;, #39;/db2/filesystem2#39;;

ALTER TABLESPACE my_ts REBALANCE;

Answer: A

Question No: 13 – (Topic 1)

In IBMData Studio, where can you schedule script-based jobs?

  1. Job Console

  2. Job Manager

  3. Task Manager

  4. Utilities Console

Answer: B

Question No: 14 – (Topic 1)

What are two purposes of the SET INTEGRITY statement? (Choose two.)

  1. To bring a table out of quot;SetIntegrity Pendingquot; state by performing the required integrity processing on the table.

  2. To bring a table out of quot;Set Integrity Pendingquot; state by performing only check constraint processing on the table.

  3. To bring a table out of quot;Set Integrity Pendingquot;state without performing the required integrity processing on the table.

  4. To bring a table out of quot;Set Integrity Pendingquot; state by performing only referential integrity constraint processing on the table.

  5. To bring a table out of quot;Set Integrity Pendingquot; state by performing only referential integrity and check constraint processing on the table.

Answer: A,C

Question No: 15 – (Topic 1)

If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM)

= ON (Inactive) Which statement is true?

  1. Self-tuning is occurring only on the instance memory area.

  2. The memory tuner is actively tuning the memory on the system.

  3. Self-tuning is not occurring because it is waiting for the database to be recycled.

  4. Self-tuningis not occurring because there are less than two memory consumers enabled.

Answer: D

Question No: 16 – (Topic 1)

Table TAB1 was created as follows:

Ensurepass 2018 PDF and VCE

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for compression?

  1. CREATE INDEX tab1_idx ON tab1(col1);

  2. CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES;

  3. CREATE INDEXtab1_idx ON tab1(col1); REORG INDEX tab1_idx FOR TABLE tab1;

  4. CREATE INDEX tab1_idx ON tab1(col1); ALTER INDEX tab1_idx COMPRESS YES; REORG INDEX tab1_idx FOR TABLE tab1;

Answer: A

Question No: 17 – (Topic 1)

Which statement is true regarding client-server database connectivity?

  1. A remote connection uses Interprocess Communication (IPC).

  2. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.

  3. A remote connection is established between a DB2 client in a different location from the database server.

  4. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.

Answer: C

Question No: 18 – (Topic 1)

Which authority is required to revoke SECADM authority?

  1. DBADM

  2. SECADM

  3. SYSADM

  4. SQLADM

Answer: B

Question No: 19 – (Topic 1)

You want to modify an existing view so that any rows that are inserted or updated with the view will not violate the SELECT statement that was used to create the view. What should you do?

  1. Alter the view and add the ENFORCE SELECT clause to the view definition.

  2. Drop and recreate the view with the WITH CHECK OPTION clause specified.

  3. Alter the view and add the WITH CHECK OPTION clause to the view definition.

  4. Create a new view with the same name and the ENFORCE SELECT clause specified.

Answer: B

Question No: 20 – (Topic 1)

Which statement regarding SECADM authority is true?

  1. The instance owner has SECADM authority by default.

  2. PUBLIC cannot receive SECADM authority, either directly or indirectly.

  3. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.

  4. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-611 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-611 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.