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 raw datatype?
What does `(+)` do in a where clause?
What is meant by a deadlock situation?
How to filter out duplications in the returning rows using oracle?
What are the different pseudo commands? Explain in general?
What is program global area (pga) in oracle?
What is hash cluster in oracle?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to convert a string to a date in oracle database?
How does Oracle guarantee data integrity of data changes?
How do we switch from init.ora file to asp file?
What different of iner joint & outer joint with example