OracleOCP认证考试练习真题OCP062.pdfVIP

试卷科目：考试

OracleOCP认证考试练习真题OCP062

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

1.[单选题]Whatisarequirementforcreatingaremotedatabaseschedulerjob?

A)Theremotedatabasejobmustrunasauserthatisvalidontargetremotedatabase

B)Aprivatedatabaselinkmustbecreatedfromtheoriginatingdatabasetothetargetremotedatabase

C)ThetargetremotedatabaseonwhichthejobisscheduledmustbeOracleDatabase11gRelease2or

later

D)Thetargetremotedatabasemustbeonadifferenthostfromtheoriginatingschedulerdatabasehost

答案:A

解析:

2.[单选题]Yourproductiondatabaseusesfilesystemstorage.YouwanttomovestoragetoOracle

AutomaticStorageManagement(ASM).

Howwouldyouachievethis?

A)byusingRMAN

B)byusingDataPump

C)byusingtheDatabaseUpgradeAssistant(DBUA)

D)byusingatransportabledatabase

答案:A

解析:

3.[单选题]Examinetheparametersforadatabase

Yourdatabasehasthreeundotablespacesandthedefaultundotablespaceisnot

autoextensible.Resumablespaceallocationisnotenabledforanysessionsinthedatabase

instance.Whatistheeffectonnewtransactionswhenallundospaceinthedefaultundo

tablespaceisinusebyactivetransaction?

A)Transactionswritetheirundoinatemporarytablespace.

B)Transactionsfail.

C)TransactionswritetheirundointheSYSTEMundosegment.

D)TransactionswaituntilspacebecomesavailableinUNDOTBS1.

答案:B

解析:

4.[单选题]OneofyourdatabaseshasarchiveloggingenabledandRMANbackupsaretakenatregular

intervals.ThedatafilefortheUSERStablespaceiscorrupt.Whichcommandmustyouexecute

beforestartingtherecoveryofthistablespace?

A)SWITCHDATAFILEALL;

B)STARTUPFORCE

C)ALTERTABLESPACEusersOFFLINETEMPORARY;

D)ALTERTABLESPACEusersOFELINENORMAL;

E)ALTERTABLESPACEusersOFFLINEIMMEDIATE;

答案:E

解析:

5.[单选题]Yourdatabas