多选题In which two conditions are resumable statements suspended？（）Awhen a user exceeds the space quotaBwhen a user session is terminatedCwhen a table that is being accessed by the current transaction is not foundDwhen a user manually suspends the statementE

第1题：

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）

• A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
• B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
• C、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
• D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

第2题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

• A、REVOKE ALL PRIVILEGES FROM USER tom
• B、REVOKE ALL ON EMPLOYEE FROM USER tom
• C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
• D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

第3题：

Which of the following describes how a distributed resumable transaction behaves？（）  

• A、 The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
• B、 The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
• C、 The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts  of the transaction.
• D、 None of the above.

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

第5题：

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUTparameter set to a nonzero value.Which three statements about resumable space allocation are true? （）(Choose three.)

• A、Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
• B、A resumable statement is suspended only if an out of space error occurs.
• C、When a resumable statement is suspended, the transaction that contains the statement is also suspended.
• D、A resumable statement can only be suspended and resumed once during the execution of the statement.
• E、You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session

第6题：

User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）

• A、The transaction for user A is rolled back.
• B、The ALTER TABLE command modifies the column successfully.
• C、The ALTER TABLE command fails due to the resource being busy.
• D、The ALTER TABLE command waits until user A ends the transaction.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）

• A、REVOKE SELECT FROM user2 ON TABLE org.tab1
• B、REVOKE SELECT ON TABLE org.tab1 FROM user2
• C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
• D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

第14题：

You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60; What is the impact of a timeout on the statements being suspended？（）

• A、The statements remain suspended for at least 60 seconds.
• B、The statements are suspended for 60 seconds and then they are executed.
• C、The suspended statements error out if the problem is not rectified within 60 seconds.
• D、The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.

第15题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in

第16题：

You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements about resumable space allocation are true? （）

• A、Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
• B、A resumable statement is suspended only if an out of space error occurs. （Out of space condition Maximum extents reached condition，Space quota exceeded condition）
• C、When a resumable statement is suspended, the transaction that contains the statement is also suspended.
• D、A resumable statement can only be suspended and resumed once during the execution of the statement.
• E、You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

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

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：