IBM DB2 10.1 Fundamentals 認定 C2090-610 試験問題:

1. 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?

A) SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' AND salary < 35000
B) SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' OR salary < 35000
C) SELECT empno, hiredate, salary FROM employee FOR hiredate < '1998-01-01' OR salary < 35000
D) SELECT empno, hiredate, salary FROM employee WHERE hiredate < '1998-01-01' AND salary < 35000

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

A) To combine data from multiple sources.
B) To analyze large amounts of data to find patterns.
C) To make changes to a small number of records within a single transaction.
D) To discover hidden relationships in data.

3. Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;
Which statement is correct?

A) USER1 can only remove the SALES table.
B) USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
C) USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.
D) USER1 can only remove records from the SALES table.

4. Which database object provides an alternative way of describing data that exists in one or more base tables?

A) Index
B) Alias
C) View
D) Sequence

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

A) XMLEXISTS
B) XMLATTRIBUTES
C) XMLTABLE
D) XMLPARSE

質問と回答：