You install Oracle Grid Infrastructure for a standalone server. 

Which two components are automatically included in the Oracle Restart configuration? (Choose two.)

Automatic Shared Memory Management is enabled for your database instance. 

You notice that there are SQL statements performing poorly because of repeated parsing activity. 

Which action generates recommendations to overcome the performance issues?

Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

Which two statements are true about resumable space allocation? (Choose two.)

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo. 

Which two actions would you take to solve this problem? (Choose two.)

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. 

To achieve this, you enable the raising of file arrival events from remote systems. 

Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

Unified auditing is enabled in your database. 

The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: 

SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin; 

Which statement is true?

You determine that database performance is sub-optimal due to hard parsing statements. 

Automatic Shared Memory Management (ASMM) is disabled for your database instance. 

Which tool would you use to get advice on how to improve performance?