Managing Tablespaces MCQ

1. A set of bitmap blocks has media corruption which tasks call the procedure, either on all bitmap blocks, or on a single block if only one is corrupt?

2. In Viewing Tablespace Information which view gives Information for all extents in all locally managed temporary tablespaces?

3. A transportable tablespace set consists of datafiles for the set of tablespaces being transported and an export file containing structural information (metadata) for the set of tablespaces we use?

4. You can use transportable tablespaces to perform tablespace point-in-time recovery (TSPITR)?

5. To create a new tablespace, we use the SQL statement?

6. Transporting tablespaces with XMLTypes has the following additional limitations?

7. Which utility ensure that the CONSTRAINTS and TRIGGERS parameters are set to Y the default?

8. In Viewing Tablespace Information which view shows the Name and number of all tablespaces from the control file?

9. The DBMS_SPACE_ADMIN package provides maintenance procedures for locally managed tablespaces?

10. AUTOALLOCATE causes the tablespace to be system managed with a minimum extent size of 6K?