A. user process failure

B. network interface card (NIC) failure

C. statement failure

D. transaction failure

E. media failure

A. password files

B. server parameter files (SPFILE)

C. dump files

D. control files

E. input files

F. bad files

A. ADDM can recommend extending the buffer cache.

B. ADDM performs its analysis only whenever a DBA requests it.

C. ADDM can recommend shrinking the buffer cache.

D. By default, MMON creates an AWR snapshot every 30 minutes.

E. By default, AWR snapshots are automatically purged after eight days.

F. AWR snapshots must be deleted when no longer required by ADDM.

A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.

B. FLASHBACK DATABASE can be used to rewind a database back and forth in time.

C. FLASHBACK TABLE can be used to undo dropping a column from a table.

D. FLASHBACK QUERY can be used to view committed data at any given point in time.

E. FLASHBACK TABLE can be used to rewind a table back in time.

A. executing UPDATE statements

B. creating invisible indexes

C. creating views

D. creating public synonyms

E. creating partitions

A. It always generates redo.

B. It locks objects being processed.

C. It does not generate UNDO.

D. It enforces referential integrity constraints.

E. It cannot load data into clustered tables.

A. They are maintained at the session and system level.

B. They display how often a database instance performs particular operations.

C. They are grouped into classes.

D. All events might be used by an instance regardless of parameter settings.

E. They reveal the cause of performance problems.

A. It can re-optimize execution plans after previous executions detect suboptimal plans.

B. It will only generate SQL Plan Directives specific to a given SQL statement.

C. It determines the optimal table join order and method.

D. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

E. It updates stale object statistics in the Data Dictionary.

F. It can optimize only SELECT statements.

A. The SYSDBA privilege can be granted to a user or role.

B. Connections as SYS must be made using the SYSDBA privilege

C. Connections as SYSTEM can use only the SYSOPER privilege.

D. System privileges can be granted only to users.

E. The owner of a schema is granted all object privileges within the schema by default.