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 do we represent comments in oracle?

How to grant create session privilege to a user in oracle?

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

What is a database table in oracle?

How to initialize variables with default values?

How to create a stored function in oracle?

7. Repeat query (7) but also display all clients who have never ordered anything.

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

how to do daily transactions with out sql* loader control file regesterd in apps?

The join defined by the default data link is an outer join yes or no ?

How do we get field details of a table?

For more Oracle General Interview Questions Click Here