A2090-610試験無料問題集（138題）「IBM Assessment: DB2 10.1 Fundamentals 認定」

出題：1

When a COMMIT statement is executed, what happens?

A. Data stored in global temporary tables is automatically deleted.

B. The current transaction is terminated and a new transaction boundary is started.

C. All locks held on the database are automatically released.

D. Open cursors defined WITH HOLD are closed, but their data is retained.

正解：B 解答を投票する

出題：2

By default, a column defined as a TIMESTAMP includes which attributes?

A. No fractional digits or time zone.

B. 12 fractional digits plus a time zone.

C. 6 fractional digits and no time zone.

D. 12 fractional digits and no time zone.

正解：C 解答を投票する

出題：3

If the following result set is desired:

Which SQL statement must be executed?

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

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

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

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

正解：A 解答を投票する

出題：4

Which SQL statement will give a user named USER1 the ability to run an embedded SQL application named BENEFITS that calls a package named CORPDATA.PKGA?

A. GRANT EXECUTE ON APPLICATION benefits USING PACKAGE corpdata.pkga TO user1

B. GRANT EXECUTE ON APPLICATION PACKAGE corpdata.pkga TO user1

C. GRANT EXECUTE ON APPLICATION benefits TO user1

D. GRANT EXECUTE ON PACKAGE corpdata.pkga TO user1

正解：D 解答を投票する

出題：5

What is the act of exchanging one lock an application holds on a resource for a more restrictive lock on the same resource known as?

A. Lock substitution

B. Lock escalation

C. Lock conversion/promotion

D. Lock switch/exchange

正解：C 解答を投票する

出題：6

A table named DEPARTMENT contains the following data:

What will happen?

A. The statement will fail because the result set produced by the subquery will contain more than one row.

B. The statement will fail because a subquery cannot be used in an UPDATE statement.

C. The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

D. The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

正解：A 解答を投票する

出題：7

Which platform supports DB2 pureScale environments?

A. iOS

B. Windows

C. AIX

D. z/OS

正解：C 解答を投票する

出題：8

What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?

A. Lock conversion

B. Lock escalation

C. Lock promotion

D. Lock exchange

正解：B 解答を投票する

出題：9

Which statement about INSERT operations is true?

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

B. 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.

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

D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.

正解：C 解答を投票する

出題：10

A table named STATES has the following columns: STATE_CD, REGION_CD, and STATE_NAME. Which SQL statement will return the number of states in each region, ordered by number of states?

A. SELECT region_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY COUNT(*);

B. SELECT state_cd, COUNT(*)
FROM states
GROUP BY state_cd
ORDER BY state_cd;

C. SELECT region_cd, COUNT(*)
FROM states
GROUP BY region_cd
ORDER BY COUNT(*);

D. SELECT state_cd, COUNT(*)
FROM states
ORDER BY COUNT(*);

正解：C 解答を投票する

A2090-610試験無料問題集「IBM Assessment: DB2 10.1 Fundamentals 認定」