What does a Control file Contain ?

  • A Control file records the physical structure of the database. It contains the following information.
  • Database Name
  • Names and locations of a database's files and redo log files.
  • Time stamp of database creation.

How to define Data Block size ?

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 can't be changed latter.

What are the Characteristics of Data Files ?

A data file can be associated with only one database. Once created a data file can't change size. One or more data files form a logical unit of database storage called a tablespace.

What is Rollback Segment ?

A Database contains one or more Rollback Segments to temporarily store "undo" information.

What is a timer?

Timer is an "internal time clock" that you can programmatically create to perform an action each time the times.