niusouti.com

多选题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.)AALTER DATABASE FLASHBACK ON;BGRANT SELECT any transaction TO sco

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

相似考题

1.在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）A.ALTER PROFILE USER scott otherprofileB.ALTER otherprofile USER scottPROFILEC.ALTER USER scott PROFILE otherprofileD.ALTER scott USER PROFILE otherprofile

2.You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects owned by scott are permanently dropped from the database.D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

3.The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?()A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user

4.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,F
解析： 暂无解析
更多“User SCOTT wants to back out the transactions on the REGIONS”相关问题

  • 第1题：

    在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）

    A.ALTER USER scott IDENTIFIED BY hello

    B.ALTER scott USER IDENTIFIED BY hello

    C.ALTER USER scott IDENTIFIED AS hello

    D.ALTER USER hello IDENTIFIED BY scott


    正确答案：A

  • 第2题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？（）

    • A、Transactions are rolled back using redo log files.
    • B、Transactions are rolled forward using redo log files.
    • C、Transactions are rolled back using redo log files and archived log files.
    • D、Transactions are rolled forward using redo log files and rolled back using redo log files.

    正确答案:B

  • 第3题：

    kristin wants to build an action which exits the video form. the action will be avaiable only when the user is reading the document ,which one of the following accomplish this ? （）

    • A、@ command([back])    
    • B、@ command([fileexit])   
    • C、@ command([gotoview])     
    • D、@ command([fileclosewindow])

    正确答案:D

  • 第4题：

    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

  • 第5题：

    The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）

    • A、no privileges
    • B、only the SELECT privilege
    • C、only the CONNECT privilege
    • D、all the privileges of a default user

    正确答案:A

  • 第6题：

    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

  • 第7题：

    单选题
    What will be the result of using the SQL> DROP USER SCOTT CASCADE； command？（）
    A

     The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and the objects that are  already in the Recycle Bin are dropped.

    B

     The user， Scott， is dropped， all the objects in Scott’s schema are placed in the Recycle Bin， and all the objects in the Recycle Bin， belonging to the user Scott， are not dropped.

    C

     The user， Scott， is dropped， all the objects in the Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin， belonging to the user， Scott， are not dropped.

    D

     The user， Scott， is dropped， all the objects in Scott’s schema are not placed in the Recycle Bin， and the objects in the Recycle Bin are dropped.


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

  • 第8题：

    单选题
    You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE   （PLAN => ’SALES_PLAN’，   GROUP_OR_SUBPLAN => ’MANAGERS’，   CPU_P1 => 100， CPU_P2 =>0，   SWITCH_GROUP => ’CLERKS’，   SWITCH_TIME_IN_CALL => 600）；   A user， SCOTT， who is assigned to the MANAGERS group， starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete？（）
    A

     The query starts under the CLERKS group and the user， SCOTT， switches back to the MANAGERS group after the query completes.

    B

     The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.

    C

     The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.

    D

     The query starts under the MANAGERS group， the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes， and then switches back to the MANAGERS group after the query completes.


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

  • 第9题：

    单选题
    An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file（）
    A

    /tmp

    B

    /var/preserve

    C

    /var/tmp/$USER

    D

    $HOME/.vi


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

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    多选题
    User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror 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 eitherof 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,A
    解析： 暂无解析

  • 第12题：

    单选题
    You manage several computers that run Windows 7. A user wants to roll back a driver. The user opens thedevice properties in Device Manager and discovers that the Roll Back Driver option is unavailable. Youconnect to the computer by using Windows Remote Assistance. You need to roll back the driver to itsprevious version.  What should you do first?（）
    A

    Add the user to the Power Users group.

    B

    Right-click Device Manager and select Run as administrator.

    C

    From System Properties， modify Device Installation Settings.

    D

    From the Local Group Policy， modify Device Installation Restrictions.


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

  • 第13题：

    在Oracle中，将当前系统所有角色都授予scott，除Payroll外，下列哪个是正确的?()

    A、ALTER DEFAULT ROLLE USER scott ALL EXCEPT Payroll

    B、ALTER USER DEFAULT ROLLE ALL EXCEPT Payroll

    C、ALTER DEFAULT ROLLE ALL EXCEPT USER scott

    D、ALTER USER scott DEFAULT ROLLE ALL EXCEPT Payroll


    参考答案：D

  • 第14题：

    在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？（）

    • A、ALTER USER scott DEFAULT TABLESPACE data2_ts
    • B、ALTER DEFAULT TABLESPACE data2_ts USER scott
    • C、ALTER USER scott TABLESPACE DEFAULT data2_ts
    • D、ALTER scott USER DEFAULT TABLESPACE data2_ts

    正确答案:A

  • 第15题：

    An administrator received a call from a user whose PC crashed while using vi to edit a file. The user wants the edited file back. Where should the administrator look for the file（）

    • A、/tmp
    • B、/var/preserve
    • C、/var/tmp/$USER
    • D、$HOME/.vi

    正确答案:B

  • 第16题：

    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

  • 第17题：

    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

    • A、 The batch operation started by the user， SCOTT， terminates with an error.
    • B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
    • C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
    • D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
    • E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

    正确答案:A,D

  • 第18题：

    单选题
    The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?（）
    A

    no privileges

    B

    only the SELECT privilege

    C

    only the CONNECT privilege

    D

    all the privileges of a default user


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

  • 第19题：

    多选题
    You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）
    A

    All the objects of scott are moved to the Recycle Bin.

    B

    Any objects in the Recycle Bin belonging to scott are purged.

    C

    All the objects owned by scott are permanently dropped from the database.

    D

    All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

    E

    Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


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

  • 第20题：

    多选题
    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
    A

    The batch operation started by the user， SCOTT， terminates with an error.

    B

    The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.

    C

    The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.

    D

    The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.

    E

    The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第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


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

相关内容