Topic : DataFile Management

System Data File Consists of


  • Metadata
  • Business Data
  • Temporary Data
  • Undo Data

Answer :

Metadata

Show Answer Discuss

Which action occurs during a checkpoint?


  • Oracle updates a control file.
  • Oracle performs a delayed block clean-out.
  • Oracle copies the online redo-log to the archive destinations.
  • Oracle flushes the dirty blocks in the database buffer cache to disk.

Answer :

Oracle flushes the dirty blocks in the database buffer cache to disk.

Show Answer Discuss

In which situation is it appropriate to enable the restricted session mode?


  • Creating a table
  • Dropping an index
  • Taking a rollback segment offline
  • Exporting a consistent image of a large number of tables.

Answer :

Exporting a consistent image of a large number of tables.

Show Answer Discuss

Name the views used to look at the size of a datafile; controlfiles; block size; determine free space in a tablespace ?


Answer :

- DBA_DATA_FILES or v$datafile view can be used to look at the size of a datafile .
- DBA_FREE_SPACE is used to determine free space in a tablespace.
- V$contolfile used to look at the size of a control file which includes maxlogfiles; maxlogmembe

Show Answer Discuss

How do you resize a data file?


Answer :

ALTER DATABASE DATAFILE RESIZE ;

Show Answer Discuss