QUESTION NO: 472
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
检查查询的输出,你执行该查询以列出在回收站中的对象:
您验证没有名为SALES TAB的表存在于方案,然后执行以下
命令来清除回收站中的对象:
B.只有拥有最古老的DROPSCN的表被清除