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: 31 – (Topic 1)

Which two activities indicate the need for a data warehouse? (Choose two.)

  1. Confirm product inventory.

  2. Monitor product availability.

  3. Summarize sales by region.

  4. Identify patterns for products sold in the last five years.

  5. Associate one or more products with a purchase order.

Answer: C,D

Question No: 32 – (Topic 1)

Given an EMPLOYEES table and aSALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?

  1. SELECT employees.name, sales.revenue FROM employees

    INNER JOIN sales ON employees.id = sales.emp_id

  2. SELECT employees.name, sales.revenue FROM employees

    INNER JOIN sales ON sales.emp_id = employees.id

  3. SELECT employees.name, sales.revenue FROM sales

    LEFT OUTER JOIN employees ON employees.id = sales.emp_id

  4. SELECT employees.name, sales.revenue FROM sales

RIGHT OUTER JOIN employees ON employees.id = sales.emp_id

Answer: D

Question No: 33 – (Topic 1)

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:

-> The employee#39;s hire date (HIREDATE) is before 1999 and the employee#39;s salary (SALARY) is less than $40,000.00 a year.

-> The employee has attended university

Which SQL statement will accomplish this?

  1. SELECT * FROM employee

    WHERE (hiredate lt; #39;1999-01-01#39; AND salary lt; 40000) OR (education = #39;University#39;)

  2. SELECT * FROM employee

    WHERE (hiredate lt; #39;1999-01-01#39;) OR (salary lt; 40000) OR (education = #39;University#39;)

  3. SELECT * FROM employee

    WHERE (hiredate lt; #39;1999-01-01#39; OR (salary lt; 40000 AND (education = #39;University#39;)

  4. SELECT * FROM employee

WHERE (hiredate lt;#39;1999-01-01#39; AND salary lt; 40000 AND (education = #39;University#39;)

Answer: A

Question No: 34 – (Topic 1)

Which command is used to back out a subset of database changes that havebeen made within a unit of work?

  1. COMMIT

  2. ROLLBACK

  3. COMMIT TO SAVEPOINT

  4. ROLLBACK TO SAVEPOINT

Answer: D

Question No: 35 – (Topic 1)

Which case will require a sequence to be dropped and recreated instead of being modifiedby the ALTER SEQUENCE statement?

  1. Change the data type of the sequence.

  2. Reset the sequence to its starting value.

  3. Establish new minimum or maximum values.

  4. Change the increment between future values.

Answer: A

Question No: 36 – (Topic 1)

Which DB2 object can be used to improve theexecution performance of qualified SELECT statements?

  1. Trigger

  2. SQL Procedure

  3. Sequence Object

  4. Materialized Query Table

Answer: D

Question No: 37 – (Topic 1)

Which type of temporal table can be used to store only time-sensitive data?

  1. Bitemporal

  2. Time-period

  3. System-period

  4. Application-period

Answer: D

Question No: 38 – (Topic 1)

Which DB2 object is used to provide a logical grouping of other database objects?

  1. Alias

  2. Index

  3. Schema

  4. Collection

Answer: C

Question No: 39 – (Topic 1)

Which statement about INSERT operations is true?

  1. The INSERT statement is used to insert rows into a table, view, or table function.

  2. Inserted values must satisfy the conditions of any check constraints defined on the table.

  3. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.

  4. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each rowinserted does not have

to conform to the constraints imposed by those indexes.

Answer: B

Question No: 40 – (Topic 1)

Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

  1. GRANT ALTER ON SEQUENCE myseq TO user1

  2. GRANT USAGE ON SEQUENCE myseq TO user1

  3. GRANT SELECT ON SEQUENCE myseq TO user1

  4. GRANT COMMENT ON SEQUENCE myseq TO user1

Answer: A

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.