nerdexam
Oracle

1Z0-062 · Question #114

Examine these two statements: Which three are true about the MRKT tablespace?

The correct answer is C. Users who were using the old default tablespace will have their default tablespaces changed to D. No more data files can be added to the tablespace. E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored. A BIGFILE tablespace contains exactly one data file, does not store relative file numbers in rowids, and setting it as the database default reassigns the default tablespace for affected users.

Managing Database Storage Structures

Question

Examine these two statements:

Which three are true about the MRKT tablespace?

Exhibit

1Z0-062 question #114 exhibit

Options

  • AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the
  • BThe MRKT tablespace may be dropped if it has no contents.
  • CUsers who were using the old default tablespace will have their default tablespaces changed to
  • DNo more data files can be added to the tablespace.
  • EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored

How the community answered

(19 responses)
  • A
    11% (2)
  • B
    11% (2)
  • C
    79% (15)

Why each option

A BIGFILE tablespace contains exactly one data file, does not store relative file numbers in rowids, and setting it as the database default reassigns the default tablespace for affected users.

AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the

Whether a tablespace is smallfile or bigfile is determined by the BIGFILE or SMALLFILE keyword in the CREATE TABLESPACE statement, not by the size of the data file.

BThe MRKT tablespace may be dropped if it has no contents.

While a tablespace with no contents can be dropped, this choice is misleading in context; a tablespace that has been set as the default or contains objects is not simply dropped, and the question's focus is on properties of a bigfile tablespace.

CUsers who were using the old default tablespace will have their default tablespaces changed toCorrect

When a new default permanent tablespace is assigned at the database level, Oracle automatically updates the default tablespace attribute for any users whose prior default was the old database-level default, redirecting them to the newly specified tablespace.

DNo more data files can be added to the tablespace.Correct

A BIGFILE tablespace is architecturally restricted to a single data file regardless of size; Oracle does not permit additional data files to be added to a bigfile tablespace.

EThe relative file number of the tablespace is not stored in rowids for the table rows that are storedCorrect

In a BIGFILE tablespace, rowids use the absolute file number rather than the relative file number because only one data file exists per tablespace, making the relative file number field in the rowid unused.

Concept tested: Bigfile tablespace properties and default tablespace assignment

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html

Topics

#Tablespace#Default tablespace#Largefile tablespace#Rowid structure

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice