Topic : DataFile Management

What view would you use to look at the size of a data file?


Answer :

DBA_DATA_FILES

Show Answer Discuss

What is Data files?


Answer :

Data files contains all the User's data and Oracle?s data dictionary. A data file can be associated with only one database. Database files can have certain characteristics set to allow them to automatically extend when the database runs out of space.

Show Answer Discuss

Define data blocks?


Answer :

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.

Show Answer Discuss

Define extends?


Answer :

Extents consist of data blocks.

Show Answer Discuss

Define segments?


Answer :

A segment is a set of extents used to store a particular type of data.

Show Answer Discuss