In which tablespace will the material table be created?

View the Exhibit.
The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;
User manfus creates a table as follows:
SQL> CREATE TABLE material(id NUMBER(3));
In which tablespace will the material table be created?

View the Exhibit.

The DBA creates a new user as follows:
SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp;
User manfus creates a table as follows:
SQL> CREATE TABLE material(id NUMBER(3));

In which tablespace will the material table be created?

A.
TEMP

B.
SYSAUX

C.
PROD

D.
SYSTEM

E.
USERS



Leave a Reply 0

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