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 would you design a database for an e-commerce website?

Can we write insert statement in function in oracle?

What are triggers?Where are they used?

how to make an oracle object

What are a query and state the different types of queries and their uses?

What is the relation of a user account and a schema in oracle?

Use of an integrity constraint is better to validate data. Explain

Will you be able to store pictures in the database?

What is columnar storage what is the advantage?

How to install oracle database 10g xe?

What is a proxy object?

Explain the use of rows option in exp command.

For more Oracle General Interview Questions Click Here