Oracle Interview Questions and Answers
Experienced / Expert level questions & answers
Ques 1. What is Mirrored on-line Redo Log?
A mirrored on-line redo log consists of copies of on-line redo log files physically located on separate disks, changes made to one member of the group are made to all members.
Is it helpful?
Add Comment
View Comments
Ques 2. What is a Redo Log?
The set of Redo Log files YSDATE,UID,USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
Is it helpful?
Add Comment
View Comments
Ques 3. 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 redolog files.
Time stamp of database creation.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users:
- What are the components of physical database structure of Oracle database?
- What are the components of logical database structure of Oracle database?
- What is a tablespace?
- What is SYSTEM tablespace and when is it created?
- Explain the relationship among database, tablespace and data file?
Related interview subjects
| MySQL interview questions and answers - Total 108 questions |
| DBMS interview questions and answers - Total 73 questions |
| MSSQL interview questions and answers - Total 50 questions |
| Oracle interview questions and answers - Total 34 questions |
| Redis Cache interview questions and answers - Total 20 questions |
| SQL interview questions and answers - Total 152 questions |