What are the components of Physical database structure of
Oracle Database?

Answer Posted / nishi

Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the blob datatype?

788


What is a snapshot in oracle database?

757


What is control file used for?

785


What to do if the binary spfile is wrong for the default instance?

764


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1706


How to convert numbers to characters in oracle?

774


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2182


What would you do with an in-doubt distributed transaction?

1693


How to rename an index in oracle?

809


What is a user account in oracle?

845


Is there a function to split a string in plsql?

764


What are the attributes of cursor?

775


How can I combine multiple rows into a comma-delimited list in oracle?

784


What is the difference between substr & instr functions?

819


What are triggers in oracle?

753