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
What are the different types of database objects?
What is the usage of analyze command in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain oracle left join with an example?
Why do you use stored procedures and state some of its disadvantages?
List the types of joins used in writing subqueries?
Explain overloading. Can functions be overloaded?
What is meant by raw datatype?
What is the difference between alert log file and tarce file ?
What are nested tables?
How do we create privileges in oracle?
What are the types of partitions in oracle?
How to define a variable to match a table column data type?
please explain.. DB architecture ...
How to add a new column to an existing table with a default value?