PL/SQL INTERVIEW QUESTION & ANSWERS
| 16. |
What is a character set? |
| |
A Pl/SQL program consists of sequence of statements, each of which is made up of one or more lines of text. Text is made up of combinations of the characters. |
| 17. |
What is lexical units? |
| |
A line of PL/SQL text contains groups of characters known as lexical units. |
| 18. |
What is delimiters? |
| |
A delimiter is a simple or compound symbol that has a special meaning to PL/SQL.
For examples are given below. - ; statement terminator
- % Attribute indicator
- _ single underscore
- : Host variable indicator
- := Alignment operator
- – Single line comment
- /* and */ Beginning and ending multiline comment block delimiters.
|
| 19. |
What is identifier? |
| |
An identifier is a name for a PL/SQL object which includes constants, variables, exceptions, cursors, subprograms, packages and reserved words. |
| 20. |
What are the collection types that supports PL/SQL? |
| |
The three collection types PL/SQL supports are : - index–by tables
- nested tables
- varrays
|
