PL SQL Interview Questions

Q.  What is the advantage of using the %ROWTYPE datatype?

a. It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separ
b. It can be used even if data type of the table columns is not known.
c. It ensures that data type of the variable changes dynamically if the underlying table is altered.
d. All mentioned above
e. Both A & B


ANSWER: See Answer
 
No explanation is available for this question!
MCQs:  The sand in its natural or moist state is called as
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  What is the highest possible percentage of clay contents in loam sand?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which of the following sentences is/are correct for casting process?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  The productivity of casting process is comparatively
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which casting process has no size and shape limits?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Blow holes in casting are caused by
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Mechanical working processes are performed on metals
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Hot working process is the plastic deformation of metal which is carried out
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which of the following statements are correct for plastic? 1. Plastic is a non-metallic material that can be moulded to any shape 2. Plastic is a natural or synthetic resin 3. Plastic is of organic nature composed of hydrogen, oxygen, carbon and nitrogen
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  The plastics which soften when heat is applied with or without pressure, but requires cooling to set them to shape are called as
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  In resistance electric welding, the current passed through two joining metal pieces is
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  As compared to the arc welding, the gas welding takes
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Good surface finish and better dimensional accuracy can be achieved in
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which of the following are the cold working processes? (1) Forging (2) Bending (3) Squeezing (4) Pipe Welding (5) Drawing
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  The process of joining two pieces of metal with a different fusible metal applied in a molten state is called as
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which of the following statements is/are true for welding process?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Thermosetting materials are
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Which plastic materials contain strong cross linkings in their molecular structure?
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  Worm working or semi-hot working process, which is the plastic deformation of metal or alloy under conditions of temperature and strain rate, is performed to eliminate drawbacks of
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts
MCQs:  The volume of metal that enters the rolling stand
Category: Mechanical Engineering Questions,   Published by: T-Code Scripts