Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 13179 Views
- I also Faced
- E-Mail Answers
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 |
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the meaning of recursive hints in oracle?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Use of an integrity constraint is better to validate data. Explain
How to convert raw data type into text in oracle? Explain
How do I escape a reserved word in oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
How to get a list of all user accounts in the database?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
What is oracle analytical function?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to change system global area (sga) in oracle?
Oracle General 
