多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题