Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:

Which two are true?

• A.The maptable table is a metadata-linked table.
• B.The maptable table defines a logical partition key on a commonly used column for the revenue table.
• C.The containers clause cannot be used in queries on the revenue table.
• D.The revenue table must be a list-partitioned table.
• E.The revenue table partitions are not pruned across the PDBs automatically.
• F.A container map exists for the revenue table, but Is not enabled.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle database methodology? (Choose two.)

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.Tuning activities should stop once the user is satisfied with performance.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.SQL statements should always be tuned before tuning any file systems.
• F.The alert log should be used to find the database and instance areas most in need of tuning.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the SQL Tuning Advisor? (Choose three.)

• A.It considers all SQL statements being analyzed by the advisor task as a group.
• B.It only recommends syntactic changes to SQL statements.
• C.It checks each query being analyzed for missing statistics.
• D.It checks each query being analyzed for stale statistics.
• E.It can recommend semantic changes to SQL statements.
• F.It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• E.It is always possible for RMAN to connect to a pluggable database as a target.
• F.A Virtual Private Catalog used to register a container database can be created in a non-container database.

Comment: *

Name: *

Email: *

Verification: *

You execute this command successfully:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
What is the outcome?

• A.It creates a binary backup of the control file.
• B.It creates a file that contains RMAN scripts to create a duplicate database.
• C.It creates a copy of the control file in the fast recovery area (FRA).
• D.It creates a file that contains SQL statements to re-create the control file.
• E.It updates the alert log with the location and contents of the control file

Comment: *

Name: *

Email: *

Verification: *