A. PMON performs process recovery when a client process fails.
B. PMON performs listener registration.
C. PMON restarts background and dispatcher processes when they fail.
D. During instance startup, PMON takes care of instance recovery.
E. PMON resolves failures of distributed transactions.
A. It is ignored by the query optimizer.
B. The index cannot be rebuilt, and has to be re-created.
C. It is not used while the index is being rebuilt.
D. The index is automatically rebuilt when used the next time.
A. You can drop the PDB and keep the data files to be reused by another PDB.
B. When you drop the PDB, the data files and redo log files are automatically removed from the storage file system.
C. You can drop the PDB only if it is closed.
D. You can drop the seed PDB, but you cannot create any other PDB within the CD
A. It securely manages encryption keys.
B. It alters data in caches, buffers, and persistent storage.
C. It impacts operational activities such as backup & restore, upgrade & patch, and replication.
D. It protects against theft or loss of disks and backups.
E. It limits the exposure of sensitive data in applications.
F. It prevents OS users from inspecting tablespace files.
G. It transparently encrypts data at rest in Oracle databases.
A. db_name
B. control_files
C. instance_name
D. maxdatafiles
A. read uncommitted
B. serializable
C. read committed
D. read-only
A. The service has been disabled on that database.
B. The service has reached its cardinality defined by the number of preferred databases.
C. The database role is different from the role attribute of the service.
D. The database is open and registered with a global service manager.
E. No other database in the pool is a better candidate for starting the service.
F. The replication lag on the database does not exceed the maximum value specified for the service.
A. Regular ADDM uses AWR snapshots that are not yet purged.
B. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
C. Real-Time ADDM uses ASH recent activity from SGA data.
D. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
A. ALTER DATABASE RECOVER
B. STARTUP
C. SHUTDOWN
D. DROP DATABASE
E. CREATE DATABASE
A. The VSFIXED_TABLEview can be queried to list the names of these views.
B. They are owned by the SYS user.
C. They speed up query and data manipulation language (DML) operations.
D. They are stored in the SYSTEM tablespace.
E. They are based on virtual tables.
