Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 12989 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 |
if i am using dml statement in function. then i am writing select statement what was the output
Explain oracle data types with examples?
How to retrieve 5th highest sal from emp table?
How many categories of data types in oracle?
How to update a table row with a record?
What is a snapshot log?
What is a sub query and what are the different types of subqueries?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can the query output be sorted by multiple columns in oracle?
What is program global area (pga) in oracle?
What is the fastest query method to fetch data from the table?
How to load data from external tables to regular tables?
Oracle General 
