PL SQL Interview Questions


Q.  Assigning a value to a collection element can cause exceptions, such as

a. If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must
b. If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.
c. If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.
d. All mentioned above


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  PL/SQL is completely portable, high-performance transaction processing language that offers which of the following advantages -
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  From the following PL/SQL Delimiters which symbol is exponentiation operator.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  In CASE Expressions, which expression selects a result from one or more alternatives, and returns the result?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which of the following is an explicit numeric, character, string, or BOOLEAN value not represented by an identifier?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL provides many powerful functions to help you manipulate data. These built-in functions fall into which of these following categories?
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  A searched CASE expression lets you test different conditions instead of comparing a single expression to various values.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Using DBMS_DB_VERSION Package Constants which represents the condition that the database version is less than or equal to 10; it is TRUE.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Which internal exception is raised when a program references a nested table or varray element using an index number larger than the number of elements in the collection.
Category: Computer Science MCQs,   Published by: teswesm
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