多选题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 contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
多选题
Identify three situations in which you would NOT be able to drop a tablespace. （）
A
when the tablespace is online
B
when the tablespace has segments with data in it
C
when the tablespace is a default permanent tablespace for the database
D
when the tablespace contains a table that is currently being used by transactions
E
when the tablespace contains undo data that is needed to rollback an uncommitted transaction
参考解析
解析：
暂无解析
相关考题：
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 shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments with unused spaceD. check the alerts generated for the tablespace that is running low on space
At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）A、 Start the database in OPEN mode， and create a new index tablespace.B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.
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 SMDUpon investigation， you find that SMD is 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. n segments is managed through free lists.
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace
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.
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 shrinkB、modify the storage parameters for the tablespaceC、automatically shrink the segments with unused spaceD、check the alerts generated for the tablespace that is running low on space
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 dictionarymanaged tablespace.E、There is a dependency relationship between a table and its indexes.
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.
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
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 .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly
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.
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；
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.
多选题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 SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
单选题You have 100 segments in the USERS tablespace. You get an alert that the USERS tablespace is running low on space. You decide to shrink some segments. Which option would you use to determine which segments to shrink?（）ASegment Advisor BSQL Tuning Advisor CSQL Access Advisor DSegment Resource Estimation EAutomatic Database Diagnostic Monitor (ADDM)
多选题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（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic
单选题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?（）ATEST_TBS is a small file tablespace.BTEST_TBS is a bigfile tablespace (BFT).CTEST_TBS is the default temporary tablespace.DTEST_TBS is a dictionary-managed tablespace.
多选题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（）AAdd a data file to the SMD tablespace.BAdd a data file to the temporary tablespace associated with the user HR.CResize the data file associated with the SMD tablespace to make it larger.DAlter the data file associated with the SMD tablespace to grow automatically.EChange the segment space management for the SMD tablespace to automatic
单选题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（）。Aidentify the segments that you should shrinkBmodify the storage parameters for the tablespaceCautomatically shrink the segments with unused spaceDcheck the alerts generated for the tablespace that is running low on space
单选题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？（）AThe index tablespace contains bitmap indexes.BThe index tablespace contains more than one data file.CThe index tablespace supports only complete recovery.DThe index tablespace is not a dictionarymanaged tablespace.EThere is a dependency relationship between a table and its indexes.
单选题You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）ADBMS_STATS BDBMS_ALERT CDBMS_SPACE DDBMS_MONITOR EDBMS_SERVER_ALERTFDBMS_SPACE_ADMIN
多选题Examine these two statements:Which three are true about the MRKT tablespace?（）AThe MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.BThe MRKT tablespace may be dropped if it has no contents.CUsers who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.DNo more data files can be added to the tablespace.EThe relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
多选题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？ （）ARestore the lost data file from the backup， and then flash back the database.BRestore the data file pertaining to index tablespace， and then recover the tablespace.CRestore all the data files， and then perform an incomplete recovery to get the tablespace back.DRestore all the data files， and then perform an incomplete recovery using the backup control file.EDrop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
多选题Which two statements are true regarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it.
单选题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（）.Aadd data files to the tablespace Bidentify the segments that you should shrink Cmodify the storage parameters for the tablespace Dautomatically shrink the segments with unused space Echeck the alerts generated for the tablespace that is running low on space
单选题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?（）ATEST_TBS is a small file tablespace BTEST_TBS is a bigfile tablespace (BFT)CTEST_TBS is the default temporary tablespaceDTEST_TBS is a dictionary-managed tablespaceEThreshold values for the TEST_TBS tablespace are not explicitly specified
单选题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；