单选题The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below：   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archi

题目
单选题
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below：   LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’   Examine the following RMAN command issued to set the deletion policy for archived log files：   RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt； Which statement is true regarding what this command accomplishes？（）
A

 All archived redo log files backed up at least twice to tape are deleted.

B

 All archived redo log files backed up at least once to tape are eligible for deletion.

C

 All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

D

 All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

相似考题

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.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

3.You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

4.You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?()A. The source database backup must be copied over the net for test database.B. The source database must be run in ARCHIVELOG mode if the database is open.C. The source database must be shut down cleanly if the database is in mounted state.D. A net service name should be set up and a listener configured with the target as well as the source database.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“The Oracle Database 11g database is running in the ARCHIVELO”相关问题

  • 第1题：

    You work as a database administrator for Certkiller .com. 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

    正确答案:C,D

  • 第2题：

    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

  • 第3题：

    You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

    • A、The ASM compatibility attribute controls the format of the disk group metadata.
    • B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
    • C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
    • D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
    • E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

    正确答案:A,B,D

  • 第4题：

    You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）

    • A、2
    • B、3
    • C、1 and 2
    • D、3 and 4
    • E、1，2，and 4

    正确答案:E

  • 第5题：

    In a new installation of Oracle Database 11g， you perform these activities：  1：Organize software and data on different subdirectories to avoid poor performance.  2：Use consistent naming conventions for database files.  3：Separate administrative information pertaining to the database in different directories.  Which option corresponds to the type of activities you performed（）

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture
    • E、Automatic Storage Management

    正确答案:C

  • 第6题：

    单选题
    Which setting enables the baselines by default in Oracle Database 11g?（）
    A

    setting the STATISTICS_LEVEL parameter to TYPICAL

    B

    adding filters to the Automatic Database Diagnostic Monitor (ADDM)

    C

    enabling Automated Maintenance Task using Oracle Enterprise Manager

    D

    setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


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

  • 第7题：

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

  • 第8题：

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

  • 第9题：

    多选题
    You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
    A

    The source database backup must be copied over the net for test database.

    B

    The source database must be run in ARCHIVELOG mode if the database is open.

    C

    The source database must be shut down cleanly if the database is in mounted state.

    D

    A net service name should be set up and a listener configured with the target as well as the source database.


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

  • 第10题：

    单选题
    Which setting enables the baselines by default in Oracle Database 11g？（）
    A

     setting the STATISTICS_LEVEL parameter to TYPICAL

    B

     adding filters to the Automatic Database Diagnostic Monitor （ADDM）

    C

     enabling Automated Maintenance Task using Oracle Enterprise Manager

    D

     setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE


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

  • 第11题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g：  1：It enables the high-speed transfer of data from one database to another.  2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database.  3：It enables the loading of data from an external file into an Oracle database.  4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1，2，and 4

    F

    1，2，3，and 4


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

  • 第12题：

    多选题
    What are the different logging modes available in Oracle Database 11g？（）
    A

    NOLOG mode

    B

    NOARCHIVELOG mode

    C

    LOGGING mode

    D

    HOTDATABASE mode

    E

    ARCHIVELOG mode


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

  • 第13题：

    Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）  

    • A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.
    • B、 The problem key is the same as the incident number.
    • C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
    • D、 Every problem has a problem key， which is a text string that describes the problem.
    • E、 The database makes an entry into the alert log file when problems and incidents occur.

    正确答案:C,D,E

  • 第14题：

    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

    • A、 The audit trail is stored in an operating system file.
    • B、 Auditing is disabled for all privileges.
    • C、 The audit trail is stored in the database.
    • D、 Auditing is enabled for all privileges.
    • E、 Auditing is enabled for certain privileges related to database security.

    正确答案:C,E

  • 第15题：

    What are the different logging modes available in Oracle Database 11g？（） 

    • A、 NOLOG mode
    • B、 NOARCHIVELOG mode
    • C、 LOGGING mode
    • D、 HOTDATABASE mode
    • E、 ARCHIVELOG mode

    正确答案:B,E

  • 第16题：

    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

  • 第17题：

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

  • 第18题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）
    A

    Multiplex all database files.

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter


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

  • 第19题：

    单选题
    Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem.  Which point describes the Oracle Data Pump utility（）
    A

    1

    B

    2

    C

    3

    D

    4

    E

    1 and 3

    F

    1， 2， 3， and 4


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

  • 第20题：

    单选题
    Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?（）
    A

    The database must be running in ARCHIVELOG mode.

    B

    No special setup is required, and the feature is enabled by default.

    C

    The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.

    D

    The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.

    E

    Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.


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

  • 第21题：

    单选题
    You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）
    A

    Multiplex all database files

    B

    Configure the Flash Recovery Area.

    C

    Configure the database instance for ARCHIVELOG mode.

    D

    Configure the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第22题：

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

  • 第23题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）
    A

     It must be executed from the Oracle Database 11g environment.

    B

     It must be executed only after the SYSAUX tablespace has been created.

    C

     It must be executed from the environment of the database that is being upgraded.

    D

     It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

     It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


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

  • 第24题：

    单选题
    You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）
    A

    2

    B

    3

    C

    1 and 2

    D

    3 and 4

    E

    1，2，and 4


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

相关内容