Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）

A、USER_CONSTRAINTS

B、USER_OBJECTS

C、ALL_CONSTRAINTS

D、USER_CONS_COLUMNS

E、USER_COLUMNS

软件设计中模块划分应遵循的准则是（　　）。

A、低耦合低内聚

B、高耦合高内聚

C、低耦合高内聚

D、内聚与耦合无关

Windows系统中的磁盘碎片整理程序__（1）__，这样使系统__（2）__。空白（1）处应选择（）

A、仅将卷上的可用空间合并，使其成为连续的区域

B、只能使每个文件占用卷上连续的磁盘空间，合并卷上的可用空间

C、只能使每个文件夹占用卷上连续的磁盘空间，合并卷上的可用空间

D、使每个文件和文件夹占用卷上连续的磁盘空间，合并卷上的可用空间

线缆接头、接地卡做防水抱扎，要按顺序紧密缠绕绝缘胶带和防水胶带（采用3X3处理，即3层绝缘+3层防水+3层绝缘），馈线抱扎后擦启用扎带将抱扎处固定后涂上硅胶。（）

A、对

B、错

The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）

SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;

The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.  Which two statements are true regarding the session ofSCOTT 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.