Oracle Interview Questions and Answers
Question - 11 : - What is an Oracle view?
Answer - 11 : - 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.)
Question - 12 : - What is Partial Backup ?
Answer - 12 : - A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.
Question - 13 : - What is Mirrored on-line Redo Log ?
Answer - 13 : - 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.
Question - 14 : - What is Full Backup ?
Answer - 14 : - 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.
Question - 15 : - Can a View based on another View ?
Answer - 15 : - Yes.
Question - 16 : - Can a Tablespace hold objects from different Schemes ?
Answer - 16 : - Yes.
Question - 17 : - Can objects of the same Schema reside in different tablespace ?
Answer - 17 : - Yes.
Question - 18 : - What is the use of Control File ?
Answer - 18 : - When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
Question - 19 : - Do View contain Data ?
Answer - 19 : - Views do not contain or store data.
Question - 20 : - What are the Referential actions supported by FOREIGN KEY integrity constraint ?
Answer - 20 : - UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.