PL SQL Interview Questions

Q.  ________ does not correlate with an oracle error, instead, user_define exceptions usually enforce business rules in situations in which an oracle error would not necessarily occur

a. Predefined Exception
b. Internal Exception
c. User defined Exception
d. None of the above


ANSWER: See Answer
 
No explanation is available for this question!
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
MCQs:  The LOB objects can be stored in-line or out-of-line. The in-line storage means that objects are stored.
Category: Computer Science MCQs,   Published by: T-Code Scripts
MCQs:  Which of the following activities or operations is not related to manufacturing?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts