最新的IBM A2090-610免費考試真題

問題1

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of the following criteria:
-The employee's hire date (HIREDATE) is before 1999 and the employee's salary (SALARY) is less than $40,000.00 a year. -The employee has attended university
Which SQL statement will accomplish this?

A. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000)
OR (education = 'University')

B. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' OR (salary < 40000
AND (education = 'University')

C. SELECT * FROM employee
WHERE (hiredate < '1999-01-01' AND salary < 40000
AND (education = 'University')

D. SELECT * FROM employee
WHERE (hiredate < '1999-01-01') OR (salary < 40000)
OR (education = 'University')

正確答案: A

問題2

You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?

A. CLI

B. JDBC

C. XML

D. RUBY

正確答案: B

問題3

Which statement about foreign keys is true?

A. A table can have only one foreign key.

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

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

D. Foreign keys are enforced only during the execution of INSERT statements.

正確答案: B

問題4

If the following result set is desired:

Which SQL statement must be executed?

A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY

B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS

C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS

D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY

正確答案: D

問題5

Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?

A. LOCK TABLE tab1 IN EXCLUSIVE MODE

B. LOCK TABLE tab1 IN READ MODE

C. LOCK TABLE tab1 IN SHARE MODE

D. LOCK TABLE tab1 IN READ-ONLY MODE

正確答案: C

問題6

Which method for restricting data access relies on a SQL search condition that describes what set of rows a user has access to?

A. Row and column access control

B. Label-based access control

C. Authorities and privileges

D. Authentication

正確答案: A

問題7

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

A. A schema with the name of the UDF.

B. A schema with the userid of the UDF definer.

C. The SYSIBM schema.

D. The SYSFUN schema.

正確答案: B

問題8

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

A. REVOKE USE OF TABLESPACE mytbsp FROM user1

B. REVOKE UPDATE OF TABLESPACE mytbsp FROM user1

C. REVOKE ALTER ON TABLESPACE mytbsp FROM user1

D. REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

正確答案: A

問題9

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Repeatable read (RR)

B. Uncommitted read (UR)

C. Read stability (RS)

D. Cursor stability (CS)

正確答案: A

問題10

Which statement is true regarding constraints?

A. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

B. A table can have multiple primary key constraints.

C. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.

D. A table can only have one unique key constraint.

正確答案: A

最新的IBM Assessment: DB2 10.1 Fundamentals - A2090-610免費考試真題

聯系我們

站內鏈接

最新更新