What effect should the loss of an index tablespace have on an Oracle instance that is running?()
While setting up the thresholds for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()
Why should you back up a duplicated tablespace after a TSPITR is complete?()
While setting up the threshold for tablespace space usage metrics for one of your tablespaces, you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting?()
What RMAN command is used to execute a tablespace point-in-time recovery?()
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().
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace: 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery: Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery: Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery: Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen?()
You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically, and not have to do it manually. What should you do?()
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?() (Choose three.)
In which of the following scenarios is a tablespace recovery required?()