itgle.com

多选题Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago, you just archived arch_4.arch to tape, then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.ar

题目
多选题
Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago, you just archived arch_4.arch to tape, then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.arc in the archive directory.  Which two could you happened?()
A

Redo logs were restored from tape for recovery.

B

The file names are only used when they are copied to tape.

C

The database was opened with the RESETLOGS option and log numbers restarted.

D

Log names run in circular fashion; arch_3.arc is re-created by the ARCn process.

E

A file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.


相似考题
更多“Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s”相关问题
  • 第1题:

    An administrator is configuring a new cluster and has a requirement for a notification to be generated if the /tmp File System becomes greater than 90% full. Which of the following PowerHA components will support theadministrator’s requirement?()

    • A、Pre-defined Events
    • B、User-defined Events
    • C、Remote notification methods
    • D、The integration between RMC and WebSM

    正确答案:B

  • 第2题:

    The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files()

    • A、It will be created on the local file system.
    • B、It will be created only in the Flash Recovery Area.
    • C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.
    • D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.

    正确答案:A

  • 第3题:

    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

  • 第4题:

    In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this? ()

    • A、%t_%s.dbf
    • B、arch_%t.arc
    • C、arch_%d.arc
    • D、arch_%t_%d.arc
    • E、arch_%d_%s_.dbf
    • F、arch_%t_%s_%r.arc

    正确答案:F

  • 第5题:

    Which statement is true regarding remote archive log file destinations?()

    • A、Only two destinations per remote database can be specified.
    • B、Destination is an Oracle Net alias specified by using the SERVICE keyword.
    • C、The REOPEN attribute must be used when using remote archive log file destinations.
    • D、The service name is resolved by searching sqlnet.ora file for the remote database name.

    正确答案:B

  • 第6题:

    You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log?()

    • A、LOG_ARCHIVE_DEST was not set in the parameter file.
    • B、LOG_ARCHIVE_START was not set in the parameter file.
    • C、alter database archivelog; was not executed in MOUNT mode.
    • D、LOG_ARCHIVE_MAX processes were not set in the parameter file.

    正确答案:B

  • 第7题:

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

  • 第8题:

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()
    A

     LARGE_POOL_SIZE

    B

     DB_CREATE_FILE_DEST

    C

     LOG_ARCHIVE_DEST

    D

     CONTROL_FILES

    E

     LOG_ARCHIVE_FORMAT

    F

     DB_BLOCK_SIZE


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

  • 第9题:

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


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

  • 第10题:

    单选题
    When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()
    A

    RMAN keeps a list of archive logs in a text file.

    B

    The DBA must manually tell RMAN which archive logs to backup.

    C

    RMAN has access to target control file and/or catalog information.

    D

    RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.


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

  • 第11题:

    多选题
    Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago, you just archived arch_4.arch to tape, then removed all archived files to save disk space. Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.arc in the archive directory.  Which two could you happened?()
    A

    Redo logs were restored from tape for recovery.

    B

    The file names are only used when they are copied to tape.

    C

    The database was opened with the RESETLOGS option and log numbers restarted.

    D

    Log names run in circular fashion; arch_3.arc is re-created by the ARCn process.

    E

    A file name is randomly chosen by the archive process; as long as it is unique, it does not have to be sequential.


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

  • 第12题:

    单选题
    The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server:  LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc  LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’  DB_RECOVERY_FILE_DEST = ’/u01/oradata’  DB_RECOVERY_FILE_DEST_SIZE = 20G  Which statement is true regarding the archived redo log files()
    A

    It will be created on the local file system.

    B

    It will be created only in the Flash Recovery Area.

    C

    It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.

    D

    It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.


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

  • 第13题:

    Which of the following are TRUE about a store archive?()

    • A、It is an XML file containing store data assets
    • B、It uses the same file format as a ZIP file
    • C、It contains file assets to create a store or site
    • D、It can easily be copied from one machine to another
    • E、It can contain WebSphere Commerce instance configuration information

    正确答案:B,C,D

  • 第14题:

    You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format?() 

    • A、to uniquely identify the archived log files with the restore operation
    • B、to uniquely identify the archived log files with the redo log group number
    • C、to uniquely identify the archived log files for each incarnation of the database
    • D、to uniquely identify the archived log files with the number of recovery operations performed

    正确答案:C

  • 第15题:

    A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy.    What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?()

    • A、Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.
    • B、Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.
    • C、Keep environmental data in the database because it is the most effective way of parametrizing the environment.  
    • D、Keep archive in exploded format so the customer does not have to open the archive files.
    • E、Eliminate all environmental settings from the application. There should not to be any environmental settings in the application. 

    正确答案:B

  • 第16题:

    Which backup option defines a user-defined name for a backup? ()

    • A、FORMAT
    • B、NAME
    • C、TAG
    • D、FORMAT U%

    正确答案:C

  • 第17题:

    You have some compressed bitmap files in a directory of your Windows 2000 Professional computer. The file compression has reduced their size from 2 MB to 1 MB. You attempt to copy them to a floppy disk, but an error reports that the destination drive is full.  How can you copy the bitmap files to a 1.44 MB floppy disk? ()

    • A、Use a third-party file compression utility to create a compressed archive containing the bitmap files. Copy the compressed archive to the floppy disk.
    • B、Create an empty compressed folder on the floppy disk, and copy the files to the new folder.
    • C、Format the floppy disk as NTFS, and restart the copy operation.
    • D、Confirm that the cluster size on the NTFS volume is greater than 32k.

    正确答案:A

  • 第18题:

    单选题
    You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving.  Which step was skipped when you set up automatic archive log?()
    A

    LOG_ARCHIVE_DEST was not set in the parameter file.

    B

    LOG_ARCHIVE_START was not set in the parameter file.

    C

    alter database archivelog; was not executed in MOUNT mode.

    D

    LOG_ARCHIVE_MAX processes were not set in the parameter file.


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

  • 第19题:

    单选题
    The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters. Which statement is correct in this scenario?()
    A

     If the FORMAT option to the RMAN BACKUP command is specified, then RMAN creates backup pieces and image copies in the flash recovery area with names in the Oracle Managed Files (OMF) format.

    B

     If any local destinations for LOG_ARCHIVE_DEST_n are set, then archived redo logs are stored in these destinations as well as in the flash recovery area.

    C

     If the flash recovery area location is configured using the DB_RECOVERY_FILE_DEST initialization parameter, then the RMAN backup of Oracle managed datafiles (OMF) only will go to the flash recovery area by default.

    D

     If no other destination is configured for recovery files, then RMAN places the control file autobackups in the flash recovery area by default.


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

  • 第20题:

    多选题
    Which of the following are TRUE about a store archive?()
    A

    It is an XML file containing store data assets

    B

    It uses the same file format as a ZIP file

    C

    It contains file assets to create a store or site

    D

    It can easily be copied from one machine to another

    E

    It can contain WebSphere Commerce instance configuration information


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

  • 第21题:

    单选题
    The database is configured for automatic archive logging. Along with the other required parameters, this entry is in the initialization file:log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1?()
    A

    control file

    B

    tnsnames.ora

    C

    data dictionary

    D

    initialization parameter file


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

  • 第22题:

    单选题
    You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = ‘/u01/oradata’ Which statement is true about the archived redo log files?()
    A

    They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

    B

    They are created only in the Fast Recovery Area.

    C

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.

    D

    They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.


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

  • 第23题:

    单选题
    You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database:  INSTANCE_TYPE = RDBMS DB_NAME = PROD  LARGE_POOL_SIZE = 8MB  DB_BLOCK_SIZE = 4K  LOG_ARCHIVE_DEST = +dgroupA  LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t"  DB_CREATE_FILE_DEST = +dgroupA  COMPATIBLE = 10.1.0.2.0  CONTROL_FILES = +dgroupA  Which parameter would be ignored while starting up the instance for the database PROD?()
    A

    DB_BLOCK_SIZE

    B

    CONTROL_FILES

    C

    LARGE_POOL_SIZE

    D

    LOG_ARCHIVE_DEST

    E

    LOG_ARCHIVE_FORMAT

    F

    DB_CREATE_FILE_DEST


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

  • 第24题:

    单选题
    You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format?()
    A

    to uniquely identify the archived log files with the restore operation

    B

    to uniquely identify the archived log files with the redo log group number

    C

    to uniquely identify the archived log files for each incarnation of the database

    D

    to uniquely identify the archived log files with the number of recovery operations performed


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