Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?
A. REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
B. REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C. REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D. REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
正解:A
質問 2:
Application A wants to read a subset of rows from table TAB1 multiple times. Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?
A. Repeatable Read
B. Uncommitted Read
C. Cursor Stability
D. Read Stability
正解:A
質問 3:
Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?
A. The row is only protected from positioned updates and deletes that reference another cursor of the same application.
B. The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application
C. The cursor is only protected from updates and deletes by concurrent applications.
D. The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
正解:C
質問 4:
Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?
A. Repeatable Read
B. Uncommitted Read
C. Cursor Stability
D. Read Stability
正解:B
質問 5:
Given the following statement:
SELECT hyear, AVG(salary)
FROM (SELECT YEAR(hiredate) AS hyear, salary
FROM employee WHERE salary > 30000)
GROUP BY hyear
Which of the following describes the result if this statement is executed?
A. The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.
B. The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.
C. The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.
D. The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.
正解:B
質問 6:
Which of the following DB2 data types does NOT have a fixed length?
A. INT
B. XML
C. CHAR
D. DOUBLE
正解:B
角田** -
これからの時代に対応するために必須な試験です。詳細に、C2090-730出題がされている