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 |
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Tell me New Feature of Oracle 10g?
How to resolve name conflicts between variables and columns?
How to see free space of each tablespace?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
How to add a new column to an existing table in oracle?
How to assign a tablespace to a users in oracle?
How to drop a stored procedure in oracle?
Name the various constraints used in oracle?
what is the exact definition for pointer?
What happens to indexes if you drop a table?
What is a read only transaction in oracle?