1zo-051:6

Oracle11g SQL Fundamentals I:1ZO-051

Choose the two illegal statements. The two correct statements produce identical results. The two illegal statements will cause an error to be raised:

A. SELECT DEPARTMENT_ID|| ' represents the '||
DEPARTMENT_NAME||' Department' as "Department Info"
FROM DEPARTMENTS;

B. SELECT DEPARTMENT_ID|| ' represents the ||
DEPARTMENT_NAME||' Department' as "Department Info"
FROM DEPARTMENTS;

C. select department_id|| ' represents the '||
department_name||' Department' "Department Info"
from departments;

D. SELECT DEPARTMENT_ID represents the DEPARTMENT_NAME
Department as "Department Info"
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