单选题Which of the following parameters defines the location where Oracle should create archived redo logs?（）A LOG_ARCHIVE_1 B LOG_DESTINATION_1 C LOG_ARCHIVED_DESTINATION_1D LOG_ARCHIVE_DEST_1E LOG_ARCHIVE_SOURCE_1

题目
单选题
Which of the following parameters defines the location where Oracle should create archived redo logs?（）
A

LOG_ARCHIVE_1 

B

LOG_DESTINATION_1 

C

LOG_ARCHIVED_DESTINATION_1

D

LOG_ARCHIVE_DEST_1

E

LOG_ARCHIVE_SOURCE_1

相似考题

1.Which of the following files cannot be backed up by RMAN? ()(Choose all that apply.)A. Database datafilesB. Control filesC. Online redo logsD. Database pfilesE. Archived redo logs

2. You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

3.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs

4. You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

更多“单选题Which of the following parameters defines the location where Oracle should create archived redo logs?（）A LOG_ARCHIVE_1 B LOG_DESTINATION_1 C LOG_ARCHIVED_DESTINATION_1D LOG_ARCHIVE_DEST_1E LOG_ARCHIVE_SOURCE_1”相关问题

  • 第1题：

    Archived redo logs can be copied to more than one destination by Oracle.（）

    • A、 True
    • B、 False

    正确答案:A

  • 第2题：

    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

    • A、Shared pool 
    • B、Control file 
    • C、SGA 
    • D、PGA

    正确答案:B

  • 第3题：

    In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

    • A、Nothing happens
    • B、Oracle will automatically switch redo logs when detected 
    • C、Oracle eventually won't allow new records to be added to the database 
    • D、The instance crashes

    正确答案:C

  • 第4题：

    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

    • A、 13：00 on Tuesday.
    • B、 15：00 on Tuesday.
    • C、 Up until the last available archived redo log on Sunday.
    • D、 To any point； all the redo should still be available in the online redo logs.
    • E、 The database is not recoverable.

    正确答案:E

  • 第5题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第6题：

    Which of the following parameters defines the location where Oracle should create archived redo logs?（）

    • A、LOG_ARCHIVE_1 
    • B、LOG_DESTINATION_1 
    • C、LOG_ARCHIVED_DESTINATION_1
    • D、LOG_ARCHIVE_DEST_1
    • E、LOG_ARCHIVE_SOURCE_1

    正确答案:D

  • 第7题：

    单选题
    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
    A

     multiplexed control files

    B

     RMAN obsolete backups

    C

     multiplexed online redo log files

    D

     archived redo logs that have not been copied to tape


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

  • 第8题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


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

  • 第9题：

    单选题
    Archived redo logs can be copied to more than one destination by Oracle.（）
    A

     True

    B

     False


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

  • 第10题：

    单选题
    Which of the following does the recover command not do？（）
    A

     Restore archived redo logs.

    B

     Apply archived redo logs.

    C

     Restore incremental backups.

    D

     Apply incremental backups.

    E

     Restore datafile images.


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

  • 第11题：

    单选题
    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）
    A

     13：00 on Tuesday.

    B

     15：00 on Tuesday.

    C

     Up until the last available archived redo log on Sunday.

    D

     To any point； all the redo should still be available in the online redo logs.

    E

     The database is not recoverable.


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

  • 第12题：

    单选题
    What will be the result of the following configuration？（）   Log_archive_dest_1=location=c：/oracle/arch/mydb Log_archive_dest_2=location=z：/oracle/arch/mydb
    A

     An error will occur during database startup because the second parameter is not valid.

    B

     An error will occur during database startup since you are trying to create archived redo logs in two different locations.

    C

     Archived redo logs will be created in two different locations by the ARCH process.

    D

     Archived redo logs will be created in two different locations by the LGWR process.

    E

     Neither parameter setting is valid， so the database will not start up.


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

  • 第13题：

    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）

    • A、 The archived redo log files will be overwritten.
    • B、 The archived redo log files are deleted automatically.
    • C、 The archived redo log files should be moved to some other location.
    • D、 The archived redo log files are still maintained because the file names are unique.

    正确答案:D

  • 第14题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第15题：

    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

    • A、 backup database
    • B、 backup database and archivelogs
    • C、 backup database plus archivelogs
    • D、 backup database plus archivelog delete input
    • E、 backup database and archivelog delete input

    正确答案:D

  • 第16题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第17题：

    Which of the following does the recover command not do？（）  

    • A、 Restore archived redo logs.
    • B、 Apply archived redo logs.
    • C、 Restore incremental backups.
    • D、 Apply incremental backups.
    • E、 Restore datafile images.

    正确答案:A

  • 第18题：

    单选题
    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
    A

     backup database

    B

     backup database and archivelogs

    C

     backup database plus archivelogs

    D

     backup database plus archivelog delete input

    E

     backup database and archivelog delete input


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

  • 第19题：

    单选题
    You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）
    A

     The archived redo log files will be overwritten.

    B

     The archived redo log files are deleted automatically.

    C

     The archived redo log files should be moved to some other location.

    D

     The archived redo log files are still maintained because the file names are unique.


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

  • 第20题：

    单选题
    You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）
    A

    Shared pool 

    B

    Control file 

    C

    SGA 

    D

    PGA


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

  • 第21题：

    单选题
    You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）
    A

     The log sequence is reset to 0.

    B

     All the online redo logs are deleted.

    C

     All the archived redo logs from a previous incarnation become useless.

    D

     The full database backup taken from a previous incarnation can be used in future.

    E

     Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.


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

  • 第22题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


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

  • 第23题：

    单选题
    Which of the following parameters defines the location where Oracle should create archived redo logs?（）
    A

    LOG_ARCHIVE_1 

    B

    LOG_DESTINATION_1 

    C

    LOG_ARCHIVED_DESTINATION_1

    D

    LOG_ARCHIVE_DEST_1

    E

    LOG_ARCHIVE_SOURCE_1


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

  • 第24题：

    多选题
    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）
    A

    Flashback logs are not archived.

    B

    Flashback logs are maintained in redo log files.

    C

    Flashback logs are maintained in the Flash Recovery Area.

    D

    Flashback logs are used to maintain Flashback Database related errors.

    E

    Flashback logs need to be cleared manually after you disable Flashback Database.


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

相关内容