Database Storage Structures (Tablespaces & Datafiles) Quiz

Home › Oracle DBA › Database Storage Structures (Tablespaces & Datafiles)

🗄️ Oracle Database Administration – Database Storage Structures (Tablespaces & Datafiles)

20 questions · 15 min timer · Explanations included · Free

What is the effect of setting the AUTOEXTEND attribute on a datafile in Oracle Database?

The datafile will be locked for exclusive access.

The datafile will automatically increase in size when more space is required.

The datafile will automatically shrink when space is not needed.

The datafile will be compressed to save space.

None

Setting AUTOEXTEND on a datafile allows it to automatically increase in size when more space is needed, which helps in managing storage without manual intervention.

In Oracle Database, what is the primary purpose of the SYSTEM tablespace?

To store archived redo logs.

To contain the data dictionary and PL/SQL code.

To manage temporary segments.

To store user data and indexes.

None

The SYSTEM tablespace contains the data dictionary, which is essential for database operation, and PL/SQL code.

Loading questions...

Click Submit to see your final score!

Start Quiz Next

Time's up

Scroll to Top