Ensurepass.com : Ensure you pass the IT Exams
2018 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: 61 – (Topic 1)

Which statement about triggers is true?

  1. A trigger is designed to return specific types of values and contains executable code.

  2. A trigger is designed to return specific types of values but contains no executable code.

  3. A trigger performs actions to capture details about an activity like a join operation against multiple tables.

  4. A trigger performs actionsin response to an event like an INSERT, UPDATE or DELETE operation on a table.

Answer: D

Question No: 62 – (Topic 1)

If a table named MY_TAB contains 100 rows and the following statement is executed:

Ensurepass 2018 PDF and VCE

What will happen?

  1. The last 5 rows in the table will be deleted.

  2. The first 5 rows in the table will be deleted.

  3. The statement will fail because a subquery cannot be used with a DELETE statement.

  4. The statement will fail because a table name was not specified with the DELETE statement.

Answer: A

Question No: 63 – (Topic 1)

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

  1. CLI

  2. XML

  3. JDBC

  4. RUBY

Answer: C

Question No: 64 – (Topic 1)

What are two valid objects that can be created in DB2?(Choose two.)

  1. Tree

  2. Node

  3. Trigger

  4. Contexts

  5. Sequence

Answer: C,E

Question No: 65 – (Topic 1)

When is an INTENT EXCLUSIVE (IX) lock required?

  1. When atransaction intends to read or change data.

  2. When a transaction intends to change but not read data.

  3. When a transaction intends to read but not change data.

  4. When a transaction intends to change the system catalog.

Answer: A

Question No: 66 – (Topic 1)

By default, a column defined as a TIMESTAMP includes which attributes?

  1. No fractional digits or time zone.

  2. 6 fractional digits and no timezone.

  3. 12 fractional digits plus a time zone.

  4. 12 fractional digits and no time zone.

Answer: B

Question No: 67 – (Topic 1)

Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?

  1. XMLTABLE

  2. XMLPARSE

  3. XMLEXISTS

  4. XMLATTRIBUTES

Answer: A

Question No: 68 – (Topic 1)

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

  1. SELECTjob, MIN(salary), MAX(salary) FROM employee

    GROUP BY job;

  2. SELECT job, MIN(salary), MAX(salary) FROM employee

    ORDER BY job;

  3. SELECT job, MIN(salary), MAX(salary) FROM employee

    GROUP BY job, MIN(salary), MAX(salary);

  4. SELECT JOB, MIN(salary),MAX(salary) FROM employee

ORDER BY job, MIN(salary), MAX(salary);

Answer: A

Question No: 69 – (Topic 1)

Which statement will prevent concurrent application processes from performing anything other than read-only operationsagainst a table named TAB1?

  1. LOCK TABLE tab1 IN READ MODE

  2. LOCK TABLE tab1 IN SHARE MODE

  3. LOCK TABLE tab1 IN EXCLUSIVE MODE

  4. LOCK TABLE tab1 IN READ-ONLY MODE

Answer: B

Topic 2, Volume B

Question No: 70 – (Topic 2)

What are INSTEAD OF triggers used for?

  1. To update data in other tables.

  2. To perform insert, update, and delete operations against complex views.

  3. To check or modify values before they are actually stored in a database.

  4. To run non-database operations that are coded in user-defined functions.

Answer: B

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