多选题What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()AORACLE_BASE should be set explicitly.BAn Oracle base should have only one Oracle home created in it.CFlash recovery area and d

题目
多选题
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()
A

ORACLE_BASE should be set explicitly.

B

An Oracle base should have only one Oracle home created in it.

C

Flash recovery area and data file location should be on separate disks.

D

Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.


相似考题
更多“多选题What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()AORACLE_BASE should be set explicitly.BAn Oracle base should have only one Oracle home created in it.CFlash recovery area and d”相关问题
  • 第1题:

    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?()

    • A、 The Oracle database will not perform block checking for any of the data blocks.
    • B、 The Oracle database will perform block checking for the default permanent tablespace only. 
    • C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.
    • D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
    • E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

    正确答案:D

  • 第2题:

    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.

    正确答案:C

  • 第3题:

    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 optioncorresponds 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

  • 第4题:

    While planning to manage more than one database in your system, you perform the following activities:  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you?()

    • A、Oracle Managed Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture

    正确答案:C

  • 第5题:

    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?()   The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn’t set  

    • A、 then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn’t set,
    • B、 then it is set to $ORACLE_HOME
    • C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
    • D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

    正确答案:B

  • 第6题:

    You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()

    • A、ORA_PATH
    • B、ORACLE_SID
    • C、ORACLE_BASE
    • D、ORACLE_HOME
    • E、LD_LIBRARY_PATH

    正确答案:B

  • 第7题:

    单选题
    Which is the correct description of the significance of the ORACLE_HOME environmental variable?()
    A

    It specifies the directory containing the Oracle software.

    B

    It specifies the directory containing the Oracle-Managed Files.

    C

    It specifies the directory for database files, if not specified explicitly.

    D

    It specifies the base directory of Optimal Flexible Architecture (OFA) .


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

  • 第8题:

    多选题
    While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?()
    A

    An entry is created in the alert log file and the database instance continues to function normally

    B

    The log switch hangs occur for transactions until free space is available in the flash recovery area

    C

    The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle

    D

    The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented


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

  • 第9题:

    单选题
    You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()
    A

    ORA_PATH

    B

    ORACLE_SID

    C

    ORACLE_BASE

    D

    ORACLE_HOME

    E

    LD_LIBRARY_PATH


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

  • 第10题:

    单选题
    You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()
    A

    The ORACLE_BASE base parameter is not set.

    B

    The installation is being performed by the root user.

    C

    The operating system group that is specified should have the root user as its member.

    D

    The operating system group that is specified must have permission to write to the inventory directory


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

  • 第11题:

    单选题
    Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?()   The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn’t set
    A

     then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE; if $ORACLE_BASE isn’t set,

    B

     then it is set to $ORACLE_HOME

    C

     DIAGNOSTIC_DEST is always equal to $ORACLE_HOME

    D

     DIAGNOSTIC_DEST is always equal to $ORACLE_BASE


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

  • 第12题:

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


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

  • 第13题:

    What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()

    • A、 ORACLE_BASE should be set explicitly.
    • B、 An Oracle base should have only one Oracle home created in it.
    • C、 Flash recovery area and data file location should be on separate disks.
    • D、 Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

    正确答案:A,C,D

  • 第14题:

    During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()

    • A、The installation terminates with an error.
    • B、The installation proceeds with the default value without warnings and errors.
    • C、The installation proceeds with the default value but it would not be an OFA-compliant database.
    • D、The installation proceeds with the default value but a message would be generated in the alert log file.

    正确答案:D

  • 第15题:

    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()

    • A、The Oracle kernel will be placed in this location.
    • B、The Oracle software will be placed in this location.
    • C、The server parameter file (SPFILE) will be placed in this location.
    • D、The database files will be placed in this location, if not specified explicitly.
    • E、The location will be considered for the base of Oracle Managed Files (OMF).
    • F、The location will be considered for the base of Optimal Flexible Architecture (OFA).

    正确答案:F

  • 第16题:

    You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?()

    • A、The ORACLE_BASE base parameter is not set.
    • B、The installation is being performed by the root user.
    • C、The operating system group that is specified should have the root user as its member.
    • D、The operating system group that is specified must have permission to write to the inventory directory

    正确答案:D

  • 第17题:

    In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN> RUN 2> { 3> ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4> BACKUP DATABASE; 5> } Which statement is true about the outcome?()

    • A、Only one channel is allocated and the backup is created in the flash recovery area
    • B、Only one channel is allocated and the backup is created in the destination specified for channel 1
    • C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
    • D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

    正确答案:A

  • 第18题:

    You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case()

    • A、The ORACLE_BASE parameter is not set.
    • B、The installation is being performed by the root user.
    • C、The operating system group that will be specified should have root user as its member.
    • D、The installation is being performed without the "Create Starter Database" option selected.
    • E、The operating system group that will be specified must have permission to write to the inventory directory

    正确答案:E

  • 第19题:

    多选题
    What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant?()
    A

    ORACLE_BASE should be set explicitly.

    B

    An Oracle base should have only one Oracle home created in it.

    C

    Flash recovery area and data file location should be on separate disks.

    D

    Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.


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

  • 第20题:

    单选题
    You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case()
    A

    The ORACLE_BASE parameter is not set.

    B

    The installation is being performed by the root user.

    C

    The operating system group that will be specified should have root user as its member.

    D

    The installation is being performed without the Create Starter Database option selected.

    E

    The operating system group that will be specified must have permission to write to the inventory directory


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

  • 第21题:

    单选题
    During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()
    A

    The installation terminates with an error.

    B

    The installation proceeds with the default value without warnings and errors.

    C

    The installation proceeds with the default value but it would not be an OFA-compliant database.

    D

    The installation proceeds with the default value but a message would be generated in the alert log file.


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

  • 第22题:

    单选题
    During the installation of Oracle Database 11g,you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation?()
    A

     The installation terminates with an error.

    B

     The installation proceeds with the default value without warnings and errors.

    C

     The installation proceeds with the default value but it would not be an OFA-compliant database.

    D

     The installation proceeds with the default value but a message would be generated in the alert log file.


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

  • 第23题:

    单选题
    You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()
    A

    The Oracle kernel will be placed in this location.

    B

    The Oracle software will be placed in this location.

    C

    The server parameter file (SPFILE) will be placed in this location.

    D

    The database files will be placed in this location, if not specified explicitly.

    E

    The location will be considered for the base of Oracle Managed Files (OMF).

    F

    The location will be considered for the base of Optimal Flexible Architecture (OFA).


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

  • 第24题:

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


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