Part-3

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.

Can a View based on another View?- Yes.

Can a Tablespace hold objects from different Schemes? - Yes.

Can objects of the same Schema reside in different tablespaces? - Yes.

What is the use of Control File? -

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.

Does View contain Data? -

Views do not contain or store data.

What are the Referential actions supported by FOREIGN KEY integrity constraint? -

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.

Junior DBA Questions : Part 2, Part 4