The __________ attribute is used to declare variables based on definitions of columns in table.
%ROWTYPE
%TYPE
AS_COLUMN
None of the above
Raw types are used to store _________ data.
Binary
Character
ASCII
All of the above
SQL has facility for programmed handling of errors that arise during the manipulation of data.
True
False
_________ data type stores unstructured binary data upto 4GB length.
CLOB
BLOB
LONG
In a PL/SQL block structure, which parts are optional?
DELCARE and BEGIN
DECALRE and EXCEPTION
EXCEPTION and END
BEGIN and END
A Rollback statement cannot be used to close transaction.
If the Oracle Engine for its internal processing has opened a cursor they are known as _________
Explicit Cursor
Implicit Cursor
Active Data Set
You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?
A stored procedure on the server.
A block of code in a PL/SQL library.
A standalone procedure on the client machine.
A block of code in the body of the program unit ORDERTOTAL.
A local subprogram defined within the program unit ORDERTOTAL.
Implicit cursors are declared for
Some DML,PL/SQL statements
All DML,PL/SQL statements
Only PL/SQL statements
None of the Above
Which is the procedure used to issue User-Defined error messages from stored Sub-Programs?
Raise Application procedure
Raise Application Error procedure
Application Error procedure