which tablespace would the table be stored?

You created a new user in your database but missed assigning a default tablespace to that
user. The user created a table without specifying the tablespace name. In which tablespace
would the table be stored?

You created a new user in your database but missed assigning a default tablespace to that
user. The user created a table without specifying the tablespace name. In which tablespace
would the table be stored?

A.
the default undo tablespace

B.
the default permanent tablespace

C.
the default temporary tablespace

D.
the SYSTEM tablespace

E.
the SYSAUX tablespace

F.
the INDEX tablespace

G.
the USERS tablespace

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

mostramistra

mostramistra

The DEFAULT TABLESPACE clause of the CREATE DATABASE statement specifies a default permanent tablespace for the database. Oracle Database assigns to this tablespace any non-SYSTEM users for whom you do not explicitly specify a different permanent tablespace. If you do not specify this clause, then the SYSTEM tablespace is the default permanent tablespace for non-SYSTEM users. Oracle strongly recommends that you create a default permanent tablespace.

Reply