O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required