Oracle Introduction to Oracle9i: SQL 認定 1Z0-007 試験問題:

1. Which two statements complete a transaction? (Choose two)

A) GRANT SELECT ON employees TO SCOTT;
B) Select MAX(sal)
FROM employees
WHERE department_id = 20;
C) DESCRIBE employees;
D) DELETE employees;
E) ROLLBACK TO SAVEPOINT C;
F) ALTER TABLE employees
SET UNUSED COLUMN sal;

2. Examine the structure of the EMPLOYEES table:

You issue these statements:
CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30));
INSERT INTO new_emp SELECT employee_id , last_name from employees;
Savepoint s1;
UPDATE new_emp set name = UPPER(name);
Savepoint s2;
Delete from new_emp;
Rollback to s2;
Delete from new_emp where employee_id =180;
UPDATE new_emp set name = 'James';
Rollback to s2;
UPDATE new_emp set name = 'James' WHERE employee_id =180;
Rollback;
At the end of this transaction, what is true?

A) You have an employee with the name of James.
B) You have no rows in the table.
C) You cannot roll back to the same savepoint more than once.
D) Your last update fails to update any rows because employee ID 180 was already deleted.

3. Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

A) DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'Carrey');
B) DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
C) DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name = 'Carrey');
D) DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);

4. When should you create a role? (Choose two)

A) To grant a group of related privileges to a user.
B) When the number of people using the database is very high.
C) To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
D) To simplify the process of granting and revoking privileges.
E) To simplify profile maintenance for a user who is constantly traveling.

5. A data manipulation language statement _____.

A) modifies the data but not the structure of a table
B) completes a transaction on a table
C) modifies the structure but not the data of a table
D) modifies the structure and data in a table

質問と回答：