试题详情
- 单项选择题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
A、MERGE
B、SELECT …CROSS JOIN
C、INSERT ALL …SELECT
D、CREATE VIEW …CONSTRAINT
- A
关注下方微信公众号，在线模考后查看
热门试题
- Which organizations
- Identify two&#
- Examine the data of
- 在CREATE TABLE语句中，指定某
- Oracle 11g是基于（）的。
- Examine the followi
- You want
- You enabled Flashbac
- TheORDERStablehasthe
- 分组查询是在查询语句中使用（）子句，对查
- You work
- 解析后的SQL语句在SGA的哪个区域中进
- What is true about u
- You deploy&ens
- User A ex
- In your d
- Which of
- Exhibit： View t
- These are&ensp
- Which statements are