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 create a tablespace?
a. create tablespace test datafile "E:\test_area\test01.dbf" size 100M;
b. create tablespace test datafile 'E:\test_area\test01.dbf' size 100M;
c. create tablespace test datafile 'E:\test_area\test01.dbf';
d. create tablespace...