 |
1 | |
The SELECT statement of SQL is an example of nonprocedural database access. |
| | A) | True |
| | B) | False |
|
|
2 | |
With regards to dynamic binding, even when the data to be retrieved cannot be predetermined, it is still useful to reuse the access plan for a statement if the statement is repetitively executed by the application. |
| | A) | True |
| | B) | False |
|
|
3 | |
A variable declaration contains a variable name, a data type, and a required default value. |
| | A) | True |
| | B) | False |
|
|
4 | |
Since PL/SQL does not provide date constants, you must use the To_Date function to convert a string constant to a date value. |
| | A) | True |
| | B) | False |
|
|
5 | |
The CASE statement in PL/SQL can be used instead of an IF-THEN-ELSIF statement, regardless of the version of Oracle being used. |
| | A) | True |
| | B) | False |
|
|
6 | |
In a stored procedure, a set of parameters consisting of a parameter name, a usage and a data type, is required to properly define a named block. |
| | A) | True |
| | B) | False |
|
|
7 | |
The INTO clause can be used with any SELECT statement and will never generate an exception. |
| | A) | True |
| | B) | False |
|
|
8 | |
A cursor can have attributes associated with it that serve to indicate the status of cursor operations. |
| | A) | True |
| | B) | False |
|
|
9 | |
A package implementation contains the definitions of procedures and functions along with other objects that can be specified in the DECLARE section of a PL/SQL block. |
| | A) | True |
| | B) | False |
|
|
10 | |
In Oracle, the timing specification of a trigger is optional. |
| | A) | True |
| | B) | False |
|
|
11 | |
To specify multiple events in a trigger, you can use the AND keyword. |
| | A) | True |
| | B) | False |
|