单选题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 =

题目

单选题

Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1

1, 2, 3, 3

1, 2, 2, 4

1, 2, 3, 3, 6

1, 2, 2, 5, 6

参考答案和解析

正确答案： D

解析：暂无解析

更多“单选题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = ”相关问题

第1题

Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）A、UPDATE stock SET (status = NULL; quantity, price = 0) WHERE item LIKE S%B、UPDATE stock SET (status, quantity, price) = (NULL, 0, 0) WHERE item LIKE S%C、UPDATE stock SET status = NULL, SET quantity = 0, SET price = 0 WHERE item LIKE 'S%'D、UPDATE stock SET (status = NULL), (quantity = 0), (price = 0) WHERE item LIKE S%

点击查看答案
第2题

两电阻相并联，已知R1/R2=1/2，则流入电阻的电流之比I1/I2、功率之比P1/P2分别是（）。A、I1/I2=2，P1/P2=2B、I1/I2=2，P1/P2=4C、I1/I2=1/2，P1/P2=1/2D、I1/I2=2，P1/P2=1/4

点击查看答案
第3题

两个电阻R1、R2串联在电路中，则有（）。A、I1＞I2B、I1＜I2C、I1＝I2D、I1≠I2

点击查看答案
第4题

已知两个正弦量分别为i1=-4cos（100t+60°）A，i2=4cos（100t+30°）A，则i1和i2的相位差为（）。A、i1超前i230°B、i1滞后i230°C、i1超前i2150°D、i1滞后i2150°

点击查看答案
第5题

电流互感器的角误差，可用下式表示：Δfi%＝（）。其中K为电流互感器的额定变比，I1为一次绕组中的电流；I2为二次绕组中的电流。A、［（KI2～I1）／I1］100%；B、（I2～I1）100%／I1；C、I2～I1；D、I2／I1。

点击查看答案
第6题

Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（） A、The database manager will rollback the transaction in both applications.B、The database manager will rollback the transaction in one of the two applications.C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

点击查看答案
第7题

Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = 5 WHERE i1 = 3; SAVEPOINT s2 ON ROLLBACK RETAIN CURSORS;INSERT INTO t1 (i1) VALUES (6); ROLLBACK TO SAVEPOINT s1; UPDATE t1 SET i1 = 2 WHERE i1 = 4; COMMIT; What is the expected sequence of values returned from?（） SELECT i1 FROM t1 ORDER BY i1A、1, 2, 3, 3B、1, 2, 2, 4C、1, 2, 3, 3, 6D、1, 2, 2, 5, 6

点击查看答案

IBM(000-730)

单选题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 =

题目

参考答案和解析

更多“单选题Given table T1 has column I1 containing the following data: I1 1 2 3 4 If the following sequence of SQL statements is applied within a single unit of work: UPDATE t1 SET i1 = 3 WHERE i1 = 2; S AVEPOINT s1 ON ROLLBACK RETAIN CURSORS; UPDATE t1 SET i1 = ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容