A.It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

B.It must be invoked by a user with root user privileges.

C.It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.

D.Patches are applied via opatchauto.

E.It applies patches in nonrolling mode by default.

F.It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.

G.Users must always input patch plans to opatchauto.

A.The target PDB must be registered in a Virtual Private Catalog.

B.The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

C.The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

D.The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

E.The target PDB must be registered in a base catalog.

F.The base catalog must be enabled for Virtual Private Catalog use.

A.The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

B.Oracle DBCA templates can store only logical structure and not database files.

C.New templates can only be created by modifying an existing user-created template.

D.The Data Warehouse template is most suitable when transaction response time is the key criterion.

E.Oracle DBCA templates can be used to create new databases and duplicate existing databases.

A.By default, AWR snapshots are retained for 7 days.

B.Its collection level is determined by the value of the statistics_level database parameter.

C.AWR data is stored in the system tablespace.

D.The taking of AWR snapshots can be disabled.

E.By default, AWR snapshots are taken every 60 minutes.

A.It is integrated with the SQL Access Advisor.

B.It predicts the impact of system changes on SQL workload response time.

C.It provides before and after execution statistics for each SQL statement in the analysis task

D.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

E.SQL statements that were originally run concurrently are run concurrently by SPA.