In which of the following scenarios is a tablespace recovery

第1题：

Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure.  Which scenarios require DBAintervention to perform recovery（）

• A、1， 3， and 6
• B、4， 5， and 6
• C、3， 4， and 5
• D、1， 2， and 6

第2题：

Which command is used to begin a tablespace point-in-time recovery？（）  

• A、 Restore tablespace
• B、 Recover tablespace
• C、 Tablespace recover
• D、 Recover to time
• E、 recover datafile

第3题：

You executed the following command to perform a backup of the USERS tablespace：  SQL> ALTER TABLESPACE users BEGIN BACKUP； ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1：  ORA-01123： cannot start online backup； media recovery not enabled  What could be the reason for this error（）

• A、The MTTR Advisor is disabled.
• B、The database is in NOARCHIVELOG mode.
• C、The tablespace is already in backup mode.
• D、The Flash Recovery Area is not configured.

第4题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON； Which two events would cause the control file to be backed up automatically？ （）

• A、 A tablespace is taken offline.
• B、 The database instance is restarted.
• C、 A new data file is added to an existing tablespace.
• D、 A successful backup is recorded in the RMAN repository.
• E、 The RMAN connection is disconnected from the target database.

第5题：

Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

• A、 The target database must be in NOARCHIVELOG mode.
• B、 No backup is required of the database before you perform a TSPITR.
• C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
• D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
• E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

第6题：

When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）

• A、 The SYSTEM tablespace.
• B、 The UNDO tablespace.
• C、 All tablespaces with tables.
• D、 All tablespaces with indexes.
• E、 No tablespaces are automatically restored.

第7题：

Which of the following statement is incorrect regarding RMAN？（）

• A、It detects corrupt blocks.
• B、It performs only offline database backups.
• C、It omits empty blocks during backups.
• D、It performs tablespace point-in-time recovery （TSPITR）.

第8题：

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）

• A、The database is in NOMOUNT state.
• B、The database is in ARCHIVELOG mode and the tablespace is online.
• C、The database is in ARCHIVELOG mode and the tablespace is offline.
• D、The database is in NOARCHIVELOG mode and the tablespace is online.
• E、The database is in NOARCHIVELOG mode and the tablespace is offline.

第9题：

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes？（）

• A、 ONLINE
• B、 REVERSE
• C、 PARALLEL
• D、 COMPRESS
• E、 NOLOGGING
• F、 COMPUTE STATISTICS

第10题：

In which of the following scenarios is a tablespace recovery required？（）

• A、 when recovering a lost read-only tablespace from a read-only tablespace backup
• B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
• C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
• D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only