[单选]
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.

You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（） Only the Flashback Table。 Both the Flashback Transaction Query and the Flashback Version Query。 Only the Flashback Drop。 Only the Flashback Versio。基站固定式油机试机运行时间不得低于（） 5分钟。 15分钟。 10分钟。 20分钟。捕捞权的取得方式有哪两种？当验明设备确无电压后（）将检修设备接地并三相短路。过一段时间。应立即。可不。 Given: Which statement is true about the class of an object that can reference the variable base? （） It can be any class.。 No class has access to base.。 The class must belong to the geometry package.。 The class must be a subclass of the class Hypotenuse.。

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

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-042题库

相关题目: