Section 1
Which
sections of a PL/SQL block are optional?
Exception
only
Executable
only
Declaration
and Exception (*)
Declaration
and Executable
Errors are handled in the
Exception part of the PL/SQL block. True or False?
True
(*)
False
In which part of the PL/SQL
block are declarations of variables defined?
Declarative
(*)
Definition
Executable
Exception
Which of the following is NOT a
PL/SQL programming environment?
SQL
Workshop in Application Express
Oracle
jDeveloper
SQL*Plus
gSQL*Plus
(*)
Which lines of code will
correctly display the message "Hello World" ? (Choose two.)
DBMS_OUTPUT('Hello
World');
DBMS_OUTPUT.PUT_LINE('Hello
World'); (*)
DBMS_OUTPUT.PUT_LINE('Hello'
|| 'World');
DBMS_OUTPUT.PUT_LINE('Hello'
|| ' ' || 'World'); (*)
Which
of the following statements is true?
None of
these are correct.
You can
embed procedural constructs within SQL code.
You can
embed SQL statements within PL/SQL code. (*)
You can
embed PL/SQL statements within SQL code.
PL/SQL is an Oracle
proprietary, procedural, fourth-generation programming language. True or False?
True
False
(*)
Which of the following
statements about PL/SQL and SQL is true?
PL/SQL
and SQL are both ANSI-compliant.
PL/SQL
and SQL are both Oracle proprietary programming languages.
PL/SQL
allows basic program logic and control flow to be combined with SQL statements.
(*)
PL/SQL
and SQL can be used with many types of databases, including Oracle.
Which of the following
statements is true?
PL/SQL
is an Oracle proprietary, procedural, fourth-generation programming language.
PL/SQL
is an ANSI-compliant, procedural programming language.
SQL is
an ANSI-compliant, nonprocedural, fourth-generation programming language. (*)
PL/SQL
is an Oracle proprietary, procedural, third-generation programming language.
(*)
PL/SQL extends SQL by including
all of the following except:
conditional
statements
constants
variables
nonprocedural
constructs (*)
reusable
program units
Which of the following statements about exception handling
in PL/SQL is false?
Exception
handling code tells your program what to do when an error is encountered.
You can
prepare for application exceptions by creating exception handlers.
You can
prepare for database exceptions by creating exception handlers.
None of
these are false (*)
All of
these are false
Which of the following can be
done using PL/SQL?
Create
custom reports
Create
complex applications
All of
these can be done (*)
Manage
database tasks such as security
Retrieve
and modify data in Oracle database tables
PL/SQL differs from C and Java in
which of the following ways? (Choose two.)
It is
the most efficient language to use with an Oracle database. (*)
It
requires an Oracle database or tool. (*)
It does
not support object-oriented programming.
It is
the most complex programming language to learn.
It is
not portable to other operating systems.
Procedural constructs give you
better control of your SQL statements and their execution. True or False?
True
(*)
False
Using Oracle Application Express,
you can create Web applications that include PL/SQL. True or False?
TRUE
(*)
FALSE
No comments:
Post a Comment