ORACLE INTERVIEW QUESTION & ANSWERS
| 26. |
What are the three types of files that make up an Oracle database? |
| |
The three types of files that make up an Oracle database are : - Datafiles
- Control files
- Redo log files.
|
| 27. |
What database object type can be used to generate a series of sequential numbers?
|
| |
A sequence can be used to generate a series of sequential numbers. |
| 28. |
Define data blocks? |
| |
A block is the smallest unit of storage in an Oracle database. The database block
contains header information concerning the block itself as well as the data. |
| 29. |
Define extends? |
| |
Extents consist of data blocks. |
| |
Posted by Sarath. (May 03, 2013) |
| |
A group of data blocks is known as extends. |
| 30. |
Define segments? |
| |
A segment is a set of extents used to store a particular type of data.
|
