可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

User SCOTT wants to back out the trans


User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? ()(Choose four.)

  • 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
参考答案
参考解析:
分类:1Z0-053题库
相关推荐

1、You want to flash back a test database

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two s...

2、The user Alice wants to grant all user

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()A GRANT select ON dept TO ALL_ USER;B GRANT select ON dept TO ALL;C GRANT QUERY ON dept TO ALL_USERSD GRANT select ON dept TO PUBLIC

3、The user SCOTT who&ens

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT...

4、You want to back up your 100-GB datab

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while...

5、The user SCOTT execute

The user SCOTT executes the following command successfully to increase the salary values in one...

6、The SCOTT user has&#

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As p...