1.
This PL/SQL anonymous block will execute successfully. True or False?
DECLARE
v_date DATE := SYSDATE;
DBMS_OUTPUT.PUT_LINE(v_date);
END;
Mark for Review
(1) Points
True
False (*)
Correct
2. Which of the following is a PL/SQL programming environment?
Mark for Review
(1) Points
Oracle Cdeveloper
SQL*Workshop in Application Express (*)
Java*Plus
PL/SQL Express
Correct
3. In which part of the PL/SQL block are declarations of variables defined?
Mark for Review
(1) Points
Declarative (*)
Executable
Exception
Definition
Correct
4. Which keywords must be included in every PL/SQL block? (Choose two.)
Mark for Review
(1) Points
EXCEPTION
END;(*)
DBMS_OUTPUT.PUT_LINE
DECLARE
BEGIN(*)
Correct
5. Every PL/SQL anonymous block must start with the keyword DECLARE.
True or False?
Mark for Review
(1) Points
TRUE
FALSE (*)
Correct
6. Third-generation programming languages include all except _____ and
_____.
Mark for Review
(1) Points
C++
Java
SQL(*)
MySQL(*)
PL/SQL
Correct
7. Which of the following statements is true?
Mark for Review
(1) Points
SQL is an ANSI-compliant, nonprocedural, fourth-generation programming language.(*)
PL/SQL is an Oracle proprietary, procedural, third-generation programming language.(*)
PL/SQL is an Oracle proprietary, procedural, fourth-generation programming language.
PL/SQL is an ANSI-compliant, procedural programming language.
Incorrect. Refer to Section 1 Lesson 1.
8. The P in PL/SQL stands for:
Mark for Review
(1) Points
Primary
Procedural (*)
Processing
Proprietary
Correct
9. PL/SQL is an Oracle proprietary, procedural, fourth-generation
programming language. True or False?
Mark for Review
(1) Points
True
False (*)
Correct
10. A program which specifies a list of operations to be performed
sequentially to achieve the desired result can be called:
Mark for Review
(1) Points
nondeclarative
low level
declarative
procedural (*)
Correct
11. Comparing PL/SQL with other languages such as C and Java, which of
the following statements is true?
Mark for Review
(1) Points
PL/SQL is easier to learn and does not require an Oracle database or tool
PL/SQL is easier to learn but less efficient
PL/SQL is harder to learn
PL/SQL is easier to learn and more efficient (*)
Correct
12. Using Oracle Application Express, you can create Web applications that
include PL/SQL. True or False?
Mark for Review
(1) Points
TRUE (*)
FALSE
Correct
13. Which of the following can be done using PL/SQL?
Mark for Review
(1) Points
Create complex applications
All of these can be done (*)
Retrieve and modify data in Oracle database tables
Create custom reports
Manage database tasks such as security
Correct
14. The fact that PL/SQL is portable is a good thing because:
Mark for Review
(1) Points
PL/SQL code can be run on any operating system without a database
Blocks can be sent to the operating system.
PL/SQL code can be developed on one platform and deployed on another (*)
Exceptions can be ported to different operating systems
Correct
15. PL/SQL differs from C and Java in which of the following ways? (Choose
two.)
Mark for Review
(1) Points
It requires an Oracle database or tool.(*)
It is the most complex programming language to learn.
It is not portable to other operating systems.
It does not support object-oriented programming.
It is the most efficient language to use with an Oracle database.(*)
Correct
