多选题

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

略

相似试题

What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）
单选题查看答案
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
多选题查看答案
Which of the following roles must be granted to a user to perform a full database import？（）
单选题查看答案
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）
单选题查看答案
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? （）
单选题查看答案
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）
单选题查看答案
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?（）
单选题查看答案
You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）
单选题查看答案
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证