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

题目

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

A、1, 2, 3, 3
B、1, 2, 2, 4
C、1, 2, 3, 3, 6
D、1, 2, 2, 5, 6

相似考题

1.已知r1,r2是实型变量,i1,i2是整型变量,下列中错误的赋值语句是( )。Ai2:=i1*i2 div i1Bi1:=i1/i2Cr2:=3/5*sqr(r1*r2)Dr1:=r2/i1

2.有以下程序:include define f(x) (x * x)main ( ){ int i1 ,i2;i1 = f(8)／f(4) ;i2有以下程序:#include ＜stdio, h＞#define f(x) (x * x)main ( ){ int i1 ,i2; i1 = f(8)/f(4) ;i2 =f(4 +4)/f(2 +2); printf("% d,% d\n" ,i1 ,i2);A．64,28B．4,4C．4,3D．64,64

3.有以下程序： # define f(x) (x*x) main() { int i1, i2; i1=f(8)/f(4); i2=f(4+4)/f(2+2); printf("% d, % d\n", i1, i2); } 程序运行后的输出结果是______。A．64, 28B．4, 4C．4, 3D．64, 64

4.下面程序的运行结果是【17】。#define N 10#define s（x）x*x#define f（x）（x*x）main（）{ int i1,i2;i1=1000/s（N）; i2=1000/f（N）;printf（"%d %d＼n",i1,i2）;}

更多“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 W”相关问题

第1题：

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?()

A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC

参考答案：C
第2题：

他励直流电动机拖动恒转矩负载进行串联电阻调速，设调速前、后的电枢电流分别为I1和I2，那么（　　）。

A． I1＜I2
B． I1＝I2
C． I1＞I2
D． I1＝－I2

答案：B
解析：
由于拖动恒转矩负载，故电磁转矩Tem不变。电磁转矩公式为：Tem＝CTΦIa。式中，CT为转矩常数；Φ为每极主磁通均为定值。因此，电枢电流Ia不变。
第3题：

假设有证书发放机构I1，I2，用户A在I1获取证书，用户B在I2获取证书，I1和I2已交换了各自的公钥。如果用I1《A》表示由I1颁发给A的证书，A可通过（）证书链接获取B的公开密钥。

A.I1《I2》I2《B》
B.I2《B》I1《I2》
C.I1《B》I2《I2》
D.I2《I1》I2《B》

答案：A
解析：
证书规定有一个统一的第三方CA，即要求交换各自的公钥，而获取双方公钥的过程可理解为证书的验证过程，即双方证书是否有效，签名是否可靠，在证书A机构验证提取自己的信息，到证书B机构验证获取对方的信息。验证证书的可靠性是在当地发证机构进行，因此A的有效性需要在I1验证，并从I2机构获取B的信息，由于已经给出了I1颁发给A的证书为I2《A》，同时验证需要在I1机构进行，即I1《I2》，这里的I2不是指机构，而是证书I2《A》，《A》为A的公钥等信息，主要是证明A的身份可靠性。而获取B的信息需需要在I2机构验证进行，因此为I2《B》，《B》为B用户的公钥等信息。
第4题：

两电阻相并联，已知R₁/R₂=1/2，则流入电阻的电流之比I1/I2、功率之比P1/P2分别是（）。
- A、I1/I2=2，P1/P2=2
- B、I1/I2=2，P1/P2=4
- C、I1/I2=1/2，P1/P2=1/2
- D、I1/I2=2，P1/P2=1/4
正确答案:A
第5题：

用一变压器向一负载供电，当增大负载（负载阻值减小）时原绕组中电流I1和二次绕组中电流I2的变化情况为（）。
- A、I2增大，I1也增大
- B、I2增大，I1减小
- C、I2减小，I1也减小
- D、I2减小，I1增大
正确答案:A
第6题：

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

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）
- A、REVOKE DROP ON t1 FROM PUBLIC
- B、REVOKE UPDATE ON t1 FROM PUBLIC
- C、REVOKE DELETE ON t1 FROM PUBLIC
- D、REVOKE CONTROL ON t1 FROM PUBLIC
正确答案:C
第8题：

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

变压器的初、次级电流I₁、I₂和初、次级U₁、U₂之间的关系为（）。
- A、I₁/I₂＝U₁/U₂
- B、I₁/I₁＝U₂/U₁
- C、I₁/I₂＝U₂₂/U₁₂
- D、无明显规律
正确答案:B
第10题：

单选题
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
A
1, 2, 3, 3
B
1, 2, 2, 4
C
1, 2, 3, 3, 6
D
1, 2, 2, 5, 6

正确答案： A
解析：暂无解析
第11题：

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

正确答案： B,C
解析：暂无解析
第12题：

单选题
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
A
1, 2, 3, 3
B
1, 2, 2, 4
C
1, 2, 3, 3, 6
D
1, 2, 2, 5, 6

正确答案： D
解析：暂无解析
第13题：

The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;（）
A.4
B.3
C.1
D.0

参考答案：D
第14题：

某笔贷款按月、季、半年计息的利息总额分别为I1、I2、I3，下列关系中正确的是（　）。

A、I3＞I2＞I1
B、I2＞I3＞I1
C、I1＞I3＞I2
D、I1＞I2＞I3

答案：D
解析：
本题考查的是名义利率与实际利率。名义利率越大，计息周期越短，名义利率与实际利率的差异就越大。
第15题：

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%
正确答案:B
第16题：

两个电阻R1、R2串联在电路中，则有（）。
- A、I1＞I2
- B、I1＜I2
- C、I1＝I2
- D、I1≠I2
正确答案:C
第17题：

已知两个正弦量分别为i₁=-4cos（100t+60°）A，i₂=4cos（100t+30°）A，则i₁和i₂的相位差为（）。
- A、i₁超前i₂30°
- B、i₁滞后i₂30°
- C、i₁超前i₂150°
- D、i₁滞后i₂150°
正确答案:D
第18题：

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.
正确答案:B
第19题：

View the following SQL statements： Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT； Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT； Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5； You want to back out transaction T2. Which option would you use？（）
- A、 It is possible，but transaction T3 also backs out.
- B、 It is possible with the NOCASCADE_FORCE option.
- C、 It is possible with the NONCONFLICT_ONLY option.
- D、 It is not possible because it has conflicts with transaction T3.
正确答案:B
第20题：

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

浓度为1mol·kg^-1的CuSO₄浓度的离子强度I₁，浓度为1mol·kg^-1的NaCl浓度的离子强度I₂，那么I₁与I₂的关系为（）
- A、I₁=（1/2）I₂
- B、I₁=I₂
- C、I₁=4I₂
- D、I₁=2I₂
正确答案:C
第22题：

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

正确答案： D
解析：暂无解析
第23题：

多选题
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,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 = 5

题目

相似考题

更多“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 W”相关问题

相关内容