首页计算机考试Oracle认证
(多选题)

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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? ()

    答案解析

快考试在线搜题