Multiple choice

Which of the following is false about data segment in Oracle database?

  1. The data segment defines the logical structure of the database.

  2. Each partition has a data segment for a partitioned table in the database.

  3. Database segments are created when a SQL statement needs temporary database area to complete execution.

  4. Every table in the cluster stores its data in the cluster's data segment.

  5. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is false statement as Oracle creates Temporary segments  when a SQL statement needs a temporary database area to complete execution and it does not create any Database segments.

Keep practicing — related questions