Oracle DBA启动和关闭例程试题及答案.docx

OracleDBA启动和关闭例程试题及答案OracleDBA启动和关闭例程精选试题及答案Q.1:TheDatabasemustbeinthismodefortheinstancetobestarted1.MOUNT2.OPEN3.NOMOUNT4.None3Q.2:WhenOraclestartupsup,whathappensifadatafileorredologfilenotavailableorcorruptedduetoO.SProblems1.Oraclereturnsawarningmessageandopensthedatabase2.Oraclereturnsawarningmessageanddoesnotopenthedatabase3.Oraclereturnsawarningmessageandstartsthedatabaserecovery4.Oracleignoresthosefilesandfunctionsnormally2Q.3:TheRESTRICTEDSESSIONsystemprivilegeshouldbegivento1.Users,whoneedextrasecuritywhiletransferingthedatabetweenclientandtheserverthroughSQL*NETorNET8.2.DBAs,whoperformstructuralmaintenanceexportsandimportsthedata.3.Alloftheabove4.Noneoftheabove2Q.4:WhenStartingupadatabase,IfoneormoreofthefilesspecifiedintheCONTROL_FILESparameterdoesnotexist,orcannotbeopened1.Oraclereturnsawarningmessageanddoesnotmountthedatabase2.Oraclereturnsawarningmessageandmountsthedatabase3.Oracleignoresthosefilesandfunctionsnormally4.Oraclereturnsawarningmessageandstartsdatabaserecovery1Q.5:Bobtriedtoshutdownnormal,Oraclesaiditwasunavailable,andwhenhetriedtostarup,oraclesaidthatitwasalreadystarted.Whatisthebestmodethatbobcanusetoforceashutdownontheserver1.NORMAL2.ABORT3.IMMEDIATE4.NONE2Q.6:Tomissuedacommandtostartupthedatabase.WhatmodesdoestheInstanceandDatabasepassthroughtofinallyhavethedatabaseopen1.OPEN,NOMOUNT,MOUNT2.NOMOUNT,MOUNT,OPEN3.NOMOUNT,OPEN,MOUNT4.MOUNT,OPEN,NOMOUNT2Q.7:Dianeisanewdbaandissuedashutdowncommandwhileherserverisbeingused.Afterawhileshefiguresthatoracleiswaitingforalltheuserstosignoff.Whatshutdownmodedidsheuse1.NORMAL2.ABORT3.IMMEDIATE4.NONE1Q.8:Whichscriptfilecreatescommonlyuseddatadictionaryviews1.sql.bsq2.catalog.sql3.utlmontr.sql4.catproc.sql2Q.9:Inordertoperformafullmediarecovery,theDatabasemustbe¡­1.MountedandOpenedusingRESETLOGoption2.MountedbutnotOpened3.MountedandOpenedusingARCHIVELOGoption4.Youcannotperformafullmediarecovery2Q.10:Whenistheparameterfilereadduringstartup1.WhenopeningtheDatabase2.WhenmountingtheDatabase3.Du