网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
单选题
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

SELECT * FROM T1 MINUS SELECT * FROM T2

B

SELECT * FROM T1 EXCEPT SELECT * FROM T2

C

SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1

D

SELECT * FROM T1 NOT EXISTS SELECT * FROM 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 SELECT * FROM T1 MINUS SELECT * FROM T2B SELECT * FROM T1 EXCEPT SELECT * FROM T2C SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D SELECT * FROM T1 NOT EXISTS SELECT * FROM T2” 相关考题
考题 Note the following statements that use flashback technology:1. FLASHBACK TABLE table TO SCN scn;2. SELECT * FROM table AS OF SCN 123456;3. FLASHBACK TABLE table TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP timestamp;5. SELECT * FROM table VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）A. 1, 2, and 5B. 1, 3, and 4C. 2, 3, 4, and 5D. 1, 2, 3, 4, and 5
查看答案
考题 Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?() A.SELECT * FROM t1 UNION SELECT * FROM t2B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C.SELECT * FROM t1 INTERSECT SELECT * FROM t2D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?() A.SELECT * FROM t1 UNION SELECT * FROM t2B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C.SELECT * FROM t1 INTERSECT SELECT * FROM t2D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 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 PUBLICB.REVOKE UPDATE ON t1 FROM PUBLICC.REVOKE DELETE ON t1 FROM PUBLICD.REVOKE CONTROL ON t1 FROM PUBLIC
查看答案
考题 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.4B.3C.1D.0
查看答案
考题 Given that tables T1 and T2 contain the following rows: Table T1:C1 C25 4 5 2 5 5Table T2: C1 C2 5 1 5 2 5 3Which of the following queries will return only those rows that exist in T1 and not in T2?() A.SELECT * FROM T1 MINUS SELECT * FROM T2B.SELECT * FROM T1 EXCEPT SELECT * FROM T2C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
查看答案
考题 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 t2B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C、SELECT * FROM t1 INTERSECT SELECT * FROM t2D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 已知表T1中有2行数据，T2中有3行数据，执行SQL语句“select a.* from T1 a，T2 b”后，返回的行数为（）A、2B、3C、5D、6
查看答案
考题 臂丛神经的组成是（）A、C1~5脊神经B、C5～T1脊神经C、C5～T1脊神经前根D、C4～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、SELECT * FROM T1 MINUS SELECT * FROM T2B、SELECT * FROM T1 EXCEPT SELECT * FROM T2C、SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D、SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
查看答案
考题 Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）A、SELECT * FROM t1 UNION SELECT * FROM t2B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C、SELECT * FROM t1 INTERSECT SELECT * FROM t2D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 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
查看答案
考题 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 PUBLICB、REVOKE UPDATE ON t1 FROM PUBLICC、REVOKE DELETE ON t1 FROM PUBLICD、REVOKE CONTROL ON t1 FROM PUBLIC
查看答案
考题 Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）A、INSERT INTO tab1 SELECT cx, cy FROM tab2B、INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)C、INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)D、INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
查看答案
考题 Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）A、It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. B、It creates a natural join of tables T1 and T2 for all columns that have the same name. C、It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. D、For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
查看答案
考题 单选题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）A INSERT INTO tab1 SELECT cx, cy FROM tab2B INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)C INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)D INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
查看答案
考题 单选题Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM AS OF SCN 123456; 3. FLASHBACK TABLE TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）A 1, 2, and 5B 1, 3, and 4C 2, 3, 4, and 5D 1, 2, 3, 4, and 5
查看答案
考题 单选题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 t2B SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C SELECT * FROM t1 INTERSECT SELECT * FROM t2D SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 单选题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
查看答案
考题 单选题已知表T1中有2行数据，T2中有3行数据，执行SQL语句“select a.* from T1 a，T2 b”后，返回的行数为（）A 2B 3C 5D 6
查看答案
考题 单选题Consider this syntax：   MERGE INTO t1  USING t2 ON （join predicate）…..   What does the MERGE syntax do？（）A It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. B It creates a natural join of tables T1 and T2 for all columns that have the same name. C It creates a Cartesian product of table T1 and table T2 for all columns that have the same name. D For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
查看答案
考题 单选题Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）A SELECT * FROM t1 UNION SELECT * FROM t2B SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C SELECT * FROM t1 INTERSECT SELECT * FROM t2D SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
考题 单选题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）A INSERT INTO tab1 SELECT cx, cy FROM tab2B INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)C INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)D INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
查看答案
考题 单选题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 SELECT * FROM T1 MINUS SELECT * FROM T2B SELECT * FROM T1 EXCEPT SELECT * FROM T2C SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
查看答案
考题 单选题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
查看答案
考题 单选题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 PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DELETE ON t1 FROM PUBLICD REVOKE CONTROL ON t1 FROM PUBLIC
查看答案
考题 单选题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 SELECT * FROM T1 MINUS SELECT * FROM T2B SELECT * FROM T1 EXCEPT SELECT * FROM T2C SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1D SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
查看答案
考题 单选题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 t2B SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2C SELECT * FROM t1 INTERSECT SELECT * FROM t2D SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
查看答案
热门标签
最新试卷