多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace 

第1题：

An online tablespace，TEST_TBS，is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace.  What could be the reason，if the TEST_TBS tablespace does not include autoextensible data files？（）  

• A、 TEST_TBS is a small file tablespace.
• B、 TEST_TBS is a bigfile tablespace （BFT）.
• C、 TEST_TBS is the default temporary tablespace.
• D、 TEST_TBS is a dictionary-managed tablespace.

第2题：

You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）

• A、The index tablespace contains bitmap indexes.
• B、The index tablespace contains more than one data file.
• C、The index tablespace supports only complete recovery.
• D、The index tablespace is not a dictionary­managed tablespace.
• E、There is a dependency relationship between a table and its indexes.

第3题：

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

• A、Add a data file to the SMD tablespace.
• B、Add a data file to the temporary tablespace associated with the user HR.
• C、Resize the data file associated with the SMD tablespace to make it larger.
• D、Alter the data file associated with the SMD tablespace to grow automatically.
• E、Change the segment space management for the SMD tablespace to automatic

第4题：

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

• A、 Restore the lost data file from the backup， and then flash back the database.
• B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
• C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
• D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
• E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

第5题：

Examine these two statements:Which three are true about the MRKT tablespace?（）

• A、The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B、The MRKT tablespace may be dropped if it has no contents.
• C、Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D、No more data files can be added to the tablespace.
• E、The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to（）。

• A、identify the segments that you should shrink
• B、modify the storage parameters for the tablespace
• C、automatically shrink the segments with unused space
• D、check the alerts generated for the tablespace that is running low on space

第14题：

You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）

• A、 The index tablespace contains bitmap indexes.
• B、 The index tablespace contains more than one data file.
• C、 The index tablespace supports only complete recovery.
• D、 The index tablespace is not a dictionary-managed tablespace.
• E、 There is a dependency relationship between a table and its indexes.

第15题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第16题：

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

• A、 DROP TABLESPACE temp1；
• B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
• C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
• D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：