niusouti.com

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 EXEC

题目

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;
相似考题

1.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;

2.You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

3.You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）A、 V$FLASHBACK_DATABASE_LOGB、 V$FLASHBACK_DATABASE_STATC、 V$DATABASED、 V$UNDOSTAT

4.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;

更多“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 EXEC”相关问题

  • 第1题：

    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

    • A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
    • B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

    正确答案:C

  • 第2题：

    The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）

    • A、HR can grant the privilege to JIM but without GRANT OPTION.
    • B、HR can grant the privilege to JIM because HR is the owner of the view.
    • C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
    • D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

    正确答案:D

  • 第3题：

    User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *  ERROR at line 1：  ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）

    • A、Grant the RESOURCE role to SCOTT.
    • B、Add data files to the USERS tablespace.
    • C、Grant the CREATE ANY TABLE privilege to SCOTT.
    • D、Increase the space for SCOTT on the USERS tablespace.
    • E、Increase the size of the data file associated with the USERS tablespace

    正确答案:B,E

  • 第4题：

    You issue the following code：    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        （’SCOTT’ ’GRP1’， TRUE）；   What will be the result of executing the above code？（）  

    • A、 The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.
    • B、 The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.
    • C、 The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.
    • D、The code will execute successfully but no privilege will be granted to the user， Scott.

    正确答案:A

  • 第5题：

    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

    • A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
    • B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

    正确答案:C

  • 第6题：

    You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：        SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP  （’SCOTT’，       ’GRP1’， FALSE）；   How will you grant the switch privilege to the user， Scott？（）  

    • A、 by using the DBMS_SESSION package
    • B、 by granting the DBA role
    • C、 by using the DBMS_RESOURCE_MANAGER package
    • D、 by using the DBMS_RESOURCE_MANAGER_PRIVS package

    正确答案:D

  • 第7题：

    多选题
    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;


    正确答案： C,F
    解析： 暂无解析

  • 第8题：

    多选题
    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;


    正确答案： E,C
    解析： 暂无解析

  • 第9题：

    单选题
    The HR user creates a view with this command：  SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp；  Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user.  Which statement is true in this scenario？（）
    A

    HR can grant the privilege to JIM but without GRANT OPTION.

    B

    HR can grant the privilege to JIM because HR is the owner of the view.

    C

    SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.

    D

    HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    You issue the following code：    EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP        （’SCOTT’ ’GRP1’， TRUE）；   What will be the result of executing the above code？（）
    A

     The switch privilege will be granted to the user， Scott， for changing the consumer group to GRP1.

    B

     The switch privilege will be granted to the user， Scott， for changing the consumer group from GRP1 to any other group.

    C

     The code will not execute successfully because there is no GRANT_SWITCH_CONSUMER_GROUP procedure in the DBMS_RESOURCE_MANAGER_PRIVS package.

    D

    The code will execute successfully but no privilege will be granted to the user， Scott.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）
    A

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

    B

    One audit record is created for every session when any user successfully drops a table owned by SCOTT.

    C

    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

    D

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

    E

    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
    A

     V$FLASHBACK_DATABASE_LOG

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$DATABASE

    D

     V$UNDOSTAT


    正确答案： B
    解析： 暂无解析

  • 第13题：

    The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

    • A、The session is terminated after receiving the error and JIM can continue with his transaction.
    • B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
    • C、The session is rolled back after receiving the error and JIM can continue with his transaction.
    • D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

    正确答案:B,D

  • 第14题：

    You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

    • A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
    • B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
    • C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
    • D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
    • E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

    正确答案:A

  • 第15题：

    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

  • 第16题：

    The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

    • A、The command fails because SCOTT still has privileges.
    • B、The command succeeds and privileges are revoked from JIM.
    • C、The command fails because HR cannot revoke the privileges from JIM.
    • D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

    正确答案:C

  • 第17题：

    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;

    正确答案:B,C,D,F

  • 第18题：

    单选题
    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
    A

    One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.

    B

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
    A

    Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

    B

    Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    A user named Arren is executing this query：   select table_name，operation，undo_sql  from  flashback_transaction_query t，  （select versions_xid as xid  from employees versions between scn minvalue and maxvalue  where employee_id = 123） e  where t.xid = e.xid；   When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem.  Which of the following SQL statements will correct this problem？（）
    A

     GRANT SELECT ANY TRANSACTION TO ARREN

    B

     GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN

    C

     GRANT SELECT_ANY_TRANSACTION TO ARREN

    D

     GRANT FLASHBACK TO ARREN

    E

     GRANT SELECT ANY VIEW TO ARREN


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
    A

    The command fails because SCOTT still has privileges.

    B

    The command succeeds and privileges are revoked from JIM.

    C

    The command fails because HR cannot revoke the privileges from JIM.

    D

    The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）
    A

     You must enable the block change tracking feature.

    B

     You must have enable the flashback feature.

    C

     You must use the OMF in your database.

    D

     You must define the tablespace of the SCOTT.EMP table for automatic segment space management.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    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


    正确答案： E,D
    解析： 暂无解析

相关内容