|
Explanation: This answer provides correct list of columns for the output. Incorrect Answers: 1: This answer does not provide correct list of columns for the output. It is not required to show all columns of the table. Symbol “*” is used in the SELECT command to substitute a list of all columns of the table. 2: This answer does not provide correct list of columns for the output. There are not NAME and ADDRESS columns in the CUSTOMERS table. 3: This answer does not provide correct list of columns for the output. There are not ID, NAME, ADDRESS or PHONE columns in the CUSTOMERS table. 5: This answer does not provide correct list of columns for the output. It is not required to show all columns of the table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-24 Chapter 1: Overview of Oracle Databases
|