What are the components of Physical database structure of
Oracle Database?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is execute immediate in oracle?

549


What is a table index in oracle?

632


How to invoke the data pump import utility?

652


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1438


Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1513






What is the string concatenation operator in oracle?

570


How to login to the server without an instance?

621


Explain constraining triggers.

593


How to define a specific record type?

622


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

934


Why do you create or replace procedures rather that drop and recreate.

547


What to do if the binary spfile is wrong for the default instance?

563


what is normalisation?what are its uses?

1762


What is the parameter mode that can be passed to a procedure?

574


How to connect to oracle using service name instead of sid?

553