OracleOCP认证考试练习真题题库一.pdfVIP

  1. 1、本文档被系统程序自动判定探测到侵权嫌疑,本站暂时做下架处理。
  2. 2、如果您确认为侵权,可联系本站左侧在线QQ客服请求删除。我们会保证在24小时内做出处理,应急电话:400-050-0827。
  3. 3、此文档由网友上传,因疑似侵权的原因,本站不提供该文档下载,只提供部分内容试读。如果您是出版社/作者,看到后可认领文档,您也可以联系本站进行批量认领。
查看更多

试卷科目:考试

OracleOCP认证考试练习真题题库一

说明:答案和解析在试卷最后

第1部分:单项选择题,共240题,每题只有一个正确答案,多选或少选均不得分。

1.[单选题]Yourproductiondatabaseusesfilesystemstorage.YouwanttomovestoragetoOracle

AutomaticStorage

Management(ASM).Howwouldyouachievethis?

A)byusingRMAN

B)byusingDataPump

C)byusingtheDatabaseUpgradeAssistant(DBUA)

D)byusingatransportabledatabase

2.[单选题]Examinetheparametersforadatabase

Yourdatabasehasthreeundotablespacesandthedefaultundotablespaceisnotautoextensible.

Resumablespaceallocationisnotenabledforanysessionsinthedatabaseinstance.Whatistheeffect

onnewtransactionswhenallundospaceinthedefaultundotablespaceisinusebyactivetransaction?

A)Transactionswritetheirundoinatemporarytablespace.

B)Transactionsfail.

C)TransactionswritetheirundointheSYSTEMundosegment.

D)TransactionswaituntilspacebecomesavailableinUNDOTBS1.

3.[单选题]OneofyourdatabaseshasarchiveloggingenabledandRMANbackupsaretakenatregular

Intervals.ThedatafilefortheUSERStablespaceiscorrupt.Whichcommandmustyouexecutebefore

startingtherecoveryofthistablespace?

A)SWITCHDATAFILEALL;

B)STARTUPFORCE

C)ALTERTABLESPACEusersOFFLINETEMPORARY;

D)ALTERTABLESPACEusersOFELINENORMAL;

E)ALTERTABLESPACEusersOFFLINEIMMEDIATE;

4.[单选题]YourdatabasehasarchiveloggingenabledandRMANbackupsaretakenatregularintervals.

AdatafileintheUSERStablespaceisdamaged.Whichcommandmustyouexecutebeforestartingthe

recoveryofthistablespace?

A)SWITCHDATAFILEALL

B)STARTUPFORCE

C)STARTUPFORCENOMOUNT

D)ALTERTABLESPACEusersOFFLINE

5.[单选题]Yourdatabaseinstanceisstartedbyusingaseverparameterfile(SPFILE)Youexecutethe

Followingcommandtochangethevalueof

文档评论(0)

wangyuande + 关注
实名认证
文档贡献者

该用户很懒,什么也没介绍

1亿VIP精品文档

相关文档