- Home
- Interview Questions
- Oracle
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.
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.
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.
Views do not contain or store data.
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.
|
|
||||||||||||||||||||||||||||
