[Free] 2017(Jan) EnsurePass Dumpsleader IBM C2090-610 Dumps with VCE and PDF 21-30

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

DB2 10.1 Fundamentals

Question No: 21 – (Topic 1)

Which object is a stored procedure defined into?

  1. Table

  2. Schema

  3. Package

  4. Database

Answer: B

Question No: 22 – (Topic 1)

Whatis the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?

  1. Lock escalation

  2. Lock substitution

  3. Lock switch/exchange

  4. Lock conversion/promotion

Answer: D

Question No: 23 – (Topic 1)

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

  1. DBADM

  2. DBCTRL

  3. SECADM

  4. DBMAINT

Answer: C

Question No: 24 – (Topic 1)

A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

  1. DBCTRL authority

  2. SQLADM authority

  3. DATAACCESS authority

  4. ACCESSCTRL authority

Answer: C

Question No: 25 – (Topic 1)

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

  1. locator

  2. pointer

  3. address

  4. reference

Answer: A

Question No: 26 – (Topic 1)

By default, where is the data stored for acolumn defined with an XML data type?

  1. In an XML index.

  2. In line with the rest of the data for the table.

  3. In an XML storage object that is separate from the table.

  4. In line with the rest of the data for the table, for XML columns less than 32KB.

Answer: C

Question No: 27 – (Topic 1)

What factor influences lock escalation?

  1. Table size

  2. Buffer space

  3. Number of locks

  4. Available real storage

Answer: C

Question No: 28 – (Topic 1)

If the following result set is desired:

Ensurepass 2017 PDF and VCE

Which SQL statement must be executed?

  1. SELECT lastname, firstnme, salary, job FROM employee

    ORDER BY 3

    FETCH FIRST 5 ROWS ONLY

  2. SELECT lastname, firstnme, salary, job FROM employee

    ORDER BY 3 DESC

    FETCH FIRST 5 ROWS ONLY

  3. SELECT lastname, firstnme, salary, job FROM employee

    ORDER BY 3

    FETCH FIRST 5 ROWS

  4. SELECT lastname, firstnme, salary, job FROM employee

ORDER BY 3 DESC FETCH FIRST 5 ROWS

Answer: B

Question No: 29 – (Topic 1)

What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

  1. Oracle connect

  2. Trusted context

  3. Oracle federation

  4. Distributed request

Answer: D

Question No: 30 – (Topic 1)

Which statement about application-period temporal tables is true?

  1. Consists of explicitly-supplied timestamps and a separate associated historytable.

  2. Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

  3. Is useful when one wants to keep both user-based period information and system-based historical information.

  4. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-610 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass C2090-610 Full Exam PDF and VCE

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

2017 EnsurePass IT Certification PDF and VCE

You must be logged in to post a comment.

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com