Multiple choice technology databases

Which of the following are not legal?

  1. DECLARE V_Destination_India Number;

  2. DECLARE V_123, V_213, V_132 Varchar2(10);

  3. DECLARE V_sys Boolean := 1;

  4. DECLARE V_destination_India Number(4);

  5. DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';
Reveal answer Fill a bubble to check yourself
B,C,E Correct answer
Explanation

In PL/SQL: declaring multiple variables in a single statement separated by commas is invalid; a boolean cannot be directly initialized with the integer 1; and variable definitions must have the NOT NULL constraint specified after the data type, not before. Thus, all three checked options are indeed illegal PL/SQL declarations.

Keep practicing — related questions