does Oracle has only one table space?

Question Posted / kvdr_0809

does Oracle has only one table space?..

Answer / oracledba

Oracle does not have one tablespace
Minimum tablespaces in Oracle are
SYSTEM,TEMP and UNDO - oracle 9i
SYSTEM,SYSAUX,TEMP and UNDO - oracle10g

Is This Answer Correct ?

6 Yes

4 No

More Oracle General Interview Questions

How to define a record variable to store a table row?

How to rename an existing table?

Is insert autocommit in oracle?

Please explain joins in oracle?

What is proxy method?

How to create a table index?

ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?

What is the difference between Delete, Truncate and Drop in Oracle?

Design database draw er diagram for a certain scenario ?

What is the difference between an Oracle Schema and an Oracle Instance?

What are joins, explain all types of joins?

What is the use of Control File ?

For more Oracle General Interview Questions Click Here