欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > Oracle认证考试 > 1Z0-032

单项选择题

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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题