单选题Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）AYou cannot perform the TSPITR with the co

第1题：

In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

• A、flash back the database
• B、perform point-in-time recovery
• C、perform a full database recovery
• D、drop and re-create the tablespace
• E、use Recovery Manager （RMAN） to recover the database

第2题：

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

第3题：

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）.

第4题：

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

• A、New channels for restore and recovery tasks
• B、New name for the data files of the tablespace
• C、Auxiliary name for the data files of the tablespace
• D、Auxiliary destinations for an auxiliary set of data files

第5题：

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

• A、 You cannot perform the TSPITR with the constraints enabled.
• B、 You must perform the TSPITR recovery of both tablespaces for it to be successful.
• C、 You can perform TSPITR only on the USERS tablespace.
• D、 RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.
• E、 The TSPITR will only be successful if the constraint is enabled.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第14题：

Examine the command that is used to create a table：  SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users；  Which two statements are true about the effect of the above command） （）

• A、A CHECK constraint is created on the OID column.
• B、A NOT NULL constraint is created on the OID column.
• C、The ORDERS table is the only object created in the USERS tablespace.
• D、The ORDERS table and a unique index are created in the USERS tablespace.
• E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

第15题：

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.

第16题：

Why should you back up a duplicated tablespace after a TSPITR is complete？（）  

• A、 The tablespace cannot be duplicated or restored to any point in time after the duplication. 
• B、 The tablespace cannot be duplicated or restored to the point in time before the duplication. 
• C、 The entire database cannot be restored after a TSPITR， so a backup is required.
• D、 You cannot bring the tablespace online until its been backed up.
• E、 There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.

第17题：

To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

• A、The database will open, and the tablespace automatically comes out of the backup mode
• B、The database will be mounted, and recovery must be performed on the USERS tablespace.
• C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
• D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：