Test your knowledge
Q 1. Which of these block sizes cannot be used as the database block size for an Oracle database?
a. 1K
b. 2K
c. 16K
d. 32K
Q 2. Given a database with an 8 K block size, how many blocks must be read in order to return the results of a query that requests 100,000 rows that are 100 bytes in size?
a. 2
b. 14
c. 253
d. 1024
Q 3. Which of the following block sizes would be the best choice for a database used exclusively for data warehousing?
a. 1K
b. 2K
c. 12K
d. 16K
Q 4. Which of these units of data storage is a physical grouping of database blocks?
a. Table
b. Segment
c. Extent
d. Tablespace
Q 5. Which of these units of storage is the physical analogue of a table?
a. Block
b. Extent
c. Segment
d. Database
Q 6. Which of these statements will successfully ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.