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');
* 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');
This PL/SQL anonymous block will execute successfully. True or False?
ReplyDeleteThe correct answer is: False(*)