A.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

B.V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

C.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

D.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

E.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

F.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

A.A lost password file can be re-created with SQL*PLUS.

B.A lost PFILE can be re-created alert.log using SQL*PLUS.

C.A lost password file can be manually re-created with the orapwd utility.

D.A lost TEMPFILE must always be re-created manually.

E.A lost SPFILE can be recovered from memory using SQL*PLUS.

F.A lost index tablespace can be re-created without performing any recovery.

A.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

B.The solution that best optimizes one SQL statement can degrade the performance of others.

C.SQL statements doing joins always do more physical I/O than single table queries.

D.SQL statements doing only logical reads never require tuning because they do no physical I/O.

E.Poorly performing SQL statements can be tuned automatically by the Oracle server.

A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

A.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

B.to exclude a temp tablespace when plugging in a PDB

C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB

D.to include specific user tablespaces only when relocating a PDB

E.to specify the list of tablespaces to include when creating a PDB from the CDB seed

F.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.