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？（）A、null lock on the row being updatedB、null lock on the table contain

no privileges

only the SELECT privilege

only the CONNECT privilege

all the privileges of a default user

when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago

when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago

when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago

when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes

never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

Data is never redacted for the EMP_V.SAL column.

Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

 by using the DBMS_SESSION package

 by granting the DBA role

 by using the DBMS_RESOURCE_MANAGER package

 by using the DBMS_RESOURCE_MANAGER_PRIVS package

The session is terminated after receiving the error and JIM can continue with his transaction.

SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.

The session is rolled back after receiving the error and JIM can continue with his transaction.

SCOTT has to reexecute the last command in the transaction after he commits the transaction.

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

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

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

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

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

LOCK TABLE emp IN SHARE MODE;

LOCK TABLE emp IN EXCLUSIVE MODE;

DELETE FROM emp WHERE job=’MANAGER’;

INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;

SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

LOCK TABLE emp IN SHARE MODE；

LOCK TABLE emp IN EXCLUSIVE MODE；

UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；

INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；

SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

 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.

 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.

 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.

 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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

The command fails because SCOTT still has privileges.

The command succeeds and privileges are revoked from JIM.

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

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

because of redo data from redo log file

because of data from database buffer cache

because of data from a temporary tablespace

because of undo data from the undo tablespace

LOCK TABLE emp IN SHARE MODE；

LOCK TABLE emp IN EXCLUSIVE MODE；

UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？

INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；

SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno