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 17. Answer Key to Practice Test #2

Question 1

Answer F is correct. All queries are valid and none causes an error. Query A is a simple “get all columns from a table” query. B is similar except that it retrieves three specific columns. C references all columns by tables and schemas and a table’s by schemas, not causing an issue. D contains a schema name referencing the table, which incidentally does not have to ...

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