Relational Database Management System (RDBMS) Question:
Download Questions PDF

Name the three major set of files on disk that compose a database in Oracle?

RDBMS Interview Question
RDBMS Interview Question

Answer:

There are three major sets of files on disk that compose a database. All the files are binary. These are
► Database files
► Control files
► Redo logs
The most important of these are the database files where the actual data resides. The control files and the redo logs support the functioning of the architecture itself.
All three sets of files must be present, open, and available to Oracle for any data on the database to be useable. Without these files, you cannot access the database, and the database administrator might have to recover some or all of the database using a backup, if there is one.

Download RDBMS Interview Questions And Answers PDF

Previous QuestionNext Question
What are the four Oracle system processes that must always be up and running for the database to be useable?Define SQL and state the differences between SQL and other conventional programming Languages?