niusouti.com

单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With refer

题目
单选题
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
A

time­based recovery

B

log sequence recovery

C

cancel­based recovery

D

change­based recovery

相似考题

1.Which substitution variable would you use if you want to reuse the variable without prompting the user each time? ()A. &B. ACCEPTC. PROMPTD. &&

2.Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours? （）A、restore datafiles until time '09/28/2008:21:03:11'B、restore database files until time '09/28/2008:18:00:00'C、restore database until time '09/28/2008:18:00:00'D、recover database until time '09/28/2008:18:00:00'E、recover database until timestamp '09/28/2008:18:00:00'

3. You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）A、 A user table was lost at the specified time.B、 A redo log file was lost at the specified time.C、 The backup control file is on a faster disk than the current one.D、 The current control file has a different path compared with the intended time of recovery.E、 The current control file does not match the physical structure of the database at the intended time of recovery.

4.You are the network administrator for Ezonexam.The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.Both partitions are formatted as NTFS. Both partitions are backed up to a tape every evening at 11:00 P.M.You have a current Emergency Repair Disk (ERD) for the computer, and Recovery Console is installed on the computer.One day at2:00 P.M., the server fails. You attempt to restart the computer, but you receive the following error message: "Boot disk or operating system not found." You use Recovery Console to discover that the files on partition C are corrupted.You want to recover the server from the failure as quickly as possible. You also want to recover as much user data as possible.What should you do?A．Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.B．Install a second hard disk in the computer. Install Windows 2000 Server on the new hard disk. Re-create the shared folders on the first hard disk.C．Use a Windows 2000 Server boot floppy disk to start the computer. Replace the corrupted files on partition C by copying them from the Emergency Repair Disk.D．Boot to the Recovery Console. Copy any files that have changed since 11:00 P.M. the previous evening to a second server. Use the most recent tape backup to restore the remaining user data to the second server.

