A.The solution that best optimizes one SQL statement can degrade the performance of others.

B.SQL statements doing joins always do more physical I/O than single table queries.

C.SQL statements doing only logical reads never require tuning because they do no physical I/O.

D.SQL statements performing many physical I/Os can always have their performance improved by creating indexes.

E.Poorly performing SQL statements can be tuned automatically by the Oracle server.

A.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.

B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.

C.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

D.Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

E.It is not possible for media corrupt blocks.

A.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

B.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

C.An existing Oracle base can be used.

D.Only the grid user can perform the upgrade.

E.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

F.Existing Oracle Database instances must be shut down before starting the upgrade.

A.It contains predefined common roles in both the root and the seed.

B.It can contain only one Application Container seed, which is created when the Application Container is created.

C.It can have any number of pluggable databases (PDBs) limited only by space availability.

D.It can have local users with the same name in different PDBs.

E.It can contain only one PDB$SEED, which is created when the CDB is created.

F.It can be created by cloning an existing CDB.

G.It can be created from a non-CDB.

A.A base release is not needed to install patchsets.

B.They are installed via OPatch or OPatchAuto.

C.Installing a patchset is considered an "upgrade".

D.They can be applied in a rolling fashion for Clusterware and the databases.

E.They are only released quarterly.

F.They can introduce new features.