单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）ATrueBFalse

题目
单选题
you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）
A

 True

B

 False

相似考题

1.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

2.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 commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.

3.Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

4. Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）A  TrueB  False”相关问题

  • 第1题：

    Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

    • A、The destination must be global only.
    • B、A maximum of five destinations can be assigned.
    • C、A maximum of ten different destinations can be assigned.
    • D、All the destinations are determined by the server automatically.
    • E、The destination may be local or remote for a Standby Database.
    • F、The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

    正确答案:C,E

  • 第2题：

    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.

    正确答案:B

  • 第3题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、backup of offline tablespaces
    • B、backup of read­only tablespaces
    • C、backup of system­critical tablespaces
    • D、backup of online， locally managed tablespaces
    • E、backup of read/write dictionary­managed tablespaces

    正确答案:A,B

  • 第4题：

    In which two cases would you perform only consistent backup？（）

    • A、You are working on a database where downtime is not tolerated.
    • B、You are working on a database where downtime can be tolerated.
    • C、You are working on a database that operates in ARCHIVELOG mode.
    • D、You are working on a database that operates in NOARCHIVELOG mode.
    • E、You are working on a database where all the tablespaces are locally managed.
    • F、You are working on a database where control files and redo log files are multiplexed.
    • G、You are working on a database where control files and redo log files are not multiplexed.

    正确答案:B,D

  • 第5题：

    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第6题：

    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.

    正确答案:B

  • 第7题：

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
    A

     Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第8题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第9题：

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


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

  • 第10题：

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


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

  • 第11题：

    多选题
    Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario？（）
    A

    The instance aborts.

    B

    The database cannot be recovered.

    C

    The database can be recovered by restoring the control files from the backup.

    D

    The database remains opened and you have to shut it down with the ABORT option.

    E

    The database can be restored till the point of the last closed whole database backup.


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

  • 第12题：

    单选题
    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）
    A

     Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.

    B

     Just back up the database datafiles without shutting down the database.

    C

     You will have to wait until you can shut down the database to perform the backup.

    D

     Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.

    E

     Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup


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

  • 第13题：

    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

    • A、You must shut down the database instance to perform the backups.
    • B、You must configure the Flash Recovery Area （FRA） for the database.
    • C、You can perform complete database backups without closing the database.
    • D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

    正确答案:C,D

  • 第14题：

    Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

    • A、 Backup of offline tablespaces.
    • B、 Backup of read-only tablespaces.
    • C、 Backup of system-critical tablespaces.
    • D、 Backup of online， locally managed tablespaces.
    • E、 Backup of read/write dictionary-managed tablespaces.

    正确答案:A,B

  • 第15题：

    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

    • A、You can perform consistent backups only.
    • B、You can perform a complete database backup without shutting down the database instance.
    • C、You can back up data files only when all data files have the same SCN recorded in the control file.
    • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

    正确答案:B,D

  • 第16题：

    Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）  

    • A、 Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs.
    • B、 Just back up the database datafiles without shutting down the database.
    • C、 You will have to wait until you can shut down the database to perform the backup.
    • D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
    • E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backup

    正确答案:C

  • 第17题：

    you can perform an active database duplication when the database is in NOARCHIVELOG mode.（）

    • A、 True
    • B、 False

    正确答案:B

  • 第18题：

    多选题
    You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）
    A

    You must shut down the database instance to perform the backups.

    B

    You must configure the Flash Recovery Area （FRA） for the database.

    C

    You can perform complete database backups without closing the database.

    D

    All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.


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

  • 第19题：

    单选题
    You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
    A

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

    B

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    C

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    D

     Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.


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

  • 第20题：

    多选题
    You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）
    A

    You must shut down the database instance to perform the backups.

    B

    You must configure the Flash Recovery Area （FRA） for the database.

    C

    You can perform complete database backups without closing the database.

    D

    All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.


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

  • 第21题：

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

  • 第22题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.


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

  • 第23题：

    多选题
    Which two statements are true regarding the database in ARCHIVELOG mode？（）
    A

    You have to shut down the database to perform the backups.

    B

    Archiving information is written to the data files and redo log files.

    C

    You can perform complete database backups without closing the database.

    D

    Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.

    E

    All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.


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

相关内容