What are the components of Physical database structure of
Oracle Database?
Answers were Sorted based on User's Feedback
Answer / chaudhry
ORACLE database is comprised of three types of files. One or
more Data files, two are more Redo Log files, and one or
more Control files
Is This Answer Correct ? | 37 Yes | 1 No |
Answer / m.kesava moorthi
it consist of three main types of files,there are 1.data
files, 2.control files,3.redo files and some other files
like initialization files,network administration files,alert
log files,trace files,password files
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / chirag
Every oracle database has one or more physical datafiles.
These datafiles contain all the data in the database. The
data of the logical structures, such as tables and indexes,
are physically stored in the allocated datafiles.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to select an oracle system id (sid)?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What language does oracle use?
How to update values on multiple rows in oracle?
what r tyhe major differences between oracle 9i & 10g?
what are the advantages of running a database in archive log mode?
Why does oracle 9i treat an empty string as null?
What is Trace File ?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
What are a query and state the different types of queries and their uses?
Explain joins in oracle?