搜题

【单选题】

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

查看正确答案

更多“ 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题

[] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（） Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 5 4 5 2 5 5 Table T2: C1 C2 5 1 5 2 5 3 Which of the following queries will return only those rows that exist in T1 and not in T2?（）

A、A.SELECT * FROM T1 MINUS SELECT * FROM T2 B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2 C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1 D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2

点击查看答案

第2题

[单选题] Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）

A、SELECT * FROM t1 UNION SELECT * FROM t2 B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2 C、SELECT * FROM t1 INTERSECT SELECT * FROM t2 D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

点击查看答案

第3题

[] 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、A.REVOKE DROP ON t1 FROM PUBLIC B、B.REVOKE UPDATE ON t1 FROM PUBLIC C、C.REVOKE DELETE ON t1 FROM PUBLIC D、D.REVOKE CONTROL ON t1 FROM PUBLIC

点击查看答案

第4题

[单选题] A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A、REFERENCES B、SELECT C、UPDATE D、ALTER

点击查看答案

第5题

[多选题] In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;

A、$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql B、Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql' C、$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql D、Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1 E、$ mysqlinport – u root – p – h localhost test /tmp/t1.sql

点击查看答案

第6题

[单选题] ROW-based replication has stopped working. You investigate the error log file and find the following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log 56_master-bin. 000003, end_log_pos 851, Error_code: 1032 2013-08-27 14:15:47 9056 [warning] Slave: Can't find record in 't1' Error_code: 1032 2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log '56_masterbin. 000003' position 684 Why did you receive this error?（）

A、The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s B、The table definition on the slave -litters from the master C、Multi-threaded replication slaves can have temporary errors occurring for cross database updates D、The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

点击查看答案

第7题

[单选题] ETA/pilot reverting means（）.

A、ETA pilot station has been given B、ETA pilot station will be given afterwards C、ETA pilot station was not given D、ETA pilot station is given

点击查看答案

第8题

[多选题] In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）

A、if a table is not in a cluster B、if a table has an active trigger C、if a table has an encrypted D、if a table has a column of data type LONG defined on it E、if a table has a referential integrity constraint defined on it

点击查看答案

第9题

[] ETA／PILOT REVERTING means （）．

A、A.ETA pilot station has been given B、B.ETA pilot station will be given afterwards C、C.ETA pilot station was not given D、D.ETA pilot station is given

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服