PL SQL Interview Questions


Q.  Which of the following has a return type in its specification and must return a value specified in that type?

a. Function
b. Procedure
c. Package
d. None of the above


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