Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007)

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 ...