Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
It is possible to have tablespaces of different block sizes in an Oracle database, as specific tablespaces can be created with a different block size from the standard block size of the database. Additionally, a data block is indeed the smallest unit of I/O in data files, representing the smallest unit of storage that can be read from or written to in an Oracle database.
D,E correct
reference - https://docs.oracle.com/cd/A87860_01/doc/server.817/a76965/c02block.htm
https://docs.oracle.com/cd/E11882_01/server.112/e40540/img/cncpt227.gif
entity-relationship diagram for physical and logical storage. The crow's foot notation represents a one-to-many relationship.
D cannot be correct as you choose the block size per database not per tablespace - AE You set the data block size for each Oracle database when you create the database.
D is correct. From the documentation: Use the BLOCKSIZE clause of the CREATE TABLESPACE statement to create a tablespace with a block size different from the database standard block size. In order for the BLOCKSIZE clause to succeed, you must have already set the DB_CACHE_SIZE and at least one DB_nK_CACHE_SIZE initialization parameter.
D&E is correct