Topic : Tablespace Management

How do you add a data file to a tablespace?


Answer :

ALTER TABLESPACE ADD DATAFILE SIZE

Show Answer Discuss

What view would you use to determine free space in a tablespace?


Answer :

DBA_FREE_SPACE

Show Answer Discuss

What is a tablespace?


Answer :

A database is divided into Logical Storage Unit called tablespaces.
A tablespace is a logical grouping of related data.
In Oracle; user data is logically stored in tablespaces which is physically stored in data files.

Show Answer Discuss

What are two reasons for creating a view against one or more tables?


Answer :

A view can be created to hide the complexity of a table join from the user.
A view can also be created to restrict the rows or columns seen by users of the view.

Show Answer Discuss

What is a system tablespace?


Answer :

The System tablespace is used by the Oracle Database Engine to hold system information such as :
Data dictionary
Names and locations consist of :
Tablespaces
Tables
Indexes
Clusters

Show Answer Discuss