Which two statements are true about the USERS tablespace?

View this parameter setting in your database:
DB_CREATE_FILE_DEST=’D:\oracle\product\10.2.0\oradata\oracle’
You created a tablespace by using this command:
CREATE TABLESPACE USERS;
Which two statements are true about the USERS tablespace? (Choose two.)

View this parameter setting in your database:
DB_CREATE_FILE_DEST=’D:\oracle\product\10.2.0\oradata\oracle’
You created a tablespace by using this command:
CREATE TABLESPACE USERS;
Which two statements are true about the USERS tablespace? (Choose two.)

A.
The tablespace has two data files.

B.
Data files belonging to the USERS tablespace cannot be renamed.

C.
The tablespace can be extended without specifying the data file.

D.
An error is reported and tablespace creation fails.

E.
Data files are created with names generated by the instance.



Leave a Reply 0

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