1zo-051:8

Oracle11g SQL Fundamentals I:1ZO-051

Choose the correct syntax to return all columns and rows of data from the EMPLOYEES table.

A. select all from employees;

B. select employee_id, first_name, last_name, first_name, department_id from employees;

C. select % from employees;

D. select * from employees;

E. select *.* from employees;

+ Answer

D. An asterisk is the SQL operator that implies that all columns must be selected from a table.

+ Incorrect Reason

A, B, C, and E are incorrect.

A uses the ALL reserved word but is missing any column specification and will, therefore, generate an error.

B selects some columns but not all columns and, therefore, does not answer the question.

C and E make use of illegal selection operators.

comments

click here to Post your comments and suggestions regarding this page.