Question

al Draw command
To select any specific colour,
IPSET command
for playing musical notes,
Colour statement
To alert an error,
id Screen statement
For point sets,
le Play statement
To set screen resolution,
Beep statement
To draw a straight line,​

Answer 1

Answer:

DEFINE V_DEPTNO = 20

SELECT LAST_NAME, SALARY

FROM EMPLOYEES

WHERE DEPARTMENT_ID = V_DeptNo;

A. Nothing is wrong. The query lists the employee name and

salary of the employees who belong to department 20.

B. The DEFINE statement declaration is wrong.

C. The substitution variable is not preceded with the & character.

D. The substitution variable in the WHERE clause should be V_DEPTNO instead of V_DeptNo.

----

The query will return an error, because the substitution variable is used without

an ampersand (&) character. In this query, Oracle treats V_DEPTNO as another

column name from the table and returns an error. Substitution variables are

not case sensitive.

Ans: C

Explanation: