Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

Question

Examine these two statements: Which three are true about the MRKT tablespace? (Choose three.)

Accepted Answer

C. Users who were using the old default tablespace will have their default tablespaces changed to When a new default tablespace is set via ALTER DATABASE DEFAULT TABLESPACE, Oracle automatically reassigns the default tablespace for any user whose prior default was the old default, so those users are migrated to MRKT without manual intervention. D. No more data files can be added to the tablespace. A BigFile tablespace contains exactly one data file by definition; its structure prohibits adding additional data files, so no more files can be added to MRKT. E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored BigFile tablespaces use absolute file numbers rather than relative file numbers in extended rowids, so the relative file number field is unused and not stored for rows in a BigFile tablespace.

Answer

A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the BigFile tablespaces are characterized by supporting a single very large file (up to 128TB), not by having a file size below a threshold - a small file size describes a SmallFile tablespace instead.

Answer

B. The MRKT tablespace may be dropped if it has no contents. MRKT cannot be dropped while it is designated as the current default tablespace; the default must first be reassigned to another tablespace even if MRKT is empty.

Examine these two statements: Which three are true about the MRKT tablespace? (Choose three.)

Question

Exhibit

Options

How the community answered

Why each option

Topics

Community Discussion