FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

PL/SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
21. What is a mutating table?
  A mutating table is one that is in the process of being modified by the SQL statement which fired a trigger. Because the table is being changed it is not in a consistent state and Oracle does not allow queries against it.
Your Name Your Email-ID
Your Answer
 
22. What are the types of literals?
 
    There are different types of literals are :
  • Character literal
  • Numeric literal
  • String literal
  • Boolean literal
  • Datetime literal
Your Name Your Email-ID
Your Answer
 
23. What are subprograms?
  Subprograms are named PL/SQL blocks that can be called with a set of parameters. PL/SQL has two types of subprograms, procedures and functions. Generally, you use a procedure to perform an action and a function to compute a value.
Your Name Your Email-ID
Your Answer
 
24. What is a collection?
  A collection is an ordered group of elements, all of the same type. It is a concept that encompasses lists, arrays and other datatypes used in classic programmimg algorithms.
Your Name Your Email-ID
Your Answer
 
25. Which data manipulation statements can support triggers?
 
  • INSERT
  • UPDATE
  • DELETE
Your Name Your Email-ID
Your Answer