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

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls apackage named CORPDATA.PKGA?

  1. GRANT EXECUTE ON APPLICATION benefits TO user1

  2. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

  3. GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1

  4. GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

Answer: B

Question No: 102 – (Topic 2)

What is theminimum product required for DB2 connectivity across all platforms?

  1. DB2 Personal Edition

  2. DB2 Development Edition

  3. DB2 Connect Personal Edition

  4. DB2 Development Unlimited Edition

Answer: C

Question No: 103 – (Topic 2)

Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

  1. Base Table

  2. Temporal Table

  3. Transition Table

  4. Temporary Table

Answer: D

Question No: 104 – (Topic 2)

Which type of stored procedure is not associated with an external application program?

  1. A Java stored procedure.

  2. A REXX stored procedure.

  3. A native SQL stored procedure.

  4. An external SQL stored procedure.

Answer: C

Question No: 105 – (Topic 2)

Which data type should be used to store data in a column that represents money and accurately returns a two position scale?

  1. BIGINT

  2. BINARY

  3. DOUBLE

  4. DECIMAL

Answer: D

Question No: 106 – (Topic 2)

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

  1. DB2 Connect

  2. DB2 pureScale

  3. Workload Manager

  4. High Availability Disaster Recovery

Answer: B

Question No: 107 – (Topic 2)

The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

  1. Define a view on one or more tables or views.

  2. Revalidate all invalid objects that are referenced on a view#39;s fullselect.

  3. Ensure that any inserted or updated rows conform to the definition of the view.

  4. Define a view that only consists of columns that have check constraints defined.

Answer: C

Question No: 108 – (Topic 2)

Which statement about large object (LOB) locators is true?

  1. A LOB locator is a data type that is used to store LOB data in binary files.

  2. ALOB locator is a data type that is used to store LOB data in a database.

  3. A LOB locator represents a value for a LOB resource that is stored in a database.

  4. A LOB locator represents a value for a LOB resource that is stored in a binary file.

Answer: C

Question No: 109 – (Topic 2)

Which statementabout foreign keys is true?

  1. A table can have only one foreign key.

  2. Foreign keys can only be defined when a table is created.

  3. A foreign key can be defined on a column or a set of columns in a table.

  4. Foreign keys are enforced only during theexecution of INSERT statements.

Answer: C

Question No: 110 – (Topic 2)

A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

  1. SELECT name, COUNT(*) AS transactions FROM sales

  2. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales

  3. SELECTname, COUNT(*) AS transactions FROM sales

    GROUP BY name

  4. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales

GROUP BY transactions

Answer: C

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.