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

why dont we assign not null constraint as table level constraint.

2248


Why use resource manager in Oracle?

659


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1561


Explain oracle left join with an example?

576


What are the types of trigger in oracle?

571






various types of hints and their usage

2127


Can I create users through internet explorer in oracle 10g?

565


What is oracle data type?

548


How to list all tables in your schema?

598


What is the difference between count (*), count (expression), count (distinct expression)?

551


Explain oracle insert into command?

622


How to create id with auto_increment on oracle?

543


What is MTTR advisor in Oracle?

601


How to define and use table alias names in oracle?

505


What are the roles of dba?

608