Which two are prerequisites for performing Flashback Transaction?

• A.The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
• B.A supplemental log must be enabled for the primary key.
• C.Undo retention guarantee must be configured for the database.
• D.A supplemental log must be enabled for the primary key.
• E.Fast Recovery Area must be enabled for the database

Comment: *

Name: *

Email: *

Verification: *

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE comman

• A.No catalogued backup of the TARGET is used to duplicate the databa
• B.It fails because connection to the AUXILIARY instance must be as SYSD
• C.It succeed
• D.Itsucceeds only if the target database is greater than 40
• E.It fails because no parallel channels are allocated for the auxiliary databa

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about server-generated alerts?

• A.Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
• B.Stateless alerts are automatically cleared after one day.
• C.Stateless alerts can be purged manually from the alert history.
• D.Stateful alerts are purged automatically from the alert history after one day.
• E.Stateless alerts can be cleared manually.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A.The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• B.The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• C.A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• D.Only the grid user can perform the upgrade.
• E.Existing Oracle Database instances must be shut down before starting the upgrade.
• F.An existing Oracle base can be used.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

• A.After the change, only one undo tablespace can exist in CDB$ROOT.
• B.After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• C.Undo tablespaces existing in PDBs must be dropped before the change.
• D.After the change, each existing PDB has to be reopened for the new undo mode to take effect.
• E.After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• F.Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *