OCP-1Z0-053-V12.02-271题

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

Answer: B

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_9018.htm#SQLRF55167

TABLE or INDEX

Specify the name of the table or index in the recycle bin that you want to purge. You can specify either the original user-specified name or the system-generated name Oracle Database assigned to the object when it was dropped.

• If you specify the user-specified name, and if the recycle bin contains more than one object of that name, then the database purges the object that has been in the recycle bin the longest.

• System-generated recycle bin object names are unique. Therefore, if you specify the system-generated name, then the database purges that specified object.

When the database purges a table, all table partitions, LOBs and LOB partitions, indexes, and other dependent objects of that table are also purged.