Oracle
1Z0-034 · Question #102
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?
The correct answer is B. GRANT SELECT ANY TRANSACTION TO scott; C. GRANT EXECUTE ON dbms_flashback TO scott; D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS. See the full explanation below for the reasoning.
Question
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?
Options
- AALTER DATABASE FLASHBACK ON;
- BGRANT SELECT ANY TRANSACTION TO scott;
- CGRANT EXECUTE ON dbms_flashback TO scott;
- DALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
- EALTER TABLESPACE undots1 RETENTION GUARANTEE;
- FALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
How the community answered
(57 responses)- A11% (6)
- B74% (42)
- E16% (9)
Community Discussion
No community discussion yet for this question.