Section 1 Quiz
Section 1 Quiz
Section 1 Quiz
1. Given below are the parts of a PL/SQL block: Mark for Review
1. END; (1) Points
2. EXCEPTION
3. DECLARE
4. BEGIN
2,1,4,3
3,2,4,1
3,4,2,1 (*)
4,3,2,1
Correct
2. This PL/SQL anonymous block will execute successfully. True or False? Mark for Review
DECLARE (1) Points
v_date DATE := SYSDATE;
DBMS_OUTPUT.PUT_LINE(v_date);
END;
True
False (*)
Correct
3. Which statements are mandatory in a PL/SQL block? (Choose two.) Mark for Review
(1) Points
BEGIN (*)
DECLARE
END; (*)
EXCEPTION
Correct
4. Which PL/SQL block type must return a value? Mark for Review
(1) Points
Function (*)
Anonymous
Procedure
Package
Correct
5. In which part of the PL/SQL block are declarations of variables defined? Mark for Review
(1) Points
Definition
Exception
Declarative (*)
Executable
Correct
6. Which of
the Mark for Review
following (1) Points
statements
about
PL/SQL
and SQL is
true?
Correct
7. Third-generation programming languages include all except _____ and _____. Mark for Review
(1) Points
Java
SQL (*)
MySQL (*)
C++
PL/SQL
Correct
9. Nonprocedural languages allow the programmer to produce a result when a Mark for Review
series of steps are followed. True or False?
(1) Points
True
False (*)
10. In which three ways does PL/SQL extend the SQL programming language? Mark for Review
(1) Points
Correct
11. When Mark for Review
multiple SQL
statements (1) Points
are
combined
into PL/SQL
blocks,
performance
will typically
improve.
True or
False?
True (*)
False
12. The fact that PL/SQL is portable is a good thing because: Mark for Review
(1) Points
Correct
13. Which of the following statements about exception handling in PL/SQL is Mark for Review
false?
(1) Points
14. PL/SQL differs from C and Java in which of the following ways? (Choose Mark for Review
two.)
(1) Points
15. Using Oracle Application Express, you can create Web applications that Mark for Review
include PL/SQL. True or False?
(1) Points
TRUE (*)
FALSE
Correct