itgle.com

多选题The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()ARestore the data file and perform incomplete recovery.BRestore the data file and perform point-in-time recover.CDrop the tablespace and lose a

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


相似考题
更多“The database is running in NOARCHIVELOG mode. A data file is”相关问题
  • 第1题:

    you can perform an active database duplication when the database is in NOARCHIVELOG mode.()

    • A、 True
    • B、 False

    正确答案:B

  • 第2题:

    单选题
    Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
    A

    You can perform open database backups.

    B

    You can perform closed database backups.

    C

    You cannot perform schema-level logical backups.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第3题:

    多选题
    Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file?()
    A

    adding a new user to the database

    B

    dropping a user from the database

    C

    dropping a table from the database

    D

    dropping a data file from a tablespace

    E

    adding a new tablespace to the database


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

  • 第4题:

    单选题
    Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> ()  4. RMAN> ALTER DATABASE OPEN;
    A

    RECOVER DATABASE;

    B

    SWITCH DATAFILE ALL;

    C

    RESTORE CONTROL FILE;

    D

    RECOVER DATABASE USING BACKUP CONTROL FILE;


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

  • 第5题:

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON; command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第6题:

    单选题
    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
    A

    2,4,3

    B

    1,4,3,2

    C

    2,5,4,3,6

    D

    5,2,4,3,6

    E

    1,5,4,3,6,2


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

  • 第7题:

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation?()
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第8题:

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第9题:

    多选题
    Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
    A

    Redo logs

    B

    Control file

    C

    The latest backup of only the damaged data file

    D

    The latest backup of all the data file in the USERS tablespace

    E

    Temporary files of temporary tablespace

    F

    Archive Logs since the latest backup to point of failure


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

  • 第10题:

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file()
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.

    C

    Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.

    D

    Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.


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

  • 第11题:

    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第12题:

    单选题
    Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


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

  • 第13题:

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

  • 第14题:

    多选题
    In RMAN, when the RESYNC CATALOG command is issued, in which two situations does the command file actually perform synchronization?()
    A

    After the COPY command.

    B

    After adding a data file in the target database.

    C

    After adding a tablespace in the target database.

    D

    After adding a tablespace in the catalog database.

    E

    After dropping a data file in the catalog database.

    F

    After running SQL Loader to load a large amount of data.


    正确答案: D,E
    解析: 暂无解析

  • 第15题:

    单选题
    Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database()
    A

    You can perform online whole database backups.

    B

    You can performofflinewhole database backups.

    C

    You cannot perform schema-level export/import operations.

    D

    You can perform the backup of only the SYSTEM tablespace when the database is open.


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

  • 第16题:

    单选题
    you can perform an active database duplication when the database is in NOARCHIVELOG mode.()
    A

     True

    B

     False


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

  • 第17题:

    多选题
    Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
    A

    redo logs

    B

    control file

    C

    temporary files of temporary tablespace

    D

    the latest backup of only the damaged data file

    E

    the latest backup of all the data files In the USERS tablespace


    正确答案: A,B,D
    解析: 暂无解析

  • 第18题:

    单选题
    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file()
    A

    Take the USERS tablespace offline and re-create the lost data file.

    B

    Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.

    C

    Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.

    D

    Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online


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

  • 第19题:

    单选题
    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified?()
    A

     only the control file, the current SPFILE, and data files

    B

     only the current SPFILE and data files if autobackup is disabled

    C

     only the data files and the archived redo logs

    D

     the control file,current SPFILE file,data files,and archived redo logs


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

  • 第20题:

    单选题
    You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file?()
    A

    Restore all the data files and open the database

    B

    Create the data file and performtablespacerecovery

    C

    No need to restore any file, just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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