Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having acti

题目

Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having active online redo log files is also corrupted.-The hardware is repaired and the paths for online redo log files and control files are still valid.Which option would you use to perform the recovery of database till the point of failure?()

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


相似考题

2.You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A.Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B.Modify the workflow in the DTS package so that the server in Sydney is included.C.On the server in Sydney, install an OLE DB provider for the mainframe. database.D.On the server in Sydney, delete and then re-create the DTS package.

更多“Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consisten ”相关问题
  • 第1题:

    Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()

    A.run{openscriptbackup_database;runscriptbackup_database}

    B.run{engagescriptbackup_database;}

    C.run{runscriptbackup_database;}

    D.Run{executescriptbackup_database;}

    E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.


    参考答案:D

  • 第2题:

    检查

    A.expect

    B.except

    C.excuse

    D.examine


    正确答案:D

  • 第3题:

    Nothing in these Rules shall ______ any vessel,or the owner,master or crew thereof,from the consequences of any precaution which may be required by the ordinary practice of seaman,or by the special circumstances of the case.

    A.exonerate

    B.exhaust

    C.exercise

    D.examine


    正确答案:A

  • 第4题:

    After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.


    参考答案:being examined

  • 第5题:

    AcustomerwantstopurchaseaWindows2003DataCenterEditionsystemtorunanapplication.TheapplicationbenefitsthemostbycachingavastamountofdatainRAMsotheuserdoesnothavetowaitfordiskI/Owhileediting.Processingissecondinimportance.Ifcostisnotanissue,whatmachinewillhavethebestperformance?()

    A.Useanx360running4MPprocessorswith16GBofRAM

    B.Useanx360running4DPprocessorswith16GBofRAM

    C.Useanx445running2DPprocessorswith64GBofRAM

    D.Useanx445running4DPprocessorswith64GBofRAM


    参考答案:D

  • 第6题:

    He rolled up his trouer leg to exhibit his wounded knee.

    A:spread
    B:open
    C:show
    D:examine

    答案:C
    解析:
    本句意思:他卷起他的裤腿来显露受伤的膝盖。exhibit展示,显示。spread伸开,展开;open打开;show展示,出示;examine检查。