John Harding decided to go down to the village____.A．to find a doctor to see to his ankleB

A.Backupcontrolfile.

B.Emergencycontrolfile.

C.Thecreatecontrolfilecommand.

D.TherestorecontrolfileSQL*Pluscommand.

E.Nobackupisrequired.Thedatabasewillre-createthecontrolfilewhenitisdiscoveredtobelost.

A.importthedatabasefromthelastexport

B.restoreallthemembersinthegroupfromthelastbackup

C.dropthelostmemberfromthedatabase，andthenaddanewmembertothegroup

D.restoreallthedatabasefilesfromthebackup，andthenperformacompleterecovery

E.restoreallthedatabasefilesfromthebackup，andthenperformanincompleterecovery

A.Restorethe19thsbackup，restoreallarchivedredologs，recoverthedatabasetothe20th，andopenthedatabase.

B.Tellthemthattheirrequestcannotbemetwiththecurrentbackupstrategy.

C.Restorethe19thsbackup，applytheonlineredologs，andopenthedatabase.

D.SwitchthedatabaseintoARCHIVELOGmode，restorethe19th’sbackup，restoreallarchivedredologs，andrecoverthedatabasetothe20th.

E.Usetherecoverdatabasecommandtorollbackthedatabasefromtodaytothe19thofthemonth.

A. Another repair session is running concurrently.

B. The failure ID has not been mentioned in the command for data file 5.

C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

Youhavelostallyourdatabasecontrolfiles.Torecoverthem，youaregoingtousetheresultsofthealterdatabasebackupcontrolfiletotracecommand.Yourdatafilesandyouronlineredologsareallintact.Whichofthefollowingistrueregardingyourrecovery？（）

A.Youwillneedtoopenthedatabasewiththeresetlogscommand.

B.AllyouneedtodoisexecutethetracefilefromSQL*Plusanditwillperformtherecoveryforyou.

C.Youwillusetheresetlogsversionofthecreatecontrolfilecommand.

D.Youwillusethenoresetlogsversionofthecreatecontrolfilecommand.

E.Youwillusethetracefiletocreateabackupcontrolfile，andthenyouwillrecoverthedatabasewiththerecoverdatabaseusingbackupcontrolfilecommand

A.Alpha a = x;

B.Foo f = (Delta)x;

C.Foo f = (Alpha)x;

D.Beta b = (Beta)(Alpha)x;

errormessage：createtableidtable（idnumber）*ERRORatline

1：ORA-01110：datafile4：，，/oracle01/oradata/orcl/users01.dbfORA-27041：01116：errorinopeningdatabasefile4ORA-unabletoopenfileLinuxError：

2：NosuchfileordirectoryAdditionalinformation：

3Youcanchoosefromthefollowingsteps：

a.Restorethemissingdatabasedatafiles.

b.Takethemissingdatafileoffline.

c.Shutdownthedatabase.

d.IssuetherecovertablespaceUSERScommand.

e.IssuetheStartupMountcommandtomountthedatabase.

f.BringtheUSERStablespaceonline.

g.Issuethealterdatabaseopencommand.

Whichisthecorrectorderofthesestepsinthiscase？（）

AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQL>SELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1：ORA01157：cannotidentify/lockdatafile201seeDBWRtracefileORA01110：datafile201：’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason？（）

A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.

B.Thedatabaseisopenedinrestrictedmode，soqueriesarenotallowed.

C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.

D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.

E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

A.Thedatabaseopensnormally.

B.Thedatabasepromptsforadatabaserecovery.

C.Thedatabasewriterwritestoatracefile，indicatingthatthetemporaryfileisnotfound.

D.Thedatabasegetsmountedandthrowsanerrorindicatingthatthetemporaryfilerequiresrecovery.