试题详情
- 多项选择题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?()
A、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;
- B,C,D,F
关注下方微信公众号,在线模考后查看
热门试题
- 下面不属于Oracle数据库状态的是()
- Evaluate the SQL st
- 写出ORACLE的四种文件。(从物理存储
- You have
- Which two code fragm
- Examine the descrip
- You are
- The following&
- You are managing an
- Which two commands n
- Given: And the
- The following&
- YouareusingRecoveryM
- You are managing an
- User SCOTT&ensp
- 假设在数据库中创建了用户test,需要为
- Examine the structu
- You dropped&en
- Which of
- In which