Oracle - Sample Interview Question (Junior Level)

What will be displayed when the following anonymous block will be executed?

declare
  v_input   boolean := true;
  v_result  varchar2(10);
begin
  select case
           when v_input then 'TRUE'
           when not v_input then 'FALSE'
           else 'NULL'
         end
    into v_result
    from dual;
    
  dbms_output.put_line(v_result);  
end;

  1. TRUE
  2. FALSE
  3. ?ORA-00920. Invalid relational operator?
    exception will be thrown
  4. NULL
Tests in Oracle for Juniors

Test Name Difficulty Time (minutes) No. of Questions
Oracle Online Test for Juniors Oracle Junior 40 20

More Specific Tests in Oracle for Juniors

Test Name Difficulty Time (Minutes) No. of Questions
Oracle-SQL Online Test for Juniors Oracle - SQL Junior 20 10
Oracle-PL/SQL Online Test for Juniors Oracle - PL/SQL Junior 20 10