Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating TABLESPACE

User_ZSZ66Dec 27 2022

Hello,
db_create_file_dest string /u01/app/oracle/oradata/prod/
Now examine this statement :
SQL> CREATE TABLESPACE data_olap;
Tablespace is created.
Which two are true about this tablespace and its attributes?
A)The datafile is created with a name generated by the Oracle Instance.
B)The datafile size is 100M.
C)The tablespace is created with manual segment space management.
D)The datafile that is created is not auto extensible.
E)The tablespace is a dictionary managed tablespace.

I have chosen A and B ,can you please confirm,

Regards,

Comments
Post Details
Added on Dec 27 2022
6 comments
747 views