单选题Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）AIt performs a merge join of the row from T2 only if it doesn’t exist in the T1 table. BIt creates a natural join of tables T1 and T2 for all columns that have the same name. CIt creates a Cartesian product of table T1 and table T2 for all columns that have the same name. DFor each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
下面不属于同一函数模板的是()。A.template t1 max(t1 a,t1 b) {…}template 下面不属于同一函数模板的是( )。A．template＜class t1＞ t1 max(t1 a,t1 b) {…}template＜class t2＞ t2 max(t2 a,t2 b) {…}B．template＜class t1＞t1 max(t1 a,t1 b){…}template＜class t2＞t2 max(t2 a,t2 b){…}C．template＜class t1＞ t1 max(t1 * a,t1 * b) {…} template＜class t2＞ t2 max(t2 a,t2 b) {…}D．template＜class t1＞t1 max(t1 a,t1 b){…}template＜class t2＞t2 max(t2 a,t2 b,t2 c){…}
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)
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
在下列模板说明中，正确的是（）A、template〈typename T1，T2〉B、template〈class T1，T2〉C、template〈typename T1，typename T2〉D、template（typedef T1，typedef T2）
下面哪个调度是串行调度（）。A、T1：RA.，T2：RB.，T2：WB.，T1：WA.B、B.T1：RB.，T1：WB.，T2：R，T2：WA.C、C.T1：R，T2：RB.，.T1：WA.，T2：WB.D、D.T2：R，T1：RB.，.T1：WA.，T2：WB.
存在两个结构相同的数据库表T1（col1，col2，col3）、T2（col1，col2，col3），写出一SQL语句将所有T1数据导入到T2表（）A、select col1，col2，col3 from T1 into T2（col1，col2，col3）B、insert T1 （col1，col，col3） into T2（col1，col2，col3）C、insert into T2 （col1，col2，col3） as select col1，col2，col3 from T1D、insert into T2（col1，col2，col3） select col1，col2，col3 from T1；
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
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.
单选题下面哪个调度是串行调度（）。AT1：RA.，T2：RB.，T2：WB.，T1：WA.BB.T1：RB.，T1：WB.，T2：R，T2：WA.CC.T1：R，T2：RB.，.T1：WA.，T2：WB.DD.T2：R，T1：RB.，.T1：WA.，T2：WB.
单选题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?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
单选题在下列模板说明中，正确的是（）Atemplate〈typename T1，T2〉Btemplate〈class T1，T2〉Ctemplate〈typename T1，typename T2〉Dtemplate（typedef T1，typedef T2）
单选题存在两个结构相同的数据库表T1（col1，col2，col3）、T2（col1，col2，col3），写出一SQL语句将所有T1数据导入到T2表（）Aselect col1，col2，col3 from T1 into T2（col1，col2，col3）Binsert T1 （col1，col，col3） into T2（col1，col2，col3）Cinsert into T2 （col1，col2，col3） as select col1，col2，col3 from T1Dinsert into T2（col1，col2，col3） select col1，col2，col3 from T1；
单选题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?（）ASELECT * FROM T1 MINUS SELECT * FROM T2BSELECT * FROM T1 EXCEPT SELECT * FROM T2CSELECT * FROM T2 UNION EXCEPT SELECT * FROM T1DSELECT * FROM T1 NOT EXISTS SELECT * FROM T2
单选题有如下模板声明：template class A；下列声明中，与上述声明不等价的是（ ）。Atemplateclass T1，class T2 class A；Btemplateclass T1，typename T2 class A；Ctemplatetypename T1，class T2 class A；Dtemplatetypename T1，T2 class A；
单选题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?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)