1
OracleDBA启动和关闭例程试选题
OracleDBA启动和关闭例程试选题OracleDBA启动和关闭例
程试选题q.1:thedatabamustbeinthismodeforthe
instancetobestarted
t
3
q.2:whenoraclestartupsup,whathappensifadatafile
ems
returnsawarningmessageandopensthe
databa
returnsawarningmessageanddoesnotopen
thedataba
returnsawarningmessageandstartsthe
databarecovery
ignoresthofilesandfunctionsnormally
2
q.3:therestrictedssionsystemprivilegeshouldbe
2
givento
,whoneedextracuritywhiletransferingthe
databetweenclientandtherverthroughsql*netornet8.
,whoperformstructuralmaintenanceexportsand
importsthedata.
heabove
theabove
2
q.4:whenstartingupadataba,ifoneormoreofthe
filesspecifiedinthecontrol_filesparameterdoesnotexist,or
cannotbeopened
returnsawarningmessageanddoesnotmount
thedataba
returnsawarningmessageandmountsthe
databa
ignoresthofilesandfunctionsnormally
returnsawarningmessageandstartsdataba
recovery
1
q.5:bobtriedtoshutdownnormal,oraclesaiditwas
unavailable,andwhenhetriedtostarup,oraclesaidthatitwas
thebestmodethatbobcanuto
3
forceashutdownontherver
ate
2
q.6:tomissuedacommandtostartupthedataba.
whatmodesdoestheinstanceanddatabapassthroughto
finallyhavethedatabaopen
,nomount,mount
t,mount,open
t,open,mount
,open,nomount
2
q.7:dianeisanewdbaandissuedashutdown
whileshe
shutdownmodedidsheu
ate
4
1
q.8:whichscriptfilecreatescommonlyuddata
dictionaryviews
2
q.9:inordertoperformafullmediarecovery,the
databamustbe
dandopenedusingretlogoption
dbutnotopened
dandopenedusingarchivelogoption
notperformafullmediarecovery
2
q.10:whenistheparameterfilereadduringstartup
eningthedataba
untingthedataba
instancestartup
ystage
3
5
q.11:whatisthedefaultmountoptionforanoracle
databa
el
ive
3
q.12:youcannotstartadatabainstanceifyouare
connectedtothedatabaviaasharedrverprocess.
sontheo.s
tworkprotocol
1
q.13:theshutdownmodethatrequiresinstance
recoveryatnextstartupis
ate
theabove
2:
oshuttingdowninstance.
6
q.14:whichcommandonlymountsthedataba
popen
pnomount
pforce
pmount
3
q.15:whichshutdownmodeshutsdowntheinstance
butdoesnotgothroughthedismountpha
ate
2
q.16:whichstartupmodeshouldyouutostartupan
instanceformaintenance
t
2:thedatabamustbeclodwhenyouadd,drop,
renametheredologfilesrenamethedatafilesperformfull
ostartingupaninstance
7
q.17:whichcommandshouldyouutoopena
databafornormaluwhileitisalreadymounted
atabaopen
ystemopendataba
pdataba
popen
1
q.18:whichshutdownmodewaitsforallursto
disconnectbeforecompletingtheshutdown
ate
4
q.19:whichmountshouldyouuifmultipleinstances
willbeallowedtoaccessthedataba
ive
el
3
q.20:whatisthefastestmodetoshutdownthe
8
databa
ate
2:theoperationofwritingalldatainthebuffersofthe
o
databaandinstancestartupandshutdown.
q.1:thedatabamustbeinthismodefortheinstance
tobestarted
t
3
q.2:whenoraclestartupsup,whathappensifadatafile
ems
returnsawarningmessageandopensthe
databa
returnsawarningmessageanddoesnotopen
thedataba
9
returnsawarningmessageandstartsthe
databarecovery
ignoresthofilesandfunctionsnormally
2
q.3:therestrictedssionsystemprivilegeshouldbe
givento
,whoneedextracuritywhiletransferingthe
databetweenclientandtherverthroughsql*netornet8.
,whoperformstructuralmaintenanceexportsand
importsthedata.
heabove
theabove
2
q.4:whenstartingupadataba,ifoneormoreofthe
filesspecifiedinthecontrol_filesparameterdoesnotexist,or
cannotbeopened
returnsawarningmessageanddoesnotmount
thedataba
returnsawarningmessageandmountsthe
databa
ignoresthofilesandfunctionsnormally
returnsawarningmessageandstartsdataba
10
recovery
1
q.5:bobtriedtoshutdownnormal,oraclesaiditwas
unavailable,andwhenhetriedtostarup,oraclesaidthatitwas
thebestmodethatbobcanuto
forceashutdownontherver
ate
2
q.6:tomissuedacommandtostartupthedataba.
whatmodesdoestheinstanceanddatabapassthroughto
finallyhavethedatabaopen
,nomount,mount
t,mount,open
t,open,mount
,open,nomount
2
q.7:dianeisanewdbaandissuedashutdown
whileshe
11
shutdownmodedidsheu
ate
1
q.8:whichscriptfilecreatescommonlyuddata
dictionaryviews
2
q.9:inordertoperformafullmediarecovery,the
databamustbe
dandopenedusingretlogoption
dbutnotopened
dandopenedusingarchivelogoption
notperformafullmediarecovery
2
q.10:whenistheparameterfilereadduringstartup
eningthedataba
12
untingthedataba
instancestartup
ystage
3OracleDBA启动和关闭例程试选题相关内容:
本文发布于:2022-11-27 04:51:47，感谢您对本站的认可！
本文链接：http://www.wtabcd.cn/fanwen/fan/90/28871.html
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系，我们将在24小时内删除。
| 留言与评论（共有 0 条评论） |
