You have a read/x7fonly tablespace on read/x7fonly 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/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

A、drop the read­only tablespace and re­create the tablespace after recovery

B、take data files from the read­only tablespace offline before performing a recovery

C、perform a recovery; status of the tablespace in control file will be changed automatically

D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

相关问题推荐

• You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  A、 V$BACKUP_CORRUPTION

  B、 V$COPY_CORRUPTION

  C、 V$DATABASE_BLOCK_CORRUPTION

  D、 RC_BACKUP_CORRUPTION

  查看答案

• You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

  A、 creating a table in your schema and you exceed your allocated space quota on the tablespace

  B、 executing a long query that involves a sort operation and the statement runs out of temporary space

  C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

  D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

  查看答案

• A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

  A、 The database re-created the missing redo log files automatically.

  B、 The database continues to function normally with the existing files.

  C、 The database allows only queries， no other statements are allowed.

  D、 The database returns and error and the database instance shuts down.

  E、 The user sessions that generate redo logs are terminated automatically.

  查看答案

• You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

  A、 VERSIONS_STARTSCN

  B、 VERSIONS_STARTTIME

  C、 VERSIONS_XID

  D、 VERSIONS_OPERATION

  查看答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A、import the database from the last export

  B、restore all the members in the group from the last backup

  C、drop the lost member from the database， and then add a new member to the group

  D、restore all the database files from the backup， and then perform a complete recovery 

  E、restore all the database files from the backup， and then perform an incomplete recovery

  查看答案