You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
Which five steps are performed by RMAN?
Examine the parameter for your database instance:
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
Identify the reason why the optimizer chose different execution plans.
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?
Which two statements are true about Oracle Direct Network File System (NFS)?
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
Which three statements are true about Flashback Database?
You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?
You issue the following commands:
The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata' exist.
Which statement describes the outcome?