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

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


参考解析

解析: 暂无解析

相关考题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?() A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.

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.

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.

Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?()A、Task CenterB、Command EditorC、Developer WorkbenchD、Command Line Processor

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

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

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;

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 fileB、because of data from database buffer cacheC、because of data from a temporary tablespaceD、because of undo data from the undo tablespace

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

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.

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 modeC、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.

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.

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 petsC、INSERT INTO pets…D、ALTER TABLE pets…

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.

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;

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

单选题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()AAll sessions of the HR user onlyBAll sessions of the HR user and the SYS userCThe session of the HR user that executed the commandsDAll the sessions for which the database users have access privilege to the PERSONS table

单选题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 ()Aall sessions of the HR user onlyBall sessions of the HR user and the SYS userCthe session of the HR user that executed the commandsDall the sessions for which the database users have access privilege to the PERSONS table

单选题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()AThe command fails because SCOTT still has privileges.BThe command succeeds and privileges are revoked from JIM.CThe command fails because HR cannot revoke the privileges from JIM.DThe command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATEoperations on the EMP table.

单选题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?()Abecause of redo data from redo log fileBbecause of data from database buffer cacheCbecause of data from a temporary tablespaceDbecause of undo data from the undo tablespace

多选题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?()ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CDELETE FROM emp WHERE job=’MANAGER’;DINSERT INTO emp(empno,ename) VALUES (1289,’Dick’);ESELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

单选题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?()AThe transaction for user A is rolled back.BThe ALTER TABLE command modifies the column successfully.CThe ALTER TABLE command fails due to the resource being busy.DThe ALTER TABLE command waits until user A ends the transaction.

多选题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()ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CUPDATE emp SET sal=sal*1.2 WHERE job=MANAGER;DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;

多选题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()ALOCK TABLE emp IN SHARE MODE;BLOCK TABLE emp IN EXCLUSIVE MODE;CUPDATE emp SET sal=sal*1.2 WHERE job=ANAGER?UPDATE emp SET sal=sal*1.2 WHERE job=?ANAGER?DINSERT INTO emp(empno,ename) VALUES (1289,’Harry’);ESELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno

单选题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()AIt fails with a Resource Busy error.BIt deletes the rows successfully because the table is locked in SHARE mode.CIt fails to delete the records because the table is locked in EXCLUSIVE mode.DIt deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

单选题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()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it

单选题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()AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.