SQL ORACLE ACADEMY SECTION 1 QUIZ (PL /SQL BLOCKS )

1) Which statements are mandatory in a PL/SQL block? (Choose two.) 
     * BEGIN
      *END

2)In a PL/SQL block, which of the following should not be followed by a semicolon?
     * DECLARE

3)What are the characteristics of an anonymous block? (Choose two.)
     * Unnamed
     *  Compiled each time the application is executed

4) What are the characteristics of a PL/SQL stored subprogram? (Choose two.)
    * Named
    * Can be invoked at any time

5)Which of the following is NOT a PL/SQL programming environment?
    * gSQL*Plus

6) Which of the following is a PL/SQL programming environment?
     *SQL*Workshop in Application Express

7) Which sections of a PL/SQL block are optional?
     * Declaration and Exception

8) What is wrong with this PL/SQL anonymous block?
BEGIN
    DBMS_OUTPUT.PUT_LINE('Hello');
    DBMS_OUTPUT.PUT_LINE(' and Goodbye');

* The END; statement is missing


9) This PL/SQL anonymous block will execute successfully. True or False?
 DECLARE
    v_date DATE := SYSDATE;
    DBMS_OUTPUT.PUT_LINE(v_date);
END;

* true

10) How can you display results to check that a PL/SQL block is working correctly?

  *Use DBMS_OUTPUT.PUT_LINE

11) Which lines of code will correctly display the message "Hello World" ? (Choose two.)

   *  DBMS_OUTPUT.PUT_LINE('Hello World');
   *  DBMS_OUTPUT.PUT_LINE('Hello' || ' ' || 'World');   
 
         

Comments

  1. This PL/SQL anonymous block will execute successfully. True or False?

    The correct answer is: False(*)

    ReplyDelete

Post a Comment