Multiple choice technology databases

Which three are the physical structures that constiture the Oracle database ? (Choose Three)

  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace
Reveal answer Fill a bubble to check yourself
A,D,E Correct answer
Explanation

Oracle's physical database structures at the OS level are: Control files (database metadata/structure), Data files (actual database data storage), and Log files (redo logs for recovery). Extents, Segments, and Tablespaces are LOGICAL storage structures, not physical files. Extent and Segment are logical allocations within tablespace, and Tablespace is a logical container.

Keep practicing — related questions