多选题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 tra

题目

多选题

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（）

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.

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

相似问题和答案

第1题：

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.

正确答案:B,D

第2题：

You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）

A、The database instance is not available.
B、The ALTER TABLE command does not have WAIT option
C、The table or a row in the table is currently locked by another user session.
D、The database instance is busy processing other user sessions commands.
E、The CUSTOMERS table has no long running query active at the time when this request is made.
F、The server process executing the ALTER TABLE command is busy with another command execution

正确答案:C

第3题：

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

第4题：

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

第5题：

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）

A、Grant the RESOURCE role to SCOTT.
B、Add data files to the USERS tablespace.
C、Grant the CREATE ANY TABLE privilege to SCOTT.
D、Increase the space for SCOTT on the USERS tablespace.
E、Increase the size of the data file associated with the USERS tablespace

正确答案:B,E

第6题：

You execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command？（）

A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

正确答案:A

第7题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）

A、The tablespace TBS1 is full.
B、The user is not the owner of the SYSTEM tablespace.
C、The user does not have quota on the TBS1 tablespace.
D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
E、The user does not have sufficient privileges to create table on the default permanent tablespace.

正确答案:C

第8题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

正确答案:C

第9题：

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work. ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

A、Modify the profile assigned to the user.
B、Modify the roles assigned to the users.
C、Modify the object privileges assigned to the user.
D、Modify the system privileges assigned to the users.
E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

正确答案:A

第10题：

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

A、Add a data file to the SMD tablespace.
B、Add a data file to the temporary tablespace associated with the user HR.
C、Resize the data file associated with the SMD tablespace to make it larger.
D、Alter the data file associated with the SMD tablespace to grow automatically.
E、Change the segment space management for the SMD tablespace to automatic

正确答案:A,C,D

多选题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 tra

题目

相似问题和答案

更多相关问题

相关内容