PL SQL Interview Questions

Q.  Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed?

a. PERFORMANCE
b. SEVERE
c. INFORMATIONAL
d. All mentioned above


ANSWER: See Answer
 
No explanation is available for this question!
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
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