Section 1 Lesson 3: Creating PL/SQL Blocks

 Section 1
 
  1.  What are the characteristics of an anonymous block? (Choose two.) (1) Points (Choose all correct answers)
   
    Unnamed (*)
    Stored in the database
    Compiled each time the application is executed (*)
    Can be declared as procedures or as functions
   
  2.  Which sections of a PL/SQL block are optional?  (1) Points
    Declaration and Executable
    Declaration and Exception (*)
    Exception only
    Executable only

  3.  Which statements are mandatory in a PL/SQL block? (Choose two.)  (1) Points (Choose all correct answers)
    DECLARE
    BEGIN (*)
    EXCEPTION
    END; (*)

 4.  Which lines of code will correctly display the message "Hello World" ? (Choose two.)  (1) Points
   (Choose all correct answers)
    DBMS_OUTPUT('Hello World');
    DBMS_OUTPUT.PUT_LINE('Hello World'); (*)
    DBMS_OUTPUT.PUT_LINE('Hello' || 'World');
    DBMS_OUTPUT.PUT_LINE('Hello' || ' ' || 'World'); (*)
   
  5.  How can you display results to check that a PL/SQL block is working correctly?  (1) Points
    You don't need to do anything, the results will display automatically.
    Use an Exception section
    Use DBMS_OUTPUT.PUT_LINE (*)
    Write a C or Java program to display the results
   
  6.  What are the characteristics of a PL/SQL stored subprogram? (Choose two.)  (1) Points (Choose all correct answers)
    Named (*)
    Not stored in the database
    Can be invoked at any time (*)
    Do not exist after they are executed
   
  7.  This PL/SQL anonymous block will execute successfully. True or False?
DECLARE
    v_date DATE := SYSDATE;
    DBMS_OUTPUT.PUT_LINE(v_date);
END;
(1) Points
   
    True
    False (*)
   
  8.  Which of the following is NOT a PL/SQL programming environment?  (1) Points
    Oracle jDeveloper
    SQL*Plus
    gSQL*Plus (*)
    SQL Workshop in Application Express
 
  9.  What is wrong with this PL/SQL anonymous block?
BEGIN
    DBMS_OUTPUT.PUT_LINE('Hello');
    DBMS_OUTPUT.PUT_LINE(' and Goodbye');
(1) Points
   
    The Declaration section is missing
    The Exception section is missing
    There is nothing wrong with the block, it will work fine.
    The END; statement is missing (*)
   
  10.  In a PL/SQL block, which of the following should not be followed by a semicolon? (1) Points
   
    DECLARE (*)
    END
    All SQL statements
    All PL/SQL statements
   
  11.  Which of the following is a PL/SQL programming environment?  (1) Points
   
    Oracle Cdeveloper
    Java*Plus
    PL/SQL Express
    SQL*Workshop in Application Express (*)