IBM A2090-610 試験概要:

IBM A2090-610 試験シラバストピック:

IBM Assessment: DB2 10.1 Fundamentals 認定 A2090-610 試験問題：

問題 #1

Which object is used to cache table and index data as it is read from disk?

A. Table space
B. Buffer pool
C. Database
D. Package cache

問題 #2

When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

A. The temporary table is converted to a base table and the data is deleted.
B. The temporary table is converted to a base table and the data is persistent.
C. The data in the table is deleted and the table persists.
D. The data in the table is deleted and the table is implicitly dropped.

問題 #3

What are INSTEAD OF triggers used for?

A. To perform insert, update, and delete operations against complex views.
B. To check or modify values before they are actually stored in a database.
C. To update data in other tables.
D. To run non-database operations that are coded in user-defined functions.

問題 #4

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

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY SALARY
ORDER BY job;
B. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job
ORDER BY job;
C. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY MIN(salary), MAX(salary)
ORDER BY job;
D. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

問題 #5

Given the following statements:

What will be the result?

A. Joe Smith
B. Joe Smith
C. Joe Smith
D. Joe Smith>DB2

解説：