Oracle 11gocmu Actual Free Exam Questions & Community Discussion

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?

Which background process coordinates the rebalance activity for disk groups?

You execute the following Recovery Manager (RMAN) commands in (he following order:
BACKUP VALIDATE DATABAE
RECOVER CORRUPTION LIST;
Which (two tasks are performed by these commands? (Choose two.)

What methods of point-in-time recovery are available? (Choose all that apply.)

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

A user named Arren is executing this query:
select table_name, operation, undo_sql from flashback_transaction_query t, (select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123) e where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem. Which of the following SQL statements will correct this problem?

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.
What must you do accomplish this task?

The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)