试题详情
- 单项选择题 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
关注下方微信公众号,在线模考后查看
热门试题
- What does̳
- 在Oracle中,()数据字典表可以用来
- Which two̳
- Which is not a valid
- Using Oracle
- Your database&
- DRAGDROPClicktheTask
- Which of the followi
- You plan
- Which view should a
- Which two are attrib
- 在设置撤消表空间的自动管理功能时,DBA
- You issued&ensp
- Given: Whichfourcode
- Identify three
- Which statement is t
- Which three statemen
- You have
- Given: Whatistheres
- Which three elements