问题

Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateone

Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateoneofthedimensiontablesperiodically.Therecordsintheexternaltablemaycontaindatafornewrowsinthedimensiontable，orforupdatestoitsexistingrows.WhichtypeofSQLcommandwouldyouusetotransferthedatafromtheexternaltabletothedimensiontableasefficientlyaspossible？（）

A、MERGE

B、SELECT…CROSSJOIN

C、INSERTALL…SELECT

D、CREATEVIEW…CONSTRAINT

参考答案

您可能感兴趣的试题

暂无相关推荐