多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespac

题目
多选题
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
A

adding a new user to the database

B

dropping a user from the database

C

dropping a table from the database

D

dropping a data file from a tablespace

E

adding a new tablespace to the database

相似考题

1.Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）A. Mount the container database (CDB) and restore the control file from the control file auto backup.B. Recover and open the CDB in NORMAL mode.C. Mount the CDB and then recover and open the database, with the RESETLOGS option.D. Open all the pluggable databases.E. Recover each pluggable database.F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

2. A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database

3. 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 offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

4. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

参考答案和解析
正确答案： E,B
解析： 暂无解析
更多“多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespac”相关问题

  • 第1题：

    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

    • A、flash back the database
    • B、import the temporary tablespace from the last export
    • C、restore all the data files and temporary files from the last full database backup and perform a recovery
    • D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

    正确答案:D

  • 第2题：

    Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1：  ORA/x7f00942： table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）

    • A、retrieve the table by using the flashback feature
    • B、restore all the data files from last Sunday’s backup， and then perform a time­based recovery
    • C、restore all the data files from last Sunday’s backup， and then perform a log sequence recovery
    • D、restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery
    • E、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery

    正确答案:B

  • 第3题：

    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

    正确答案:A

  • 第4题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第5题：

    Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）

    • A、adding a new user to the database
    • B、dropping a user from the database
    • C、dropping a table from the database
    • D、dropping a data file from a tablespace
    • E、adding a new tablespace to the database

    正确答案:D,E

  • 第6题：

    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE;  Which two operations do you need to perform after restoring the control file from backup？（）

    • A、shut down and restart the instance
    • B、add new tempfiles to the temporary tablespaces after recovery
    • C、perform a media recovery and open the database with the RESETLOGS option
    • D、perform a media recovery and bring the database to NOARCHIVELOG mode

    正确答案:B,C

  • 第7题：

    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

    • A、 Restore the lost data file from the backup， and then flash back the database.
    • B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
    • C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
    • D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
    • E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

    正确答案:B,E

  • 第8题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    多选题
    Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
    A

    adding a new user to the database

    B

    dropping a user from the database

    C

    dropping a table from the database

    D

    dropping a data file from a tablespace

    E

    adding a new tablespace to the database


    正确答案： D,C
    解析： 暂无解析

  • 第10题：

    单选题
    Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
    A

     Restore all the datafiles from the backup.

    B

     Restore only the lost datafile from the backup.

    C

     Restore all the datafiles for the lost tablespace from the backup.

    D

     Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    多选题
    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


    正确答案： A,E
    解析： 暂无解析

  • 第12题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第14题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第15题：

    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

    • A、Take the USERS tablespace offline and re-create the lost data file.
    • B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
    • C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
    • D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

    正确答案:C

  • 第16题：

    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and performtablespacerecovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第17题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第18题：

    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

    正确答案:B

  • 第19题：

    多选题
    In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：  RMAN> RESTORE CONTROLFILE；  Which two operations do you need to perform after restoring the control file from backup？（）
    A

    shut down and restart the instance

    B

    add new tempfiles to the temporary tablespaces after recovery

    C

    perform a media recovery and open the database with the RESETLOGS option

    D

    perform a media recovery and bring the database to NOARCHIVELOG mode


    正确答案： B,C
    解析： 暂无解析

  • 第20题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


    正确答案： D,B
    解析： 暂无解析

  • 第21题：

    多选题
    Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs. Which three steps should you perform to recover the control file and make the database fully operational?（）
    A

    Mount the container database (CDB) and restore the control file from the control file auto backup.

    B

    Recover and open the CDB in NORMAL mode.

    C

    Mount the CDB and then recover and open the database, with the RESETLOGS option.

    D

    Open all the pluggable databases.

    E

    Recover each pluggable database.

    F

    Start the database instance in the nomount stage and restore the control file from control file auto backup.


    正确答案： B,D
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


    正确答案： B,E
    解析： 暂无解析

  • 第24题：

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.

    C

    Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.

    D

    Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online


    正确答案： A
    解析： 暂无解析

相关内容