052-200(新增70题2018)

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 INDEX tablespace

B. the USERS tablespace

C. the SYSAUX tablespace

D. the SYSTEM tablespace

E. the default undo tablespace

F. the default temporary tablespace

G. the default permanent tablespace

Answer: G
Permanent Tablespaces
无论如何肯定是the default permanent tablespace
ORA-12950: SYSTEM tablespace specified as default permanent tablespace

Cause: SYSTEM tablespace was specified as the default permanent during database creation.

Action: If default permanent tablespace is not specified,then SYSTEM will implicitly become the default permanent tablespace. Specify an alternate tablespace or omit the default tablespace clause and reissue the CREATE DATABASE statement