Which two statements are true regarding the MRKT tablespace?

Examine the commands executed in a DBA session:
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE ‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered
Which two statements are true regarding the MRKT tablespace? (Choose two.)

Examine the commands executed in a DBA session:
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE ‘/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered
Which two statements are true regarding the MRKT tablespace? (Choose two.)

A.
Segment space is managed by free lists in the tablespace

B.
No more data files can be added to the tablespace

C.
A user created without being assigned a default tablespace uses this tablespace

D.
The tablespace can be dropped with the current setting with segments present in it



Leave a Reply 2

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


seenagape

seenagape

I have the same idea. BC

fsevkin

fsevkin

Hi Seenagape,

You have uploaded the 1z0-590 v2 exam questions. But they are completely the same with the v1.

Do you have another up-do-date set?