Multiple choice technology programming languages

Which statements are true regarding the logical structure of database? (Choose three)

  1. It is possible to have tablespaces of different block sizes in a database.

  2. A data block is the smallest unit of I/O for data files.

  3. Multiple tablespaces can share single data file.

  4. Each data block in the database always corresponds to one OS block

  5. Each segment contains one or more extents.
Reveal answer Fill a bubble to check yourself
A,B,E Correct answer
Explanation

Oracle's logical database structure supports multiple block sizes within the same database (A). The data block is indeed the smallest unit of I/O for data files (B). Multiple tablespaces cannot share a single data file (C is false) - each data file belongs to exactly one tablespace. Data blocks don't always correspond one-to-one with OS blocks (D is false). Each segment is composed of one or more extents (E).

Keep practicing — related questions