未分类题

Wherecansubqueriesbeused?（）

A.fieldnamesintheSELECTstatement
B.theFROMclauseintheSELECTstatement
C.theHAVINGclauseintheSELECTstatement
D.theGROUPBYclauseintheSELECTstatement
E.theWHEREclauseinonlytheSELECTstatement
F.theWHEREclauseinSELECTaswellasallDMLstatements

【参考答案】

B, C, F

<上一题目录下一题>

热门试题

未分类题

YouworkasadatabaseadministratorforSupportcenter.cn.YourdatabaseisopenedinNOARCHIVEKLOGmode.YoudecidetoplacethedatabaseinARCHIVELOGmode.Howwouldyoudothis？（）

未分类题

YouworkasadatabaseadministratorforSupportcenter.cn.Yourlistenerprocess，L1，iscurrentlylisteningtothreedatabases：CertKINDB04，SupportCenterDB05andSupportCenterDB06.UsingDatabaseConfigurationAssistant（DBCA）youcreateonemoredatabase，SupportCenterDB07，andenabledynamicregistration.WhichtwocommandsofListenerControlUtility（lsnrct1）wouldyouusetodeterminewhetherthedynamicregistrationoccurredforthedatabase，SupportCenterDB07，withtheL1listenerprocess？（）A.SHOWL1B.SPAWNL1C.STATUSL1D.SERVICESL1E.STATUSLISTENERF.SERVICESLISTENERG.SHOWcurrent_listener