oracle样卷和参考答案(国外英语资料)

《oracle样卷和参考答案(国外英语资料)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle样卷和参考答案TestcouponIsaprofessionalclassnamesStudentidThebindingXiameninstituteoftechnologypaperThesecondsemesterofthe208-2009schoolyearCoursenameDatabasemanagementsystem(Oracle)TheexaminationpaperRolldon'ta.B-ProfessionalclassThetestwayComparativeeconomicsOpen

2、book-Theexampaperis5big(6pages),100marks,120minutes.Pleaseanswerthequestionontheanswersheetandanswerthequestiononthetestpaper.One,asinglechoiceofchoice(20shortquestions,2points,40points)Onlyoneofthefourcandidateslistedineachoftheitemsiseligibleforthetitle.Pleasefi

3、llinthecorrespondingformontheanswersheet.Neitherchoice,choice,norchoiceisall.Typically,whatcommandsareusedbytheoracleenterprisemanager?__D___A.http://serverIP:1521/B.http://serverIP:1521/emC.http://serverIP:5500/D.http://serverIP:5500/emIntheWindowsoperatingsystem

4、,Oracle's_A___servicelistensandacceptstheconnectionrequestsfromtheclientapplication.A.racleHOME_NAMETNSListenerb.OracleServiceSIDC.racleHOME_NAMEAgentd.OracleHOME_NAMEHTTPServerThefollowingmemoryareaisnotSGA's__A__D.pgab.logbufferc.databufferd.SharedpoolWhichofthe

5、followingisnotanobjectinthephysicalstructureA.datafileb.redologfilec.tablespaced.controlfileWhencreatingadatabase,therequiredtablespaceis____B____ATEMPTABLESPACEBSYSTEMTABLESPACECUSERSTABLESPACEDROLLBACKTABLESPACEWhenaSHUTDOWNstatementisusedtoclosethedatabase,then

6、exttimeyouopenthedatabase,youneedtodotherestoreoperation___C___SHUTDOWNTRANSACTIONALBSHUTDOWNABORTDSHUTDOWNNORMALWhichofthefollowingprocessesisnotanOracle'srequiredbackgroundprocess___D___ADBWRdataiswrittentoprocessBLGWRlogwritestotheprocessCSMONsystemmonitorsproc

7、essDARCnlogarchiveprocessInSQLPLUS,howtoruntheSQLscriptprogram__b___A/B@scriptTheCEXEscriptDcannotrunthescriptdirectlyintheSQLPLUSWhichofthefollowingoptionsisnotpartoftheOracleinstance?CA.systemglobalareaSGAb.PMONbackgroundprocessC.controld.Mnnnschedulingprocess10

8、.Iftheserverprocesscouldnotfindfreeblocksinthedatabuffer,toaddthereadblockofdatafromadatafile,thesystemwillstart____D______whichofthefollowingprocessa.c