black

1Z0-032

登录

单项选择题

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

相关考题

单项选择题 WhatdoestheMetadataApplicationProgrammingInterface(API)allowyoutodo?()

单项选择题 The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.()  1. Shot down and start up the former primary instance without mounting the instance.  2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  STANDBY command.  3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.  4. End read or update activity on the former primary and standby database.

单项选择题 In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport Services?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064