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 |
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How to name query output columns in oracle?
query optmization techniques and quwry analyser+projects+ppts
What is the usage of save points in oracle database?
How to get a list of all user accounts in the database?
Is oracle an operator?
Explain the importance of .pll extension in oracle?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
Explain table?
how to find the second highest salary in a given table????
12. Display the client name in upper case only and in lower case only.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?