OracleDBA启动和关闭例程试选题.docx
- 文档编号:6517244
- 上传时间:2023-01-07
- 格式:DOCX
- 页数:7
- 大小:15.66KB
OracleDBA启动和关闭例程试选题.docx
《OracleDBA启动和关闭例程试选题.docx》由会员分享,可在线阅读,更多相关《OracleDBA启动和关闭例程试选题.docx(7页珍藏版)》请在冰豆网上搜索。
OracleDBA启动和关闭例程试选题
OracleDBA启动和关闭例程试选题
OracleDBA启动和关闭例程试选题OracleDBA启动和关闭例程试选题q.1:
thedatabasemustbeinthismodefortheinstancetobestarted
1.mount
2.open
3.nomount
4.none
3
q.2:
whenoraclestartupsup,whathappensifadatafileorredologfilenotavailableorcorruptedduetoo.sproblems
1.oraclereturnsawarningmessageandopensthedatabase
2.oraclereturnsawarningmessageanddoesnotopenthedatabase
3.oraclereturnsawarningmessageandstartsthedatabaserecovery
4.oracleignoresthosefilesandfunctionsnormally
2
q.3:
therestrictedsessionsystemprivilegeshouldbegivento
1.users,whoneedextrasecuritywhiletransferingthedatabetweenclientandtheserverthroughsql*netornet8.
2.dbas,whoperformstructuralmaintenanceexportsandimportsthedata.
3.alloftheabove
4.noneoftheabove
2
q.4:
whenstartingupadatabase,ifoneormoreofthefilesspecifiedinthecontrol_filesparameterdoesnotexist,orcannotbeopened
1.oraclereturnsawarningmessageanddoesnotmountthedatabase
2.oraclereturnsawarningmessageandmountsthedatabase
3.oracleignoresthosefilesandfunctionsnormally
4.oraclereturnsawarningmessageandstartsdatabaserecovery
1
q.5:
bobtriedtoshutdownnormal,oraclesaiditwasunavailable,andwhenhetriedtostarup,oraclesaidthatitwasalreadystarted.whatisthebestmodethatbobcanusetoforceashutdownontheserver
1.normal
2.abort
3.immediate
4.none
2
q.6:
tomissuedacommandtostartupthedatabase.whatmodesdoestheinstanceanddatabasepassthroughtofinallyhavethedatabaseopen
1.open,nomount,mount
2.nomount,mount,open
3.nomount,open,mount
4.mount,open,nomount
2
q.7:
dianeisanewdbaandissuedashutdowncommandwhileherserverisbeingused.afterawhileshefiguresthatoracleiswaitingforalltheuserstosignoff.whatshutdownmodedidsheuse
1.normal
2.abort
3.immediate
4.none
1
q.8:
whichscriptfilecreatescommonlyuseddatadictionaryviews
1.sql.bsq
2.catalog.sql
3.utlmontr.sql
4.catproc.sql
2
q.9:
inordertoperformafullmediarecovery,thedatabasemustbe
1.mountedandopenedusingresetlogoption
2.mountedbutnotopened
3.mountedandopenedusingarchivelogoption
4.youcannotperformafullmediarecovery
2
q.10:
whenistheparameterfilereadduringstartup
1.whenopeningthedatabase
2.whenmountingthedatabase
3.duringinstancestartup
4.ineverystage
3
q.11:
whatisthedefaultmountoptionforanoracledatabase
1.shared
2.parallel
3.exclusive
4.retry
3
q.12:
youcannotstartadatabaseinstanceifyouareconnectedtothedatabaseviaasharedserverprocess.
1.true
2.false
3.dependsontheo.s
4.dependsontheo.sandnetworkprotocol
1
q.13:
theshutdownmodethatrequiresinstancerecoveryatnextstartupis
1.normal
2.abort
3.immediate
4.noneoftheabove
2:
uncommittedtransactionsarenotrolledback.sotheinstanceneedsrecovery.refertoshuttingdowninstance.
q.14:
whichcommandonlymountsthedatabase
1.startupopen
2.startupnomount
3.startupforce
4.startupmount
3
q.15:
whichshutdownmodeshutsdowntheinstancebutdoesnotgothroughthedismountphase
1.normal
2.abort
3.immediate
4.none
2
q.16:
whichstartupmodeshouldyouusetostartupaninstanceformaintenance
1.open
2.mount
3.nomount
4.force
2:
thedatabasemustbeclosedwhenyouadd,drop,renametheredologfilesrenamethedatafilesperformfulldatabaserecovery.refertostartingupaninstance
q.17:
whichcommandshouldyouusetoopenadatabasefornormalusewhileitisalreadymounted
1.alterdatabaseopen
2.altersystemopendatabase
3.startupdatabase
4.startupopen
1
q.18:
whichshutdownmodewaitsforalluserstodisconnectbeforecompletingtheshutdown
1.abort
2.immediate
3.force
4.normal
4
q.19:
whichmountshouldyouuseifmultipleinstanceswillbeallowedtoaccessthedatabase
1.retry
2.exclusive
3.parallel
4.none
3
q.20:
whatisthefastestmodetoshutdownthedatabase
1.normal
2.abort
3.immediate
4.none
2:
theoperationofwritingalldatainthebuffersofthesgatothedatafilesandredologfilesisskipped.refertodatabaseandinstancestartupandshutdown.
q.1:
thedatabasemustbeinthismodefortheinstancetobestarted
1.mount
2.open
3.nomount
4.none
3
q.2:
whenoraclestartupsup,whathappensifadatafileorredologfilenotavailableorcorruptedduetoo.sproblems
1.oraclereturnsawarningmessageandopensthedatabase
2.oraclereturnsawarningmessageanddoesnotopenthedatabase
3.oraclereturnsawarningmessageandstartsthedatabaserecovery
4.oracleignoresthosefilesandfunctionsnormally
2
q.3:
therestrictedsessionsystemprivilegeshouldbegivento
1.users,whoneedextrasecuritywhiletransferingthedatabetweenclientandtheserverthroughsql*netornet8.
2.dbas,whoperformstructuralmaintenanceexportsandimportsthedata.
3.alloftheabove
4.noneoftheabove
2
q.4:
whenstartingupadatabase,ifoneormoreofthefilesspecifiedinthecontrol_filesparameterdoesnotexist,orcannotbeopened
1.oraclereturnsawarningmessageanddoesnotmountthedatabase
2.oraclereturnsawarningmessageandmountsthedatabase
3.oracleignoresthosefilesandfunctionsnormally
4.oraclereturnsawarningmessageandstartsdatabaserecovery
1
q.5:
bobtriedtoshutdownnormal,oraclesaiditwasunavailable,andwhenhetriedtostarup,oraclesaidthatitwasalreadystarted.whatisthebestmodethatbobcanusetoforceashutdownontheserver
1.normal
2.abort
3.immediate
4.none
2
q.6:
tomissuedacommandtostartupthedatabase.whatmodesdoestheinstanceanddatabasepassthroughtofinallyhavethedatabaseopen
1.open,nomount,mount
2.nomount,mount,open
3.nomount,open,mount
4.mount,open,nomount
2
q.7:
dianeisanewdbaandissuedashutdowncommandwhileherserverisbeingused.afterawhileshefiguresthatoracleiswaitingforalltheuserstosignoff.whatshutdownmodedidsheuse
1.normal
2.abort
3.immediate
4.none
1
q.8:
whichscriptfilecreatescommonlyuseddatadictionaryviews
1.sql.bsq
2.catalog.sql
3.utlmontr.sql
4.catproc.sql
2
q.9:
inordertoperformafullmediarecovery,thedatabasemustbe
1.mountedandopenedusingresetlogoption
2.mountedbutnotopened
3.mountedandopenedusingarchivelogoption
4.youcannotperformafullmediarecovery
2
q.10:
whenistheparameterfilereadduringstartup
1.whenopeningthedatabase
2.whenmountingthedatabase
3.duringinstancestartup
4.ineverystage
3OracleDBA启动和关闭例程试选题相关内容:
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- OracleDBA 启动 关闭 例程 选题