更多“The current time is 12：00 noon. You want to recover the USER”相关问题

  • 第1题：

    In which scenario will you use the Flashback Transaction Query feature？（）

    • A、 when you want to restore an important table that is dropped from the Recycle Bin
    • B、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction
    • C、when you want to restore a dropped user’s schema
    • D、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

    正确答案:B

  • 第2题：

    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）

    • A、time­based recovery
    • B、log sequence recovery
    • C、cancel­based recovery
    • D、change­based recovery

    正确答案:C

  • 第3题：

    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

    • A、 when all the control files are missing and only a binary backup of the current control file exists
    • B、 when a multiplexed copy of the current control file is missing
    • C、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists
    • D、 when the SPFILE is missing

    正确答案:A

  • 第4题：

    Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）

    • A、&
    • B、ACCEPT
    • C、PROMPT
    • D、&&

    正确答案:D

  • 第5题：

    单选题
    You want to perform the database backup when user activity on your system is low, such as between 12:00 a.m. and 2:00 am. Which command terminates with an error if the backup is not complete at the end of the specified duration?（）
    A

    RMAN> BACKUP DURATION 2:00 MINIMIZE LOAD DATABASE

    B

    RMAN> BACKUP DURATION 2:00 PARTIAL FILESPERSET 1 DATABASE

    C

    RMAN> BACKUP DURATION 2:00 PARTIAL MINIMIZE TIME DATABASE 

    D

    RMAN> BACKUP AS COPY DURATION 2:00 PARTIAL MINIMIZE LOAD DATABASE


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You performed an incomplete recovery on your Oracle Database 10g database using the following command：  SQL> RECOVER DATABASE  2 UNTIL TIME ’2004/x7f08/x7f05：12：10：03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required？（）
    A

    A user table was lost at the specified time.

    B

    A redo log file was lost at the specified time.

    C

    The backup control file is on a faster disk than the current one.

    D

    The current control file has a different path compared with the intended time of recovery.

    E

    The current control file does not match the physical structure of the database at the intended time of recovery.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
    A

     time-based recovery

    B

     log sequence recovery

    C

     cancel-based recovery

    D

     change-based recovery


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（）   a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’  c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open
    A

     b， d， e

    B

     b， d， f

    C

     c， a， b， d， e

    D

     c， a， b， d， f

    E

     a， b， d， e


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）
    A

     A user table was lost at the specified time.

    B

     A redo log file was lost at the specified time.

    C

     The backup control file is on a faster disk than the current one.

    D

     The current control file has a different path compared with the intended time of recovery.

    E

     The current control file does not match the physical structure of the database at the intended time of recovery.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
    A

    time­based recovery

    B

    log sequence recovery

    C

    cancel­based recovery

    D

    change­based recovery


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    In which scenario will you use the Flashback Transaction Query feature？（）
    A

     when you want to restore an important table that is dropped from the Recycle Bin

    B

     when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction

    C

    when you want to restore a dropped user’s schema

    D

     when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You need to restore your database back to 9/30/2008 at 18：00. In what order would you run the following commands to compete this task？（）   a. restore controlfile until time `09/30/2008：18：00：00’ b. restore database until time `09/30/2008：18：00：00’  c. restore spfile until time `09/30/2008：18：00：00’ d. recover database until time `09/30/2008：18：00：00’ e. alter database open resetlogs f. alter database open

    • A、 b， d， e
    • B、 b， d， f
    • C、 c， a， b， d， e
    • D、 c， a， b， d， f
    • E、 a， b， d， e

    正确答案:A

  • 第14题：

    You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

    • A、 UNTIL SEQUENCE
    • B、 UNTIL SCN
    • C、 UNTIL CHANGE
    • D、 UNTIL CANCEL

    正确答案:C,D

  • 第15题：

    You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

    • A、 all the datafiles in the database
    • B、 the datafiles associated with the SYSTEM tablespace
    • C、 the datafiles associated with the DATA1 tablespace
    • D、 all the datafiles in the database except those associated with the DATA1 tablespace

    正确答案:D

  • 第16题：

    You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）

    • A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
    • B、 restore the entire database from the most recent backup and open it
    • C、 recover the table by using the Flashback Table feature
    • D、 perform point-in-time recovery to recover the table

    正确答案:D

  • 第17题：

    单选题
    In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；
    A

     when all the control files are missing and only a binary backup of the current control file exists

    B

     when a multiplexed copy of the current control file is missing

    C

    when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists

    D

     when the SPFILE is missing


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    A user on your network downloads a video card driver from the Internet. You are unsure of the source of the driver. You want to ensure that the user does not lose production time because of an incompatible driver. What should you do?（）
    A

    Install the driver into the computer. Restart the computer. Use the last known good configuration to recover the original driver if necessary. 

    B

    Install the driver in the computer. Use the hardware troubleshooter and then use the recovery console to recover the original driver if necessary. 

    C

    Display the advanced attributes of the video card driver file. Install the file only if the contents have been secured. 

    D

    Run file signature verification utility to verify that the driver has been digitally signed. 


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    Which command would correctly start a TSPITR of the USERS tablespace？（）
    A

     recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliary

    B

     recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliary

    C

     recover tablespace users to point-in.

    D

     recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

    E

     recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）
    A

    &

    B

    ACCEPT

    C

    PROMPT

    D

    &&


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
    A

    Only the SET command must be within a RUN block.

    B

    All commands should be executed at the RMAN prompt.

    C

    All three commands must be within a single RUN block.

    D

    Only the RESTORE and RECOVER commands must be within a single RUN block.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?（）
    A

    Setting a metric threshold

    B

    Implementing Database Resource Manager

    C

    Enabling resumable timeout for user sessions

    D

    Decreasing the value of the IDLE_TIME resource limit in the default profile


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）
    A

     Complete Recovery with online redo log

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）
    A

     all the datafiles in the database

    B

     the datafiles associated with the SYSTEM tablespace

    C

     the datafiles associated with the DATA1 tablespace

    D

     all the datafiles in the database except those associated with the DATA1 tablespace


    正确答案： A
    解析： 暂无解析

相关内容