Oracle Interview Questions and Answers
Ques 11. What is an Oracle view?
Ans. 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.)
Ques 12. What is Partial Backup?Ans. A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Ques 13. What is Mirrored on-line Redo Log?Ans. 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.
Ques 14. What is Full Backup?Ans. 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.
Ques 15. Can a View based on another View?Ans. Yes
Most helpful rated by users: