违法和不良信息举报 联系客服
免费注册 登录

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

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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

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


参考答案：C

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

第3题：

（ 35 ） “ 把查询 sc 表和更新 sc 表的 grade 列的权限授予用户 user1 ” 的正确 SQL 语句是

A ） GRANT SELECT ， UPDATE （ grade ） ON TABLE sc TO user1

B ） GRANT SELECT sc ， UPDATE sc . grade TO user1

C ） GRANT SELECT ， UPDATE ON TABLE sc . grade TO user1

D ） GRANT SELECT ON TABLE sc ， UPDATE ON TABLE sc(grade) TO user1


正确答案：A

第4题：

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

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

第6题：

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

第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题：

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 creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案：B, C

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

正确答案:C

更多相关问题
相关内容