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: 71 – (Topic 2)

A table named CUSTOMER and an index named CUST_IDX were created as follows:

Ensurepass 2018 PDF and VCE

Which operation would you expect to see in the access plan diagram produced?

  1. NLJOIN

  2. HSJOIN

  3. IXSCAN

  4. TBSCAN

Answer: C

Question No: 72 – (Topic 2)

Which registry variable should be used tospecify that 20 percent of each index page is to be left as as free space when building any index in any database?

  1. DB2_INDEX_DEFAULT

  2. DB2_EXTENDED_OPTIMIZATION

  3. DB2_INDEX_PCTFREE_DEFAULT

  4. DB2_ENABLE_AUTOCONFIG_DEFAULT

Answer: C

Question No: 73 – (Topic 2)

What authority must be held to create a trusted context?

  1. DBADM

  2. SQLADM

  3. SECADM

  4. CONNECT

Answer: C

Question No: 74 – (Topic 2)

What are two types of check options that can be used to create views? (Choose two.)

  1. Local

  2. Client

  3. Server

  4. Remote

  5. Cascaded

Answer: A,E

Question No: 75 – (Topic 2)

Which statement about triggers is FALSE?

  1. A statement-level trigger fires only once for each SQL statement.

  2. A trigger#39;s code block can be executed either before or after a triggeringevent.

  3. A row-level trigger fires once for each row that is affected by a triggering event.

  4. A table-level trigger fires once for each table that is affected by a triggering event.

Answer: D

Question No: 76 – (Topic 2)

What authorization is needed to use the AUDIT statement to create an audit policy?

  1. DBADM

  2. SYSADM

  3. SECADM

  4. SYSMAINT

Answer: C

Question No: 77 – (Topic 2)

What information can be obtained by analyzing EXPLAIN data?

  1. Access type, index use, and work load

  2. Index use, work load, and join methods

  3. Work load, access type, and join methods

  4. Join methods, index use, and access type

Answer: D

Question No: 78 – (Topic 2)

If the following statements are executedin the order shown:

Ensurepass 2018 PDF and VCE

Which statement is true?

  1. Insert, update, and delete operations can be performed against table TAB2.

  2. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.

  3. Insert, update, anddelete operations performed against table TAB1 are automatically cascaded to table TAB2.

  4. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen in table TAB2.

Answer: C

Question No: 79 – (Topic 2)

What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the JobManager in IBM Data Studio?

  1. Permission to log in to the database client using telnet.

  2. Permission to log in to the database server using telnet.

  3. Permission to log in to the database client using secure shell (SSH).

  4. Permission to log in to the database server using secure shell (SSH).

Answer: D

Question No: 80 – (Topic 2)

If a single node database is actively being used by applications when a power failure occurs, whatmethod is used to bring the database back to a consistent state once power has been restored?

  1. Crash recovery

  2. Version recovery

  3. Disaster recovery

  4. Roll-forward recovery

Answer: A

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.