Which statements will execute successfully? (Choose 2)
A) SELECT employee_id, last_name, job_id, department_id, hire_date FROM employees ORDER BY 3;
B) SELECT first_name, last_name FROM employees ORDER BY employee_id DES;
C) SELECT first_name, last_name, first_name||last_name fullname FROM employees ORDER BY fullname;
D) SELECT employee_id, first_name, last_name FROM employees ORDER BY employee_id DESCEND;
A and B
Computer Science & Information Technology
You might also like to view...
Which of the Insert Table options allows you to select the number of rows and columns for a table by pointing to individual cells?
A) Insert Table B) Draw Table C) Import D) Table Grid
Computer Science & Information Technology
MC Operator LIKE is used for_________ .
a) creating queries. b) sorting result sets. c) pattern matching. d) None of the above.
Computer Science & Information Technology