053-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

  此题考点是 purge table xxx,会在回收站中移除这个表。如果在回收站中有多个同名的版本,
此命令只会移除在回收站中时间最长的那个版本。

 

原文地址:https://www.cnblogs.com/Babylon/p/7844094.html