Oracle Interview Questions and Answers
Related differences
Ques 11. What is an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the table(s) the view uses.)
Is it helpful?
Add Comment
View Comments
Ques 12. What is Partial Backup?
A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Is it helpful?
Add Comment
View Comments
Ques 13. 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 14. What is Full Backup?
A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter.
Is it helpful?
Add Comment
View Comments
Ques 15. Can a View based on another View?
Yes
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?