PL/SQL INTERVIEW QUESTION & ANSWERS
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. |
27. |
What is the name of Oracle’s Java engine? |
|
Aurora is the name of Oracle’s Java engine. |
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.
|
29. |
What is the maximum length of the message buffer? |
|
The message buffer can be up to 4,096 bytes in length. |
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.
|