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

You discover that your Recycle Bin contains two tables with 

题目
单选题
You discover that your Recycle Bin contains two tables with the same name， MY_TABLE. You also have a table named MY_TABLE in your schema. You execute the following statement：   FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2；   What will be the result of executing this statement？（）
A

 One of the tables is recovered from the Recycle Bin using a First In First Out （FIFO） approach.

B

 One of the tables is recovered from the Recycle Bin using a Last In First Out （LIFO） approach.

C

 Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

D

 None of the tables are recovered from the Recycle Bin， and the statement returns an error.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

What are two reasons to create synonyms?（）

  • A、You have too many tables.
  • B、Your tables are too long.
  • C、Your tables have difficult names.
  • D、You want to work on your own tables.
  • E、You want to use another schema's tables.
  • F、You have too many columns in your tables.

正确答案:B,C

第2题：

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

第3题：

You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()

A. All the objects of scott are moved to the Recycle Bin.

B. Any objects in the Recycle Bin belonging to scott are purged.

C. All the objects owned by scott are permanently dropped from the database.

D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


参考答案：B, C

第4题：

Your network contains a single Active Directory domain. The functional level of the forest is Windows  Server 2008 R2.   You need to enable the Active Directory Recycle Bin.   What should you use（）

  • A、the Dsmod tool
  • B、the Enable-ADOptionalFeature cmdlet
  • C、the Ntdsutil tool
  • D、the Set-ADDomainMode cmdlet

正确答案:B

第5题：

You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

  • A、 MOUNT mode
  • B、 RESTRICTED mode
  • C、 OPEN mode
  • D、 NOMOUNT mode

正确答案:A

第6题：

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

第7题：

Which of the following statements are true regarding the Recycle Bin？（）

  • A、 The Recycle Bin is a physical storage area for dropped objects.
  • B、 The Recycle Bin is a logical container for dropped objects.
  • C、 The Recycle Bin stores the results of a Flashback Drop operation.
  • D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.

正确答案:B,D

第8题：

Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged


参考答案：B

第9题：

Your network contains an Active Directory forest. The forest contains two domains.  You have a standalone root certification authority （CA）.   On a server in the child domain， you run the Add Roles Wizard and discover that the option to select an  enterprise CA is disabled.   You need to install an enterprise subordinate CA on the server.   What should you use to log on to the new server（）

  • A、an account that is a member of the Certificate Publishers group in the child domain
  • B、an account that is a member of the Certificate Publishers group in the forest root domain
  • C、an account that is a member of the Schema Admins group in the forest root domain
  • D、an account that is a member of the Enterprise Admins group in the forest root domain

正确答案:D

第10题：

Your network contains a single Active Directory domain. The functional level of the forest is  Windows Server 2008. The functional level of the domain is Windows Server 2008 R2. All DNS servers run Windows Server 2008. All domain controllers run Windows Server 2008 R2. You need to ensure that you can enable the Active Directory Recycle Bin. What should you do（）

  • A、Change the functional level of the forest.
  • B、Change the functional level of the domain.
  • C、Modify the Active Directory schema.
  • D、Modify the Universal Group Membership Caching settings.

正确答案:A

更多相关问题
相关内容