ORACLE INTERVIEW QUESTION & ANSWERS
Databases
Follow Us
TAGS
| 26. | What are the three types of files that make up an Oracle database? |
|---|---|
|
| 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. |