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

Explain an exception and its types?

687


How to view the data files in the current database?

670


How to count duplicated values in a column in oracle?

636


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1856


Explain what are the advantages of views?

687






Which is better Oracle or MS SQL? Why?

5622


Explain the difference between replace() and translate() functions in oracle?

662


Explain alias?

808


What to do if dba lost the system password?

693


How do we create privileges in oracle?

669


ABOUT IDENTITY?

1650


What is a static data dictionary in oracle?

649


Can we create database in oracle using command line ?

664


How to start your 10g xe server from command line?

647


What is the oracle implicit cursor?

681