多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance.   SQL> STARTUP；   Which two activities are performed during a su

题目
多选题
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance.   SQL> STARTUP；   Which two activities are performed during a successful start up operation？（）
A

The databases configured to use the ASM instance are mounted

B

The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

C

ASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not started

D

ASM discovers and examines the contents of all files that are in the paths specified in the  ASM_DISKGROUPS initialization parameters

相似考题

1.Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks

2.View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

3.Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

4.The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation?（）A. The databases configured to use the ASM instance are mountedB. The disk groups are mounted as per the ASM_DISKGROUPS initialization parameterC. ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedD. ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

更多“多选题The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance.   SQL STARTUP；   Which two activities are performed during a suc”相关问题

  • 第1题：

    During system startup, many applications are starting that are not needed. Which of the following can be used to evaluate all startup applications?（）

    • A、Computer Management Utility
    • B、Add/Remove Programs
    • C、Autoexec.bat file
    • D、MSCONFIG

    正确答案:D

  • 第2题：

    Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）

    • A、The minimum memory size for the database buffer cache is set to 100 mb.
    • B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
    • C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
    • D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

    正确答案:A

  • 第3题：

    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第4题：

    You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）

    • A、 Every SQL statement in the STS is considered only once for execution.
    • B、 The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
    • C、 The execution plan and execution statistics are computed for each SQL statement in the STS. 
    • D、 The effects of DDL and DML are considered to produce the execution plan and execution statistics.

    正确答案:A,C

  • 第5题：

    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

    • A、 OPEN
    • B、 MOUNT
    • C、 NORMAL
    • D、 NOMOUNT

    正确答案:B

  • 第6题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第7题：

    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?（）

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第8题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第9题：

    多选题
    You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）
    A

    Every SQL statement in the STS is considered only once for execution

    B

    The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

    C

    The execution plan and execution statistics are computed for each SQL statement in the STS

    D

    The effects of DDL and DML are considered to produce the execution plan and execution statistics


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

  • 第10题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?（）
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第11题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation? （）(Choose two.)
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters


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

  • 第12题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background proces（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.


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

  • 第13题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第14题：

    Which statement is true about the Manageability Monitor （MMON） background proces（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

    正确答案:A

  • 第15题：

    Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true in this scenario（　）

    • A、The minimum memory size for the database buffer cache is set to 100 mb.
    • B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100mb
    • C、The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
    • D、The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

    正确答案:A

  • 第16题：

    Which two statements about Automatic Storage Management （ASM） are true？（）

    • A、ASM provides mirroring on file by file basis.
    • B、ASM provides automatic load balancing across all ASM disks.
    • C、ASM supports the Oracle database and operating system files.
    • D、ASM can be used to store trace files， alert log files， and the server parameter file （SPFILE）.

    正确答案:A,B

  • 第17题：

    You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

    • A、Every SQL statement in the STS is considered only once for execution
    • B、The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
    • C、The execution plan and execution statistics are computed for each SQL statement in the STS
    • D、The effects of DDL and DML are considered to produce the execution plan and execution statistics

    正确答案:A,C

  • 第18题：

    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

    • A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
    • B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
    • C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
    • D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

    正确答案:D

  • 第19题：

    单选题
    Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）
    A

    When two-way disk mirroring is required for the allocation units

    B

    When three-way disk mirroring is required for the allocation units

    C

    When using hardware mirroring or RAID

    D

    When disk mirroring is required for the Automatic Storage Management (ASM) disks


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

  • 第20题：

    多选题
    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）
    A

    As ASM instance mounts an ASM control file

    B

    An ASM instance uses the ASMB process for rebalancing of disks within a disk group

    C

    Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

    D

    An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


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

  • 第21题：

    多选题
    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management （ASM） instance.   SQL> STARTUP；   Which two activities are performed during a successful start up operation？（）
    A

    The databases configured to use the ASM instance are mounted

    B

    The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

    C

    ASM starts the Oracle Cluster Synchronization Services （CSS） daemon if it is not started

    D

    ASM discovers and examines the contents of all files that are in the paths specified in the  ASM_DISKGROUPS initialization parameters


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

  • 第22题：

    单选题
    You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）
    A

     only the INSTANCE_TYPE initialization parameter is set to an invalid value

    B

     only the ASM_POWER_LIMIT initialization parameter is set to an invalid value

    C

     only the LARGE_POOL_SIZE initialization parameter is set to an invalid value

    D

     both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values


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

  • 第23题：

    单选题
    You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）
    A

     OPEN

    B

     MOUNT

    C

     NORMAL

    D

     NOMOUNT


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

  • 第24题：

    多选题
    You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）
    A

    Every SQL statement in the STS is considered only once for execution.

    B

    The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.

    C

    The execution plan and execution statistics are computed for each SQL statement in the STS.

    D

    The effects of DDL and DML are considered to produce the execution plan and execution statistics.


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

相关内容