Which three statements are true about logical structures of the Oracle database? (Choose three.)
A.
Each segment contains one or more extents.
B.
Multiple tablespaces can share a single data file.
C.
A data block is the smallest unit of input/output (I/O) in data files.
D.
It is possible to have tablespaces of different block sizes in a database.
E.
Each data block in the database always corresponds to one operating system block.
Segment > Extent > Data Block
B – a data file can only belong to one table space => wrong.
C – Oracle data block is the smallest I / O units => correct
D – You can have different block sizes, you need to name a non-standard block.
E – Each data block inside the db corresponding to one or more OS blocks => wrong.
You set the data block size for every Oracle database when you create the database. This data block size should be a multiple of the operating system’s block size within the maximum limit. Oracle data blocks are the smallest units of storage that Oracle can use or allocate.
Nonstandard Block Sizes for Tablespaces
You can create tablespaces with block sizes different from the standard database block size, which is specified by the DB_BLOCK_SIZE initialization parameter. This feature lets you transport tablespaces with unlike block sizes between databases.
SEG – I/O – DIFFERENT