ORACLE INTERVIEW QUESTION & ANSWERS
| 71. |
What are the data types allowed in a table? |
| |
- Char
- Varchar2
- Number
- Date
- Raw
- Long
- Long Raw
|
| 72. |
What is a segments? |
| |
Each table has a single area of disk space called a segment. |
| 73. |
Define System Global Area [SGA]? |
| |
- The SGA is a shared-memory region that Oracle uses to store data and control information for an Oracle instance.
- The SGA is allocated when the Oracle instance starts and it is de–allocated when the Oracle instance shuts down.
|
| 74. |
What is a rollback segment used for? |
| |
A rollback segment is used to store change information that can be used in the event of a rollback. It is also used for read consistency. |
| 75. |
What is a log group? |
| |
A log file group is a set of identical redo log files. This provides redundancy to protect against media failure. |
