Which two statements about ADDM are true?
A. Real-Time ADDM uses AWR snapshots of the last 10 minutes.
B. Real-Time ADDM uses ASH recent activity from SGA data.
C. Real-Time ADDM analyzes performance in a completely different fashion than regular ADDM.
D. Regular ADDM uses AWR snapshots that are not yet purged.
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
A. STARTUP
B. SHUTDOWN
C. CREATE DATABASE
D. DROP DATABASE
E. ALTER DATABASE RECOVER
To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should
you follow?
1 -Start the analysis.
2 - Set up the analysis policy type (database, role, context).
3 - Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 - Stop the analysis.
A. 1, 2, 3, 4, 5
B. 2, 1, 5, 3, 4
C. 5, 1, 2, 3, 4
D. 2, 3, I, 5, 4
E. 1, 2, 4, 5, 2
Which two statements are true regarding undo data records?
A. They are required to support Flashback features.
B. They are not required if Flashback features are enabled.
C. They are retained until the session making the changes ends.
D. Undo records contain copies of data as it appears after a change is made.
E. Undo records contain copies of data as it appears before a change is made.
A standby database is in mounted state and you are required to perform a failover to the physical standby. Which solution is best suited forthis scenario?
A. ALTER DATABASE RECOVER MANAGED STANDBY DATABASE statement with the FINISH keyword
B. ALTER DATABASE PREPARE TO SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER statements
C. ALTER DATABASE RECOVER TO STANDBY DATABASE statement with the FINISH keyword
D. D) ALTER DATABASE PREPARE SWITCHOVER and ALTER DATABASE COMMIT TO SWITCHOVER Statements
You need to recover a database running In NOARCHIVELOG mode. Which two statements are true in this scenario?
A. You can perform complete recovery by using the command: RESTORE DATABASE FROM TAG"consistent_whole_backup"; RECOVER DATABASE;
B. You can perform incomplete recovery by using the command: RESTORE DATABASE; FROM TAG "consistent_whole_backup"; RECOVER DATABASE NOREDO;
C. Only consistent backups can be used for restoring a database in NOARCHIVELOG mode.
D. Media recovery is possible in most cases.
Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?
A. the CDB as the ROOT user
B. the CDB as the CDBADMIN user
C. the PDB as the ROOT user
D. the PDB as the PDB Admin user
Which two statements are true about listeners?
A. Listeners use only the TCP/IP protocol.
B. Multiple listener processes can run simultaneously on a host.
C. Multiple database instances can be registered with a single listener,
D. Listener-related errors can be traced only at the administrative level.
E. Only one database instance can be registered with a single listener at any time.
Which statement regarding Oracle Active Data Guard 12c is false?
A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.
B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.
C. It repairs block corruptions detected in the primary or standby database.
D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.
E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.
Which four items exist in the root of a CDB, but not in the PDBs?
A. shared UNDO and default database temporary tablespace
B. Oracle-supplied metadata
C. shared Oracle-supplied data
D. CDB views providing information across PDBs
E. application tablespaces
F. local temporary tablespaces
G. local users and local roles H. non-shared local metadata
