PL SQL Interview Questions


Q.  Using DBMS_DB_VERSION Package Constants which represents the condition that the database version is less than or equal to 10; it is TRUE.

a. VER_LE_10
b. VER_LE_10_2
c. Both A & B
d. None of the above


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