niusouti.com

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’

题目

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.
相似考题

1.Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()A. Oracle Net ManagerB. Listener Control utilityC. Database Configuration AssistantD. Oracle Net Configuration Assistant

2. Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）A、the retention period to support flashbackB、the expected length of the longest-running queryC、the number of undo tablespaces in the databaseD、the size of the Flash Recovery Area for the database instance

3.Which view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG

4.You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = ‘LOCATION = /disk1/archive’DB_RECOVERY_FILE_DEST_SIZE = 50GDB_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.

更多“You database is running an ARCH”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    单选题
    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

    Memory Advisors

    B

    Segment Advisors

    C

    SQL Tuning and Access Advisors

    D

    Automated Workload Repository （AWR）

    E

    Automatic Database Diagnostic Monitor （ADDM）


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

  • 第5题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to  performRecovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure.


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

  • 第6题：

    单选题
    Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
    A

    Oracle Net Manager

    B

    Listener Control utility

    C

    Database Configuration Assistant

    D

    Oracle Net Configuration Assistant


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

  • 第7题：

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

  • 第8题：

    单选题
    You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）
    A

    Place each database in a separate instance running on SQL2.

    B

    Place each database in a separate instance running on SQL3.

    C

    Place both databases in a single instance running on SQL2.

    D

    Place both databases in a single instance running on SQL3.


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

  • 第9题：

    多选题
    You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）
    A

    The backups would be consistent.

    B

    The backups would be inconsistent.

    C

    The backups would be possible only if the database is running in ARCHIVELOG mode.

    D

    The backups would be possible only if the database is running in NOARCHIVELOG mode.

    E

    The backups need to be restored and the database has to be recovered in case of a media failure


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

  • 第10题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第11题：

    多选题
    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
    A

    Application Server Control

    B

    Oracle Management Service

    C

    Oracle Enterprise Manager Repository

    D

    Oracle Enterprise Manager Database Control


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

  • 第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.


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

  • 第13题：

    You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）

    • A、The backups would be consistent.
    • B、The backups would be inconsistent.
    • C、The backups would be possible only if the database is running in ARCHIVELOG mode.
    • D、The backups would be possible only if the database is running in NOARCHIVELOG mode.
    • E、The backups need to be restored and the database has to be recovered in case of a media failure

    正确答案:B,C,E

  • 第14题：

    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）

    • A、You should perform a log switch
    • B、You should make a backup of the database
    • C、You should switch the database to the NONARCHIVELOG mode
    • D、You should shut down the database instance and perform a complete database recovery

    正确答案:B

  • 第15题：

    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）

    • A、 Oracle Net Manager
    • B、 Listener Control utility
    • C、 Database Configuration Assistant
    • D、 Oracle Net Configuration Assistant

    正确答案:B

  • 第16题：

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

  • 第17题：

    单选题
    Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）
    A

     Oracle Net Manager

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第18题：

    单选题
    You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance：   LOG_ARCHIVE_DEST 1 = ，，LOCATION=/disk1/arch MANDATORY’  LOG _ARCHIEVE_DEST 2 = ，，LOCATION=/disk2/arch’ LOG_ARCHIVK_DEST_3 = ，，LOCATION=/diSk3/arch  LOG_ARCH1VK_DEST_4 = ’ LOCATION=/disk4/arch’  LOG_ARCHIVE_MIN-SUCCEED_DEST = 2   While the database instance is functional，you realized that the destination set by the  LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.  What happens in an event of log switch？（）
    A

     The online redo log file Is not allowed to be overwritten.

    B

     The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

    C

     The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

    D

     The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.


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

  • 第19题：

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

  • 第20题：

    单选题
    The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）
    A

    Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

    B

    Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

    C

    Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

    D

    Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.


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

  • 第21题：

    单选题
    Which view will you use to view information regarding the jobs that are currently running in a database？（）
    A

    DBA_SCHEDULER_RUNNING_JOBS

    B

    DBA_SCHEDULER_JOB_RUN_DETAILS

    C

    DBA_SCHEDULER_JOBS

    D

    DBA_SCHEDULER_JOB_LOG


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

  • 第22题：

    多选题
    Half of your network uses RIPv2 and the other half runs OSPF. The networks do not communicate with each other. Which two of these factors describe the impact of activating EIGRP over each separate part？（）
    A

    EIGRP will not be accepted when configured on the actual RIPv2 routers.

    B

    OSPF will no longer be used in the routing table， because you only have EIGRP internal routes running.

    C

    OSPF will no longer be used in the routing table， because you only have EIGRP external routes running.

    D

    RIPv2 will populate its RIP database but not its routing table， because you only have EIGRP external routes running.

    E

    RIPv2 will populate its RIP database but not its routing table， because you only have EIGRP internal routes running.

    F

    OSPF database will have RIPv2 routes.


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

  • 第23题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）
    A

     You should perform a log switch

    B

     You should make a backup of the database

    C

     You should switch the database to the NONARCHIVELOG mode

    D

     You should shut down the database instance and perform a complete database recovery


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

相关内容