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

1. Scott issues the SQL statements:

If Sue needs to select from Scott's DEPT table, which command should she use?

A) SELECT *
FROM ALL_USERS
WHERE USER_NAME = 'SCOTT'
AND TABLE NAME = 'DEPT';
B) SELECT *
FROM DEPT;
C) SELECT *
FROM SCOTT.DEPT;
D) SELECT *
FROM DBA.SCOTT.DEPT;

2. Exhibit:

Examine the data in the EMPLOYEES table.
Examine the subquery:
SELECT last_name FROM employees WHERE salary IN (SELECT MAX(salary) FROM employees GROUP BY department_id);
Which statement is true?

A) The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
B) The SELECT statement does not work because the GROUP BY clause should be in the
main query and not in the subquery.
C) The SELECT statement is syntactically accurate.
D) The SELECT statement does not work because there is no HAVING clause.

3. Which two statements about subqueries are true? (Choose two.)

A) A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
B) A single row subquery can retrieve data from only one table.
C) A single row subquery can retrieve data from more than one table.
D) A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
E) A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
F) A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

4. Examine the statement:
Create synonym emp for hr.employees;
What happens when you issue the statement?

A) An error is generated.
B) You create a table called employees in the HR schema based on you EMP table.
C) You will have two identical tables in the HR schema with different names.
D) You create an alternative name for the employees table in the HR schema in your own schema.

5. In which four clauses can a subquery be used? (Choose four.)

A) in the SET clause of an UPDATE statement
B) in the FROM clause of a SELECT statement
C) in the INTO clause of an INSERT statement
D) in the WHERE clause of a SELECT statement
E) in the GROUP BY clause of a SELECT statement
F) in the VALUES clause of an INSERT statement

質問と回答：