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

更多“Given table T1 has column I1 co”相关问题

第1题

What type of constraint can be used to ensure that, in any given row in a table, the value of one column never exceeds the value of another column?()A.CheckB.RangeC.ReferentialD.Informational

点击查看答案
第2题

利用SQL命令删除“学生”表中的“年龄”字段，正确的命令格式是（）。A)ALTER TABLE 学生 DELETE COLUMN 年龄B)ALTER TABLE 学生 DROP COLUMN 年龄C)ALTER TABLE 学生 CANCEL COLUMN 年龄D)ALTER TABLE 学生 CUT COLUMN 年龄

点击查看答案
第3题

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 clusterB、if a table has an active triggerC、if a table has an encryptedD、if a table has a column of data type LONG defined on itE、if a table has a referential integrity constraint defined on it

点击查看答案
第4题

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）A、ALTER TABLE commercials MODIFY (description CHAR2(1000));B、ALTER TABLE commercials CHANGE (description CHAR2(1000));C、ALTER TABLE commercials CHANGE (description VARCHAR2(1000));D、ALTER TABLE commercials MODIFY (description VARCHAR2(1000));E、You cannot increase the size of a column if the table has rows.

点击查看答案
第5题

What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A、A check constraint on the EMPLOYEE tableB、A unique constraint on the EMPLOYEE table WORKDEPT columnC、A foreign key reference from the DEPARTMENT tables DEPTNO column to the WORKDEPT column of the EMPLOYEE tableD、A foreign key reference from the EMPLOYEE tables WORKDEPT column to the DEPTNO column of the DEPARTMENT table

点击查看答案
第6题

Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A、Define the column MAINID as NOT UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX

点击查看答案
第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

点击查看答案

Given table T1 has column I1 co

题目

更多“Given table T1 has column I1 co”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容