최신 On Demand Business 000-556 무료샘플문제:

1. What is the primary return code for an SQL statement executed by the database server?

A) SQLERRD array
B) SQLCODE field
C) SQLSTATE value
D) SQLWARN array

2. Which Committed Read isolation level statement is correct?

A) It checks for locks after returning a row.
B) It checks for locks before returning a row.
C) It locks all rows examined.
D) It does not check for locks.

3. Assuming you have an employee table that stores the salary for each employee. What will this query return?
SELECT AVG(salary), STDEV(salary) FROM employees;

A) Average salary and standard deviation for all rows assuming the average value for NULL salaries.
B) Average salary and standard deviation for all rows assuming zero for NULL salaries.
C) Average salary and standard deviation for all rows.
D) Average salary and standard deviation for all rows not containing NULL salaries.

4. When an cursor is created with the FOR UPDATE syntax, which type of lock is the result?

A) shared lock
B) implicit lock
C) exclusive lock
D) promotable lock

5. Where are the UNION and UNION ALL operators in subqueries supported?

A) In the FOR UPDATE clause or in an Update cursor.
B) In SELECT statements within the WHERE clause.
C) In the definition of a view.
D) In the event or in the action clause of a trigger.

질문과 대답: