未知题型
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
- 未知题型 Usingabitmapstructuretomanagedatabaseobjectspacehasseveralbenefitsoverusingfreeliststructures.Whichthreearebenefitsofmanagingspaceusingautomatic－segment－spacemanagedobjects？（）
- 未知题型 Whichthreetypesofinformationdoesthecontrolfilecontain？（）
- 未知题型 publicclassTest{publicstaticvoidmain（String[]args）{System.out.println（args.length>4&&args[4].equals（－d”））；}}Iftheprogramisinvokedusingthecommandline：javaTestOneTwoThree–dWhatistheresult？（）
- 未知题型 Whichoftheserecommendationsshouldbefollowedbeforecapturingaworkload？（）
- 未知题型 Youissuedthefollowingcommand：CREATEGLOBALTEMPORARYTABLEadmin_work_area （startdateDATE，enddateDATE，classCHAR（20））ONCOMMITDELETEROWSTABLESPACEtbs_t1；AnindexisthencreatedontheADMIN_WORK_AREAtemporarytable.WhichtwostatementsaretrueregardingtheTBS_T1tablespaceintheabovecommand？（）A.Itstoresonlythetemporarytablebutnotitsindexes.B.Itstoresboththetemporarytableaswellasitsindexes.C.Itmustbeanondefaulttemporarytablespaceforthedatabase.D.Itcanbeadefaultornondefaulttemporarytablespaceforthedatabase.E.Itmustbethedefaulttemporarytablespaceoftheuserwhoissuesthecommand.
- 未知题型 WhichfileswillyouneedtoperformafullrecoveryofadatabasebackedupinNOARCHIVELOGmode？（）
- 未知题型 Giventhefollowingcode，whichcodefragments，wheninsertedattheindicatedlocation，willsucceedinmakingtheprogramdisplayabuttonspanningthewholewindowarea？（）importjava.awt.*；publicclassQ1e65{publicstaticvoidmain（Stringargs[]）{Windowwin=newFrame（）；Buttonbut=newButton（"button"）；//insertcodefragmentherewin.setSize（200，200）；win.setVisible（true）；}}A.win.setLayout（newBorderLayout（））；win.add（but）；B.win.setLayout（newGridLayout（1，1））；win.add（but）；C.win.setLayout（newBorderLayout（））；win.add（but，BorderLayout.CENTER）；D.win.add（but）；E.win.setLayout（newFlowLayout（））；win.add（but）；
- 未知题型 WritealineofcodethatdeclaresavariablenamedlayoutoftypeLayoutManagerandinitializesitwithanewobject，whichwhenusedwithacontainercanlayoutcomponentsinarectangulargridofequal-sizedrectangles，3componentswideand2componentshigh.（）
- 未知题型 Whichstatementsaretrueconcerningtheeffectofthe>>and>>>operators?（）
- 未知题型 VNFM(VNF manager）负责生命周期管理，基本能力包括网元VM的（）
- 未知题型 ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable：SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE；Whichthreestatementsaretrueregardingtheabovecommand（）
- 未知题型 YouwanttomigrateyourexistingnonASMfilestoASMfilesforthedatabasePROD.Whichmethodorcommandwouldyouusetoaccomplishthistask？（）
- 未知题型 Evaluatethefollowingcommandanditsoutput：SQL>SELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
- 未知题型 Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
- 未知题型 YouexecutedthefollowingcommandtocreateatablespacecalledSALES_DATA：>CREATETABLESPACEsales_dataDATAFILESIZE100MSEGMENTSPACEMANAGEMENTAUTO；WhichtwostatementsaretrueabouttheSALES_DATAtablespace（）
- 未知题型 Identifythetwosituationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetails.（）
- 未知题型 YouaretheDatabaseAdministrator（DBA）ofyourcompany.YouexecutethefollowingstatementonanOracle10ginstance：SQL>ALTERSYSTEMSWITCHLOGFILE；Whichtwotasksareperformedwhenthestatementisexecuted？（）
- 未知题型 WhichtwostatementsaretrueabouttherolesintheOracledatabase？（）
