What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 11985 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 |
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
How to use "if" statements on multiple conditions?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
how to we delete a row using varray
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
Does oracle database need java?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
what is reindexing?
How to use regular expression in pattern match conditions in oracle?
What is a named program unit?
How to display First 4 rows From Database Table?
Oracle General 
