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

题目
单选题
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.

相似考题

1.View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）A. The second user‘s session immediately produces the resource busy error.B. The second user‘s command executes successfully.C. The second user‘s session waits for a time period before producing the resource busy error.D. A deadlock is created.

2. All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）A、all sessions of the HR user onlyB、all sessions of the HR user and the SYS userC、the session of the HR user that executed the commandsD、all the sessions for which the database users have access privilege to the PERSONS table

3. All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）A、All sessions of the HR user onlyB、All sessions of the HR user and the SYS userC、The session of the HR user that executed the commandsD、All the sessions for which the database users have access privilege to the PERSONS table

4. To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A、It contains only the plan for the SQL statement executed by the user.B、It contains the SQL text executed by the user and the bind variables used with it.C、It contains the plan and statistics associated with the SQL statement executed by the user.D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

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

  • 第1题：

    One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

    • A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
    • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
    • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
    • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
    • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

    正确答案:C

  • 第2题：

    The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；  Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）

    • A、because of redo data from redo log file
    • B、because of data from database buffer cache
    • C、because of data from a temporary tablespace
    • D、because of undo data from the undo tablespace

    正确答案:D

  • 第3题：

    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.

    正确答案:C

  • 第4题：

    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

  • 第5题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）

    • A、LOCK TABLE emp IN SHARE MODE;
    • B、LOCK TABLE emp IN EXCLUSIVE MODE;
    • C、DELETE FROM emp WHERE job=’MANAGER’;
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
    • E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

    正确答案:A,B,E

  • 第6题：

    单选题
    View the Exhibit and examine the parameters. 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 onthe TRANS table：  SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；  What would happen in this scenario（）
    A

    The ALTER TABLE command modifies the column successfully.

    B

    The DDL operation gets higher priority and transaction for user a is rolled back.

    C

    The ALTER TABLE command waits indefinitely until user a ends the transaction.

    D

    The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.


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

  • 第7题：

    单选题
    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


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

  • 第8题：

    单选题
    One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）
    A

    execute the command， ALTER SESSION KILL ..， to kill the blocking session

    B

    execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session

    C

    execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session

    D

    execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session

    E

    execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session


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

  • 第9题：

    单选题
    The user SCOTT executes the following command successfully to increase the salary values in one of his sessions：  SQL> UPDATE emp SET sal=sal*1.15 WHERE deptno=20；  Before SCOTT ends the transaction， user HR who has the privileges on EMP table executes a query to fetch the salary details but finds the old salary values instead of the increased values. Why does HR still see the old data？（）
    A

    because of redo data from redo log file

    B

    because of data from database buffer cache

    C

    because of data from a temporary tablespace

    D

    because of undo data from the undo tablespace


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

  • 第10题：

    单选题
    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.


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

  • 第11题：

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）
    A

    LOCK TABLE emp IN SHARE MODE；

    B

    LOCK TABLE emp IN EXCLUSIVE MODE；

    C

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

    D

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

    E

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


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

  • 第12题：

    单选题
    To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it


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

  • 第13题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）

    • A、LOCK TABLE emp IN SHARE MODE；
    • B、LOCK TABLE emp IN EXCLUSIVE MODE；
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=MANAGER；
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；

    正确答案:A,B,E

  • 第14题：

    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）

    • A、LOCK TABLE emp IN SHARE MODE；
    • B、LOCK TABLE emp IN EXCLUSIVE MODE；
    • C、UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
    • D、INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
    • E、SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

    正确答案:A,B,E

  • 第15题：

    User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）

    • A、It fails to delete the records because the records are locked in SHARE mode.
    • B、It deletes the rows successfully because the table is locked in SHARE mode
    • C、It fails to delete the records because the table is locked in EXCLUSIVE mode.
    • D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

    正确答案:C

  • 第16题：

    User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

    • A、UPDATE pets…
    • B、SELECT….FROM pets
    • C、INSERT INTO pets…
    • D、ALTER TABLE pets…

    正确答案:B

  • 第17题：

    单选题
    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
    A

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

    B

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

    C

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

    D

    One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

    E

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.


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

  • 第18题：

    单选题
    View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT orROLLBACK 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 ALTER TABLE command modifies the column successfully.

    B

    The DDL operation gets higher priority and transaction for user A is rolled back.

    C

    The ALTER TABLE command waits indefinitely until user A ends the transaction.

    D

    The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy


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

  • 第19题：

    单选题
    All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions： SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.  SQL> DELETE FROM persons WHERE exp=’Y’； 3 rows deleted.  The SYS user opens a new session after HR executed the above commands.  Which sessions can seethe effect of the UPDATE and DELETE commands （）
    A

    all sessions of the HR user only

    B

    all sessions of the HR user and the SYS user

    C

    the session of the HR user that executed the commands

    D

    all the sessions for which the database users have access privilege to the PERSONS table


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

  • 第20题：

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

  • 第21题：

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
    A

    LOCK TABLE emp IN SHARE MODE;

    B

    LOCK TABLE emp IN EXCLUSIVE MODE;

    C

    DELETE FROM emp WHERE job=’MANAGER’;

    D

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

    E

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


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

  • 第22题：

    多选题
    User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp  2 WHERE job=’CLERK’ FOR UPDATE OF empno；  SCOTT has opened another session to work with the database instance.  Which three operations wouldwait when issued in SCOTT’s second session（）
    A

    LOCK TABLE emp IN SHARE MODE；

    B

    LOCK TABLE emp IN EXCLUSIVE MODE；

    C

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

    D

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

    E

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


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

  • 第23题：

    单选题
    User A executes the following command to drop a large table in your database： SQL> DROP TABLE trans；  While the drop table operation is in progress， user B executes the following command on the same table： SQL> DELETE FROM trans WHERE tr_type=’SL’；  Which statement is true regarding the DELETE command（）
    A

    It fails with a Resource Busy error.

    B

    It deletes the rows successfully because the table is locked in SHARE mode.

    C

    It fails to delete the records because the table is locked in EXCLUSIVE mode.

    D

    It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.


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

  • 第24题：

    单选题
    To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it.


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

相关内容