FeedBack Form

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

PL/SQL INTERVIEW QUESTION & ANSWERS

Follow Us
 
26. What is an object type?
  An object type is a user–defined composite datatype representing a data structure and functions and procedures to manipulate the data. With scalar datatypes, each variable holds a single value. With collections, all the elements have the same type. Only object types let you associate code with the data.
Your Name Your Email-ID
Your Answer
 
27. What is the name of Oracle’s Java engine?
  Aurora is the name of Oracle’s Java engine.
Your Name Your Email-ID
Your Answer
 
28. What are the types of control structures?
 
    There are three types of control statements.
  • Conditional control : returns a boolean value.
  • Iterative control : executes a sequence of statements repeatedly.
  • Sequential control : executes a sequence of statements in the order in which they occur.
Your Name Your Email-ID
Your Answer
 
29. What is the maximum length of the message buffer?
  The message buffer can be up to 4,096 bytes in length.
Your Name Your Email-ID
Your Answer
 
30. What is ROWID?
  ROWID returns the binary address of a row in a database table. You can use variables of type UROWID to store rowids in a readable format.
Your Name Your Email-ID
Your Answer