Multiple choice

Which of the following is an incorrect statement about Control files in Oracle database?

  1. These files provide the physical storage of data, which consists of the data-dictionary data.

  2. These files have the information about the physical structure of a database.

  3. These files have the information about the time stamp of the database creation, the current log sequence number and the checkpoint information.

  4. At the physical level, data files comprise one or more data blocks.

  5. These files maintain the information of the database.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data and index files provide such information. Control file does not provide physical storage of data but have information about the physical structure of the database.

Keep practicing — related questions