User SCOTT wants to back out the transactions on the REGIONS table in his schem

User SCOTT wants to back out the transactions on the REGIONS table in his schem

User SCOTT wants to back out the transactions on the REGIONS table in his schem

A.
As a DBA, which commands must you execute to enable SCOTT to flash back the
transactions? (Choose four.)
ALTER DATABASE FLASHBACK ON;

A.
As a DBA, which commands must you execute to enable SCOTT to flash back the
transactions? (Choose four.)
ALTER DATABASE FLASHBACK ON;

B.
GRANT SELECT ANY TRANSACTION TO scott;

C.
GRANT EXECUTE ON dbms_flashback TO scott;

D.
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E.
ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F.
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;



Leave a Reply 0

Your email address will not be published. Required fields are marked *