PL SQL Interview Questions


Q.  The constructs of a procedure, function or a package are ________ .

a. Variables and Constants
b. Cursors
c. Exceptions
d. All mentioned above


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  A package cursor is a cursor which you declare in the package specification without an SQL statement.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In which of the following, do you specify the same parameters in the same order as they are declared in the procedure?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In which mode parameter lets you pass values to the subprogram being called? It cannot be assigned a value.
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
MCQs:  Which is a database object that groups logically related PL/SQL types, objects and subprograms?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
MCQs:  Which collection exception is raised when a subscript exceeds the number of elements in a collection?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
MCQs:  LOB parameters are not permitted in a server-to-server RPC.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  The CLOSE statement enables a cursor variable and makes the associated result set undefined.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  You use cursor variables to pass query result sets between PL/SQL stored subprograms and various clients.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  A subquery is a query (usually enclosed by parentheses) that appears within another SQL data manipulation statement.
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
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: teswesm
MCQs:  Is it possible to define a CONSTANT value in a record?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which data type supports only sequential access of objects?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Can BOOLEAN datatype be used in functions that are called from SQL statements?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL is a transaction processing procedural language that has which of the following advantages?
Category: Computer Science MCQs,   Published by: teswesm