Chapter 16. Practice Test #2

1.

Which of these queries cause errors? Assume that all object names, such as schemas, tables, views, columns, and otherwise, exist in their appropriate places.

□

A.

SELECT * FROM MOVIES.ACTOR;

□

B.

SELECT MOVIE_ID, TITLE, YEAR FROM MOVIE;

□

C.

SELECT MOVIES.ACTOR.ACTOR_ID, MOVIES.ACTOR.NAME
   FROM MOVIES.ACTOR;

□

D.

SELECT MOVIE_ID, TITLE, YEAR*10
    FROM MOVIES.MOVIE;

□

E.

SELECT TITLE AS MOVIE, NAME AS DIRECTOR
   FROM MOVIE NATURAL JOIN DIRECTOR;

□

F.

None of these queries cause an error.

2.

Which two of these queries cause a syntax error?

□

A.

SELECT TITLE AS MOVIE, NAME AS DIRECTOR
FROM MOVIE NATURAL JOIN DIRECTOR
ORDER BY DIRECTOR, MOVIE;

□

B.

COL MOVIE FORMAT A16
COL DIRECTOR FORMAT A16
SELECT TITLE AS MOVIE, NAME AS DIRECTOR
FROM MOVIE ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial