In what state are the datafiles of a tablespace after a TSPI

第1题：

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.

第2题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：   SQL> DROP TABLE SCOTT.EMP PURGE；   After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

• A、 the datafiles associated with the SYSTEM tablespace
• B、 the datafiles associated to the DATA1 tablespace
• C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
• D、 all the datafiles in the database

第3题：

During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）

• A、 incomplete names
• B、 incomplete names with templates
• C、 alias with template names
• D、 numeric names

第4题：

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

• A、 take data files from the read-only tablespace offline before performing a recovery
• B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
• C、 drop the read-only tablespace and re-create the tablespace after recovery
• D、 perform a recovery； status of the tablespace in control file will be changed automatically

第5题：

In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

• A、After the COPY command.
• B、After adding a data file in the target database.
• C、After adding a tablespace in the target database.
• D、After adding a tablespace in the catalog database.
• E、After dropping a data file in the catalog database.
• F、After running SQL Loader to load a large amount of data.

第6题：

Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）

• A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
• B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
• C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
• D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

第7题：

What must be done to make a shared tape drive highly available？（）  

• A、 Ensure the rmt numbers are unique per node.
• B、 Nothing，because HACMP manages the state of the tape drive.
• C、 Nothing，because highly available tape devices are not supported.
• D、 Ensure that the tape device is in a defined state after system startup.

第8题：

When exporting metadata for the transportable tablespaces， what is the correct next step after confirming endian format？（）

• A、 Export the tablespaces using data pump.
• B、 Determine if the transportable set is self-contained.
• C、 Convert the datafiles using RMAN.
• D、 Copy the datafiles from source to destination.

第9题：

Which of the following are included in a transportable tablespace set？（）  

• A、 The datafiles that make up a self-contained group of tablespaces required for copy
• B、 The system tablespace
• C、 An export of the tablespace metadata
• D、 The spfile
• E、 All of the above

第10题：

In what state are the datafiles of a tablespace after a TSPITR has been successfully completed？（）  

• A、 The datafiles have an ONLINE status.
• B、 The datafiles have an OFFLINE status.
• C、 The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
• D、 The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
• E、 The datafiles are in STANDBY mode.