ORACLE INTERVIEW QUESTION & ANSWERS
| 31. |
What is the Oracle Enterprise Manager? |
| |
The Oracle Enterprise Manager is the new graphical administration tool designed to help the DBA manage one or more Oracle systems. |
| 32. |
What are the types of segments? |
| |
There are four types of segments are : - Data segments
- Rollback
segments
- Index segments
- Temporary segments
|
| 33. |
What are two reasons for creating a view against one or more tables?
|
| |
- A view can be created to hide the complexity of a table join from the user.
- A view can also be created to restrict the rows or columns seen by users of the view.
|
| 34. |
What is the parameter file? |
| |
The parameter file is a file that contains additional command-line parameters. |
| 35. |
What is a data segment? |
| |
Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. |
