You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
A.
USERS
B.
SYSTEM
C.
SYSAUX
D.
EXAMPLE
Explanation:
This table space is used to store permanent user objects and data. Like the TEMP table
space, every database should have a table space for permanent user data that is assigned
to users. Otherwise, user objects will be created in the SYSTEM table space, which is not
good practice. In the preconfigured database, USERS is assigned the default table space,
and space for all objects created by non-system users comes from this table space. For
system users, the default permanent table space remains SYSTEM.
A
A
B
CREATE USER syntax
DEFAULT TABLESPACE-
Specify the default tablespace for objects that are created in the user’s schema. If you omit this clause, then the user’s objects are stored in the database default tablespace. If no default tablespace has been specified for the database, then the user’s objects are stored in the SYSTEM tablespace.
A -incorrect ,such tablespace is not created
D -incorrect ,such tablespace is not created
it’s dbca, dude
Not create table
A