Which two are true about Oracle Flashback features? (Choose two.)

• A.FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• B.After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.
• C.FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• D.FLASHBACK DROP can undrop an index when undropping a table.
• E.FLASHBACK TABLE can undrop a column.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2.ORCL uses disk group +FRA for the Fast Recovery Area.
3.LISTENER is the listener for ORCL.
4.The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5.All components are currently shut down.
You execute this command:

What is the outcome?

• A.Only the ORCL database instance is started.
• B.Only the ORCL database and the ASM instances are started.
• C.Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
• D.Only the ORCL database instance and the +DATA and +FRA disk groups are started.
• E.The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

Comment: *

Name: *

Email: *

Verification: *

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)

• A.The HR_PDB1clone created in CDB2 will be in mount state when cloning ends.
• B.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• C.A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• D.CDB1 and CDB2 must be in shared undo mode.
• E.Cloning HR_ROOT automatically clones HR_PDB1.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• B.It provides before and after execution statistics for each SQL statement in the analysis task
• C.It predicts the impact of system changes on SQL workload response time.
• D.It is integrated with the SQL Access Advisor.
• E.SQL statements that were originally run concurrently are run concurrently by SPA.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)

• A.orainstRoot.shcan be executed automatically by the Database installer by using sudoor root credentials.
• B.root.shcan be executed automatically by the Database Installer only if it is provided with root credentials.
• C.The sudopassword can be specified in a response file.
• D.root.shcan be executed automatically by the Database installer only by using sudocredentials.
• E.The sudopassword must be specified in a response file.
• F.The rootpassword cannot be specified in a response file.

Comment: *

Name: *

Email: *

Verification: *