Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 13000 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 |
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How would you extract DDL of a table without using a GUI tool?
how to get second highest sal of emp table
Explain view?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
find out first highest salary?
10 Answers Verinon Technology Solutions,
How to retrieve data from an explicit cursor?
How to define an anonymous procedure without variables?
What is a read only transaction in oracle?
What are the different types of database objects?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How can we view last record added to a table?
Oracle General 
