niusouti.com

多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN？（）Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit

题目
多选题
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

相似考题

1.Which options must you configure while performing an automated Tablespace Point－in－Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()A. New channels for restore and recovery tasksB. New name for the data files of the tablespaceC. Auxiliary name for the data files of the tablespaceD. Auxiliary destinations for an auxiliary set of data files

2. You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

3. You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.

4.How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.

更多“多选题Which of the following are valid until command options when attempting point-in-time recovery in RMAN？（）Auntil timeBuntil changeCuntil sequenceDuntil SCNEuntil commit”相关问题

  • 第1题：

    What RMAN command is used to execute a tablespace point-in-time recovery？（）

    • A、 recover
    • B、 duplicate
    • C、 restore
    • D、 copy
    • E、 None of the above

    正确答案:A

  • 第2题：

    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

    • A、 when you change the name of a datafile
    • B、 when you drop a table from the database
    • C、 when you take an export of the database
    • D、 when you back up the database using OS utilities
    • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
    • F、 when you issue a BACKUP command from inside the RMAN run block

    正确答案:A,E,F

  • 第3题：

    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

    • A、New channels for restore and recovery tasks
    • B、New name for the data files of the tablespace
    • C、Auxiliary name for the data files of the tablespace
    • D、Auxiliary destinations for an auxiliary set of data files

    正确答案:D

  • 第4题：

    Which statement about using RMAN stored scripts is true？（）  

    • A、 To create and execute an RMAN stored script，you must use a recovery catalog.
    • B、 When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
    • C、 RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、 When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第5题：

    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）

    • A、 target database
    • B、 auxiliary database
    • C、 third-party database
    • D、 recovery catalog database

    正确答案:C

  • 第6题：

    When running the tablespace point-in-time command   recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:/oracle/auxiliary; you receive the following error:  RMAN-00571: ===========================================================  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS  =============== RMAN-00571:  ===========================================================  RMAN-03002: failure of recover command at 10/08/2008 16:00:30  RMAN-20202: Tablespace not found in the recovery catalog  RMAN-06019: could not translate tablespace name "USERS"   What is the likely cause of the error?（）

    • A、 The database is in ARCHIVELOG mode.
    • B、 There is not a current backup of the database available.
    • C、 The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
    • D、 The USERS tablespace is not eligible for TSPITR because it has invalid objects.
    • E、 The recover tablespace command is incorrect and generates the error.

    正确答案:B

  • 第7题：

    多选题
    Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
    A

    when you change the name of a datafile

    B

    when you drop a table from the database

    C

    when you take an export of the database

    D

    when you back up the database using OS utilities

    E

    when you issue an ALTER SYSTEM SWITCH LOGFILE statement

    F

    when you issue a BACKUP command from inside the RMAN run block


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

  • 第8题：

    多选题
    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


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

  • 第9题：

    多选题
    When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）
    A

    Thread number.

    B

    Log Sequence number.

    C

    Control file sequence number.

    D

    Name of the last archived log.


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

  • 第10题：

    单选题
    Which of the following statement is incorrect regarding RMAN？（）
    A

    It detects corrupt blocks.

    B

    It performs only offline database backups.

    C

    It omits empty blocks during backups.

    D

    It performs tablespace point-in-time recovery （TSPITR）.


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

  • 第11题：

    单选题
    What RMAN command is used to execute a tablespace point-in-time recovery？（）
    A

     recover

    B

     duplicate

    C

     restore

    D

     copy

    E

     None of the above


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

  • 第12题：

    多选题
    When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）
    A

    data file

    B

    password file

    C

    archivelog file

    D

    temporary file

    E

    online redo log file

    F

    the current control file

    G

    the tnsnames.ora file

    H

    current server parameter file


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

  • 第13题：

    Which of the following statement is incorrect regarding RMAN？（）

    • A、It detects corrupt blocks.
    • B、It performs only offline database backups.
    • C、It omits empty blocks during backups.
    • D、It performs tablespace point-in-time recovery （TSPITR）.

    正确答案:B

  • 第14题：

    To perform a database point-in-time recovery using RMAN， after database restoration， you must ensure that the database is in which of the following states？（）

    • A、OPEN
    • B、MOUNT
    • C、NOMOUNT
    • D、CLOSE

    正确答案:B

  • 第15题：

    You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files：  $ rman target /  What would be the effect of this command？（）

    • A、RMAN would use the current operating system location to place the backup.
    • B、RMAN would use the control file of the target database to maintain the backup.
    • C、RMAN would use the recovery catalog of the target database to maintain the backup.
    • D、RMAN would use the control file of the target database to maintain the backup metadata. 
    • E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

    正确答案:D

  • 第16题：

    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

  • 第17题：

    You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）

    • A、flashback logs
    • B、current control file
    • C、control file autobackups
    • D、incremental backup sets

    正确答案:C,D

  • 第18题：

    多选题
    You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）
    A

    flashback logs

    B

    current control file

    C

    control file autobackups

    D

    incremental backup sets


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

  • 第19题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

  • 第20题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


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

  • 第21题：

    多选题
    Using the LIST command in Recovery Manager （RMAN），which two pieces of information in the RMAN repository can be listed？（）
    A

    stored scripts in the recovery catalog

    B

    backups that can be deleted from disk

    C

    backup sets and image copies are obsolete

    D

    backups that do not have the AVAILABLE status in the RMAN repository


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

  • 第22题：

    多选题
    When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）
    A

    create

    B

    import

    C

    load

    D

    sqlimport

    E

    update


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

  • 第23题：

    单选题
    How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）
    A

     Issue the grant command from the SYS user （or equivalent） of the target database.

    B

     Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.

    C

     Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.

    D

     Issue the grant command from RMAN when connected to the recovery catalog-owning schema.

    E

     Issue the grant command from RMAN when connected to the target database.


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

  • 第24题：

    单选题
    You administer an Oracle Database 10g and a third-party database. You use Recovery Manager （RMAN） to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command？（）
    A

     target database

    B

     auxiliary database

    C

     third-party database

    D

     recovery catalog database


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

相关内容