违法和不良信息举报 联系客服
免费注册 登录

单选题In which scenario will you perform a user-managed incomplete recovery？（）A  when a table is dropped and stored in the Recycle BinB when a table is dropped and purged from the Recycle BinC  when you are required to recover an existing table to its previo

题目
单选题
In which scenario will you perform a user-managed incomplete recovery？（）
A

 when a table is dropped and stored in the Recycle Bin

B

when a table is dropped and purged from the Recycle Bin

C

 when you are required to recover an existing table to its previous state

D

 when you are required to view all the versions of a row of an existing table between a specific time period

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

In which scenario will you perform a cancel-based recovery？（）

  • A、 when a tablespace is dropped and you have only RMAN-based backup of the database
  • B、 when a table is dropped and stored in the Recycle Bin
  • C、 when you are required to recover an existing table to its previous state
  • D、 when a tablespace is dropped and you have only a user-managed full backup of the database

正确答案:D

第2题：

In which scenario will you use the Flashback Transaction Query feature？（）

  • A、 when you want to restore an important table that is dropped from the Recycle Bin
  • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
  • C、when you want to restore a dropped user’s schema
  • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

正确答案:B

第3题：

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table:SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP;What would be the outcome of the precedent statement?（）

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column


参考答案：A

第4题：

Which two statements are correct regarding the Oracle Flashback Drop feature？ （）

  • A、 Recycle bin exists for the tables only in non-SYSTEM， locally managed tablespaces.
  • B、 You can flash back a dropped table provided row movement has been enabled on the table.
  • C、 If you drop an index before dropping its associated table， then the recovery of the index is not supported when you flash back the dropped table.
  • D、 When you execute the DROP TABLESPACE？ INCLUDING CONTENTS command， the objects in the tablespace are places in the recycle bin.
  • E、 When a dropped table is moved to the recycle bin， only the table is renamed to a system-generated name； its associated objects and constraints are not renamed.
  • F、 If you drop a table that is protected by the recycle bin， then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.

正确答案:A,C

第5题：

You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

  • A、 UNTIL CANCEL
  • B、 UNTIL SCN
  • C、 UNTIL SEQUENCE
  • D、 UNTIL TIME

正确答案:A

第6题：

In which scenario do you use the Flashback Database feature？（）

  • A、 when a table is dropped and you restore it from the Recycle Bin
  • B、 when a user’s schema is dropped and you recover the user’s schema
  • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
  • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

正确答案:B

第7题：

You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  • A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.
  • B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.
  • C、 The control file must be recreated.
  • D、 The database must be opened with the RESETLOGS option.

正确答案:C

第8题：

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）

  • A、 until Thursday morning
  • B、 until that point in time when the database is opened
  • C、 until that point in time when the recovery is performed
  • D、 until last Sunday’s backup
  • E、 until that point in time when the table is dropped and purged
  • F、 until Wednesday evening

正确答案:D

第9题：

In which scenario will you perform a user-managed incomplete recovery？（）

  • A、 when a table is dropped and stored in the Recycle Bin
  • B、when a table is dropped and purged from the Recycle Bin
  • C、 when you are required to recover an existing table to its previous state
  • D、 when you are required to view all the versions of a row of an existing table between a specific time period

正确答案:B

第10题：

In which scenario will you use the Flashback Version Query feature？（）

  • A、 when you want to restore a table that has been dropped from the Recycle Bin
  • B、 when you want to identify the transaction ID of the transaction that deleted some important records from a table
  • C、 when you want to recover the schema of a dropped user
  • D、when you want to restore a dropped tablespace

正确答案:B

更多相关问题
相关内容