A.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).

B.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.

C.Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.

D.System statistics can be gathered only while connected to cdb$root.

E.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.

A.issuing multiple savepoints during a transaction

B.poorly written SQL

C.poorly trained users who do not commit transactions

D.the number of data files containing extents belonging to tables updated by a transaction

E.the number of tablespaces containing tables updated by a transaction

A.The REVENUEtable must be a list-partitioned table.

B.The REVENUEtable partitions are not pruned across the PDBs automatically.

C.The CONTAINERSclause cannot be used in queries on the REVENUEtable.

D.A container map exists for the REVENUEtable, but is not enabled.

E.The MAPTABLEtables defines a logical partition key on a commonly used column for the REVENUEtable.

F.The MAPTABLE table is a metadata-linked table.

A.when the hardware platform needs to be changed as part of the upgrade

B.when a character set conversion is required during the upgrade

C.when the target and source database are on the same platform

D.when multiple pluggable databases in a container database have to be upgraded in a specific sequence

E.when the operating system (OS) needs to be changed as part of the upgrade

A.Tuning activities should stop once the user is satisfied with performance.

B.The alert log should be used to find the database and instance areas most in need of tuning.

C.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

D.The database instance memory should always be tuned before tuning any file systems.

E.Tuning activities should stop onceagreed service levels for performance have been met.

F.SQL statements should always be tuned before tuning any file systems.