PL SQL Interview Questions


Q.  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.

a. NO_DATA_FOUND
b. COLLECTION_IS_NULL
c. SUBSCRIPT_OUTSIDE_LIMIT
d. SUBSCRIPT_BEYOND_COUNT


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  Explicit datatypes, %TYPE and %ROWTYPE, without size specification can be used for parameters in a procedure.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  Oracle-supplied package called DBMS_LOB is used to manipulate the LOB objects.
Category: Computer Science MCQs,   Published by: teswesm
MCQs:  What is the advantage of using the %ROWTYPE datatype?
Category: Computer Science MCQs,   Published by: teswesm
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: teswesm
MCQs:  Which of the following activities or operations is not related to manufacturing?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  In general, any system that produces useful products or services is called as
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Which of the following is an example of constant mass manufacturing process?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Gas welding is a type of
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Why is the selection of right manufacturing process important?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  The decision of what parts to be manufactured and what parts to be purchased from market is taken in
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Which of the following is not a method employed for analysis of manufacturing system?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Which of the following production processes is least flexible?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Open-loop control system is
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  What is a disadvantage of automatic control system?
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  The art of creating industrial relations of any kind, like relation between employers and employees, is called as
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Scientific management is a systematic approach to manage the enterprise on the basis of
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  The objective of utilization of available plant facilities comes under
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Mass production means continuous production without loss of time.
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  A model of casting, constructed to use for forming a mould in damp sand, is called as
Category: Mechanical Engineering Questions,   Published by: teswesm
MCQs:  Which of the following is not a requirement of a good pattern?
Category: Mechanical Engineering Questions,   Published by: teswesm