when the tablespace is online
when the tablespace has segments with data in it
when the tablespace is a default permanent tablespace for the database
when the tablespace contains a table that is currently being used by transactions
when the tablespace contains undo data that is needed to rollback an uncommitted transaction
第1题:
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()
第2题:
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?()
第3题:
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
第4题:
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()
第5题:
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?()
第6题:
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? ()
第7题:
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()。
第8题:
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?()
第9题:
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?()
第10题:
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?()