1. TCO 4 – A ____-managed tablespace has a bitmap in the header of the tablespace that stores all of the details about free space, used space, and location of extents. 2. TCO 8 – The default value for INITRANS is 1 for tables and ____ for indexes. 3. TCO 8 – Dictionary-managed tablespaces have a problem that causes slower performance of ____ commands. 4. TCO 8 – A data block can’t be smaller than ____ or larger than 32KB. 5. TCO 8 – When creating a tablespace, the ____ option allows the creation of very large permanent or temporary tablespaces, with a single very large datafile. 6. TCO 4 – A data block is typically ____. 7. TCO 4 – Each ____ represents a group of bytes in the physical file. 8. TCO 4 – Tablespaces are ____-managed by default. 9. TCO 8 – What is the difference between temporary and permanent tablespaces?
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer