Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Physical database structure of
Oracle Database?
- 4 Answers
- 13029 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 |
List out the types of joins.
What are the uses of Database Trigger ?
can a view be updated?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to delete a user account in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
How to define an anonymous block?
How to open and close an explicit cursor in oracle?
In Oracle 9i what does "i" Stands for?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
Oracle General 
