更多“在rman中,哪些recover database …until语法是正确的? () A. ..until cancelB. ..until timeC. .. until scnD. ..until changeE. ..until sequenceF. 以上都正确”相关问题
  • 第1题:

    下列关于Do Until-Loop型循环的叙述中,正确的是 ______。

    A.先执行循环体,当Until后的表达式成立时继续循环

    B.先执行循环体,当Until后的表达式成立时退出循环

    C.先进行循环条件的判断,当Until后的表达式成立时继续循环

    D.先进行循环条件的判断,当Until后的表达式成立时停止循环


    正确答案:D
    解析:Do Until-Loop循环语句是先判断后执行,即:先进行循环条件的判断,当Until后的表达式成立时停止循环。

  • 第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'

    正确答案:C

  • 第3题:

    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()

    • A、 until Thursday morning
    • B、 until that point in time when the database is opened
    • C、 until that point in time when the recovery is performed
    • D、 until last Sunday’s backup
    • E、 until that point in time when the table is dropped and purged
    • F、 until Wednesday evening

    正确答案:D

  • 第4题:

    下列哪一个命令可以用来执行不完全恢复?()

    • A、RESTORE DATABASE UNTIL
    • B、RECOVER DATABASE UNTIL
    • C、RECOVER DATA UNTIL
    • D、RESTORE DATA UNTIL

    正确答案:B

  • 第5题:

    下列关于do while…loop和do…loop until循环执行循环体次数的描述正确的是()。

    • A、do while…loop循环和do…loop until循环至少都执行一次
    • B、do while…loop循环和do…loop until循环可能都不执行
    • C、do while…loop循环至少执行一次,do…loop until循环可能不执行
    • D、do while…loop循环可能不执行,do…loop until循环至少执行一次

    正确答案:D

  • 第6题:

    Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database?()

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第7题:

    You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go? ()

    • A、3 hours
    • B、6 months
    • C、until last year
    • D、until last commit
    • E、until the point when the undotablespacewas refreshed
    • F、until the database is shut down and the memory erased

    正确答案: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

    正确答案:A

  • 第9题:

    The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第10题:

    What will be the end result of this set of RMAN commands?()   shutdown abort startup mount  restore datafile 4 until time ,,09/30/2008:15:00:00;  recover datafile 4 until time ,,09/29/2008:15:00:00;  alter database open resetlogs;

    • A、 Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
    • B、 The restore command will fail.
    • C、 The recover command will fail.
    • D、 The alter database open resetlogs command will fail.
    • E、 All these commands will fail because they must be in the confines of a run block.

    正确答案:D

  • 第11题:

    单选题
    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'


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

  • 第12题:

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
    A

     until Thursday morning

    B

     until that point in time when the database is opened

    C

     until that point in time when the recovery is performed

    D

     until last Sunday’s backup

    E

     until that point in time when the table is dropped and purged

    F

     until Wednesday evening


    正确答案: F
    解析: 暂无解析

  • 第13题:

    It( )we had stayed together for a couple of weeks( )I found we had a lot in common.

    A.was until;when
    B.was until;that
    C.wasn’t;when
    D.wasn’t until;that

    答案:D
    解析:
    考查强调句型。强调句糅合了not ...until 的结构,强调的部分是we had stayed together for a couple of weeks,后面填that。故本题选D。句意:我们在一起待了几周,我才发现我们有很多相同之处。

  • 第14题:

    When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()

    • A、Until SCN
    • B、Until time
    • C、Until cancel
    • D、Recover using backup control file.

    正确答案:C

  • 第15题:

    Your database is in the NOARCHIVELOG mode. Since last night’s offline backup, the logs in group 1 have been written to twice. This morning, the SYSTEM data file has become corrupted. Up to what point can it be recovered?()

    • A、until the last commit
    • B、cannot be recovered
    • C、until the last offline backup
    • D、until the beginning of the last transaction

    正确答案:C

  • 第16题:

    Do循环语句是根据条件决定循环的语句的,下列说法正确的是()。

    • A、While是当条件为真时执行循环,而Until是在条件变为真的之前重复
    • B、Until是当条件为真时执行循环,而While是在条件变为真的之前重复
    • C、While和Until都是当条件为真时执行循环
    • D、While和Until都是在条件变为真的之前重复循环

    正确答案:A

  • 第17题:

    In IS-IS, how long will the restart helper keep the restarting router in the up state?()

    • A、until the hello dead timer expires
    • B、until the restart duration timer expires
    • C、until the restarting router sets the down bit
    • D、until the restart helper sends out three CSNPs

    正确答案:B

  • 第18题:

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database?()

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

  • 第19题:

    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()

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

    正确答案:A

  • 第20题:

    Which of the following are valid until command options when attempting point-in-time recovery in RMAN?()

    • A、 until time
    • B、 until change
    • C、 until sequence
    • D、 until SCN
    • E、 until commit

    正确答案:A,C,D

  • 第21题:

    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

  • 第22题:

    单选题
    You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility?()
    A

     UNTIL CANCEL

    B

     UNTIL SCN

    C

     UNTIL SEQUENCE

    D

     UNTIL TIME


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

  • 第23题:

    单选题
    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
    解析: 暂无解析