Oracle Interview Questions and Answers
The Best LIVE Mock Interview - You should go through before Interview
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?