1zo-051:1

Oracle11g SQL Fundamentals I:1ZO-051

Which query creates a projection of the DEPARTMENT_NAME and LOCATION_ID columns from the DEPARTMENTS table? (Choose the best answer.)


A. SELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS;

B. SELECT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS;

C. SELECT DEPT_NAME, LOC_ID
FROM DEPT;

D. SELECT DEPARTMENT_NAME AS “LOCATION_ID”
FROM DEPARTMENTS;

comments

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

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License