A. Segment Advisor B. SQL Access Advisor C. Undo Advisor D. SQL Tuning Advisor
Observe the following warning in an RMAN session of your database instance: WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?()
A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository(ADR) B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed
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