单选题Which command is used to begin a tablespace point-in-time recovery？（）ARestore tablespaceBRecover tablespaceCTablespace recoverDRecover to timeErecover datafile

题目
单选题
Which command is used to begin a tablespace point-in-time recovery？（）
A

 Restore tablespace

B

 Recover tablespace

C

 Tablespace recover

D

 Recover to time

E

 recover datafile

相似考题

1. Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）A、A CHECK constraint is created on the OID column.B、A NOT NULL constraint is created on the OID column.C、The ORDERS table is the only object created in the USERS tablespace.D、The ORDERS table and a unique index are created in the USERS tablespace.E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

2. You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully？ （）A、The database is in NOMOUNT state.B、The database is in ARCHIVELOG mode and the tablespace is online.C、The database is in ARCHIVELOG mode and the tablespace is offline.D、The database is in NOARCHIVELOG mode and the tablespace is online.E、The database is in NOARCHIVELOG mode and the tablespace is offline.

3.When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）A、 The SYSTEM tablespace.B、 The UNDO tablespace.C、 All tablespaces with tables.D、 All tablespaces with indexes.E、 No tablespaces are automatically restored.

4.During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）A、 incomplete namesB、 incomplete names with templatesC、 alias with template namesD、 numeric names

更多“Which command is used to begin a tablespace point-in-time re”相关问题

  • 第1题：

    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

    • A、flash back the database
    • B、perform point-in-time recovery
    • C、perform a full database recovery
    • D、drop and re-create the tablespace
    • E、use Recovery Manager （RMAN） to recover the database

    正确答案:D

  • 第2题：

    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）  

    • A、 alter tablespace DAVE_TBS backup mode
    • B、 alter tablespace DAVE_TBS start backup
    • C、 alter tablespace DAVE_TBS begin backup
    • D、 alter tablespace DAVE_TBS backup begin
    • E、 alter tablespace DAVE_TBS backup

    正确答案:C

  • 第3题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第4题：

    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）

    • A、The database will open, and the tablespace automatically comes out of the backup mode
    • B、The database will be mounted, and recovery must be performed on the USERS tablespace.
    • C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
    • D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

    正确答案:C

  • 第5题：

    多选题
    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
    解析： 暂无解析

  • 第6题：

    多选题
    Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
    A

    A CHECK constraint is created on the OID column.

    B

    A NOT NULL constraint is created on the OID column.

    C

    The ORDERS table is the only object created in the USERS tablespace.

    D

    The ORDERS table and a unique index are created in the USERS tablespace.

    E

    The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.


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

  • 第7题：

    单选题
    To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL> ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）
    A

    The database will open, and the tablespace automatically comes out of the backup mode.

    B

    The database will be mounted, and recovery must be performed on the USERS tablespace.

    C

    The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

    D

    The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.


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

  • 第8题：

    多选题
    You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace：  RMAN> BACKUP TABLESPACE DETTBS；  Under which conditions would this command execute successfully？ （）
    A

    The database is in NOMOUNT state.

    B

    The database is in ARCHIVELOG mode and the tablespace is online.

    C

    The database is in ARCHIVELOG mode and the tablespace is offline.

    D

    The database is in NOARCHIVELOG mode and the tablespace is online.

    E

    The database is in NOARCHIVELOG mode and the tablespace is offline.


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

  • 第9题：

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


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

  • 第10题：

    单选题
    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
    A

     alter tablespace MY_DATA begin backup

    B

     alter tablespace MY_DATA start backup

    C

     alter tablespace MY_DATA backup begin

    D

     alter MY_DATA begin backup

    E

     You cannot back up individual tablespaces


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

  • 第11题：

    单选题
    You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace：   RMAN> BACKUP TABLESPACE TS1 MAXSETSIZE 100M；  Which statement is true about executing this command？（）
    A

     The command generates an error.

    B

     The command backs up the tablespace and creates a backup set of size 200 MB

    C

     The command backs up the tablespace and creates two backup sets of size 100 MB each.

    D

     The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.


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

  • 第12题：

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

  • 第13题：

    What is the proper procedure to recover a lost tempfile？（）  

    • A、 Restore the backup copy of the tempfile from the backup media.
    • B、 Re-create the tempfile with the create tempfile command.
    • C、 Copy an existing tempfile from another database.
    • D、 Re-create the tempfile with the create tablespace command.
    • E、 Re-create the tempfile with the alter tablespace command.

    正确答案:E

  • 第14题：

    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

  • 第15题：

    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）

    • A、alter tablespace DAVE_TBS backup mode
    • B、alter tablespace DAVE_TBS start backup 
    • C、alter tablespace DAVE_TBS begin backup 
    • D、alter tablespace DAVE_TBS backup begin 
    • E、alter tablespace DAVE_TBS backup

    正确答案:C

  • 第16题：

    单选题
    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）
    A

     alter tablespace DAVE_TBS backup mode

    B

     alter tablespace DAVE_TBS start backup

    C

     alter tablespace DAVE_TBS begin backup

    D

     alter tablespace DAVE_TBS backup begin

    E

     alter tablespace DAVE_TBS backup


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

  • 第17题：

    多选题
    Identify three situations in which you would NOT be able to drop a tablespace. （）
    A

    when the tablespace is online

    B

    when the tablespace has segments with data in it

    C

    when the tablespace is a default permanent tablespace for the database

    D

    when the tablespace contains a table that is currently being used by transactions

    E

    when the tablespace contains undo data that is needed to rollback an uncommitted transaction


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

  • 第18题：

    单选题
    You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）
    A

    The MTTR Advisor is disabled.

    B

    The database is in NOARCHIVELOG mode.

    C

    The tablespace is already in backup mode.

    D

    The Flash Recovery Area is not configured


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

  • 第19题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第20题：

    单选题
    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?（）
    A

    alter tablespace DAVE_TBS backup mode

    B

    alter tablespace DAVE_TBS start backup 

    C

    alter tablespace DAVE_TBS begin backup 

    D

    alter tablespace DAVE_TBS backup begin 

    E

    alter tablespace DAVE_TBS backup


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

  • 第21题：

    多选题
    When youre performing a tablespace point-in-time recovery， which tablespaces will always be restored to the auxiliary instance？（）
    A

    The SYSTEM tablespace.

    B

    The UNDO tablespace.

    C

    All tablespaces with tables.

    D

    All tablespaces with indexes.

    E

    No tablespaces are automatically restored.


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

  • 第22题：

    单选题
    Which command is used to begin a tablespace point-in-time recovery？（）
    A

     Restore tablespace

    B

     Recover tablespace

    C

     Tablespace recover

    D

     Recover to time

    E

     recover datafile


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

  • 第23题：

    单选题
    What is the proper procedure to recover a lost tempfile？（）
    A

     Restore the backup copy of the tempfile from the backup media.

    B

     Re-create the tempfile with the create tempfile command.

    C

     Copy an existing tempfile from another database.

    D

     Re-create the tempfile with the create tablespace command.

    E

     Re-create the tempfile with the alter tablespace command.


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

相关内容