PL SQL Interview Questions

Q.  In internal exception oracle raises the exception for you implicitly. You still need to declare the exception and handle it, but you don’t need to raise it.

a. True
b. False


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  To call a subprogram directly, users must have the EXECUTE privilege on that subprogram. By granting the privilege, you allow a user to -
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which is a database object that groups logically related PL/SQL types, objects and subprograms?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Only EXISTS can be applied to automatically null collections. If you apply another method to such collections, PL/SQL raises COLLECTION_IS_NULL.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which collection exception is raised when a subscript designates an element that was deleted, or a nonexistent element of an associative array?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which collection exception is raised when a subscript exceeds the number of elements in a collection?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following executes the query and identifies the result set, consisting of all rows that meet the query search criteria.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  LOB parameters are not permitted in a server-to-server RPC.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  The CLOSE statement enables a cursor variable and makes the associated result set undefined.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  A subquery is a query (usually enclosed by parentheses) that appears within another SQL data manipulation statement.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  A nested cursor is implicitly opened when the containing row is fetched from the parent cursor. The nested cursor is closed in which of the following case(s)?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which datatype is used to store large blocks of character data in the database, in-line or out-of-line? Both fixed-width and variable-width character sets are supported.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Is it possible to define a CONSTANT value in a record?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which data type supports only sequential access of objects?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Can BOOLEAN datatype be used in functions that are called from SQL statements?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  PL/SQL is a transaction processing procedural language that has which of the following advantages?
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  What is the advantage of using the %ROWTYPE datatype?
Category: Computer Science MCQs,   Published by: T-Code Scripts