What are the basic element of Base configuration of an
oracle Database ?

Answer Posted / nishi

It consists of - one or more data files

- one or more control files

- two or more redo log files

The database contains - Multiple users/schema's

- one or more rollback segments

- one or more tablespaces

- Data dictionary tables

User objects (table, indexes, views etc.)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the order of defining local variables and sub procedures/functions?

815


How do I start tns listener?

760


How to insert multiple rows with one insert statement in oracle?

777


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1940


How can we create the complete backup of data in the oracle.

1896


How to download oracle database 10g xe?

774


What is the difference between a primary key & a unique key?

817


Why does for update in oracle 8 cause an ora-01002 error?

737


How oracle handles dead locks?

796


Is java required for oracle client?

719


What is the difference between I and G in Oracle?

796


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1865


How to connect to the server with user account: sys?

766


What is the difference between 10g OEM and 11g OEM?

733


Query to retrieve record for a many to many relationship ?

2277