Question: What are the components of physical database structure of Oracle database
Answer: physical components of oracle database are control files,redo log files and datafiles.
Control file: control file is read in the mount state of database. control file is a small binary file which records the physical structure of database which includes
database name names and locations of datafiles and online redo log files. timestamp of database creation check point information current log sequence number. Redo log files: This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery.
Datafiles:datafiles are the physicalfiles which stores data of all logical structure.
Question:
What are the components of physical database structure of Oracle database Answer:
physical components of oracle database are control files,redo log files and datafiles.
Control file: control file is read in the mount state of database. control file is a small binary file which records the physical structure of database which includes
database name names and locations of datafiles and online redo log files. timestamp of database creation check point information current log sequence number. Redo log files: This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery.
Datafiles:datafiles are the physicalfiles which stores data of all logical structure. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.
Answer should be complete in itself.
Related Questions
View Answer
What are the components of logical database structure of Oracle database