Skip to main content

C2090-610 Real Exam Questions

DB2 10.1 Fundamentals

138 questions available · Page 1 of 14

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998 and earns a salary of less than $35,000.00 per year?

  1. A

    SELECT empno, hiredate, salary

    FROM employee
    FOR hiredate < '1998-01-01' AND salary < 35000

  2. B

    SELECT empno, hiredate, salary

    FROM employee
    WHERE hiredate < '1998-01-01' AND salary < 35000

  3. C

    SELECT empno, hiredate, salary

    FROM employee
    WHERE hiredate < '1998-01-01' OR salary < 35000

  4. D

    SELECT empno, hiredate, salary

    FROM employee
    FOR hiredate < '1998-01-01' OR salary < 35000

Show answer and explanation

Correct answer: B

Question 2 Single choice

What is the primary function of an Online Transaction Processing (OLTP) workload?

  1. A

    To combine data from multiple sources.

  2. B

    To discover hidden relationships in data.

  3. C

    To analyze large amounts of data to find patterns.

  4. D

    To make changes to a small number of records within a single transaction.

Show answer and explanation

Correct answer: D

Question 3 Single choice

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

  1. A

    Trigger

  2. B

    SQL Procedure

  3. C

    Sequence Object

  4. D

    Materialized Query Table

Show answer and explanation

Correct answer: D

Question 4 Single choice

Which statement is true about an index that is used to support a UNIQUE constraint?

  1. A

    It must not contain more than one column.

  2. B

    It cannot be used in a referential constraint.

  3. C

    It must be defined with the UNIQUE attribute.

  4. D

    It must be defined as UNIQUE WHERE NOT NULL.

Show answer and explanation

Correct answer: C

Question 5 Single choice

When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?

  1. A

    The SYSIBM schema.

  2. B

    The SYSFUN schema.

  3. C

    A schema with the name of the UDF.

  4. D

    A schema with the userid of the UDF definer.

Show answer and explanation

Correct answer: D

Question 6 Single choice

What factor influences lock conversion/promotion?

  1. A

    Lock size

  2. B

    Number of locks

  3. C

    Lock mode needed

  4. D

    Available real storage

Show answer and explanation

Correct answer: C

Question 7 Single choice

If the following command is executed: CREATE DATABASE test

What is the page size (in kilobytes) of the database?

  1. A

    4

  2. B

    8

  3. C

    16

  4. D

    32

Show answer and explanation

Correct answer: A

Question 8 Single choice

Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?

  1. A

    Check

  2. B

    Unique

  3. C

    Referential

  4. D

    Informational

Show answer and explanation

Correct answer: D

Question 9 Single choice

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

  1. A

    REVOKE USE OF TABLESPACE mytbsp FROM user1

  2. B

    REVOKE ALTER ON TABLESPACE mytbsp FROM user1

  3. C

    REVOKE UPDATE OF TABLESPACE mytbsp FROM user1

  4. D

    REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

Show answer and explanation

Correct answer: A

Question 10 Single choice

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

  1. A

    View

  2. B

    Table

  3. C

    Sequence

  4. D

    Identity Column

Show answer and explanation

Correct answer: C