Topic : DataFile Management

What are logical components of Oracle database?


Answer :

Blocks; Extents; Segments; Tablespaces.

Show Answer Discuss

What is data block?


Answer :

A data block is the smallest unit of storage in an Oracle database.Oracle database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

Show Answer Discuss

How to define data block size?


Answer :

A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

Show Answer Discuss

What is row chaining?


Answer :

In circumstances; all of the data for a row in a table may not be able to fit in the same data block. When this occurs; the data for the row is stored in a chain of data block (one or more) reserved for that segment.

Show Answer Discuss

What are the mandatory datafiles to create a database in Oracle 11g?


  • SYSTEM; SYSAUX
  • SYSTEM; USERDATA; TEMP
  • SYSTEM; SYSAUX; UNDO
  • EXAMPLE;SYSTEM;UNDO

Answer :

SYSTEM; SYSAUX; UNDO

Show Answer Discuss