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 escalation
B. Lock promotion
C. Lock conversion
D. Lock exchange
正解:A
質問 2:
Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?
A. REVOKE ALTER ON TABLESPACE mytbsp FROM user1
B. REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1
C. REVOKE USE OF TABLESPACE mytbsp FROM user1
D. REVOKE UPDATE OF TABLESPACE mytbsp FROM user1
正解:C
質問 3:
Which of the following privileges allow a user to update the comment on a sequence?
A. UPDATE
B. USAGE
C. COMMENT
D. ALTER
正解:D
質問 4:
Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
A. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id
B. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id
C. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id
D. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id
正解:B
質問 5:
Which statement is valid about the Row and Column Access Control (RCAC) feature?
A. A row permission's access control rule is defined by an SQL CASE expression; a column mask's access control rule is defined by an SQLsearch condition.
B. A row mask's access control rule is defined by an SQL CASE expression; a column permission's access control rule is defined by an SQLsearch condition.
C. A row permission's access control rule is defined by an SQL search condition; a column mask's access control rule is defined by an SQL CASEexpression.
D. A row mask's access control rule is defined by an SQL search condition; a column permission's access control rule is defined by an SQL CASEexpression.
正解:C
質問 6:
What is a function of a table check constraint?
A. To provide a method of avoiding duplicate entries for a column.
B. To provide a method of ensuring a column's values are within a specific range.
C. To enforce relationships between tables by checking the existence of rows in one table against another.
D. To ensure that XML columns are properly populated in an associated XML table space.
正解:B