单选题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（）AOracle Managed FilesBOracle Grid ArchitectureCOptimal Flexible ArchitectureDOracle database architectureEAutomatic Storage Management
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?() A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the data blocksC. The Oracle database will perform block checking for the default permanent tablespace onlyD. The Oracle database will perform block checking for the data blocks in all user tablespacesE. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
What are two benefits of installing Grid Infrastructure software for a stand－alone server before installing and creating an Oracle database?() A. Effectively implements role separationB. Enables you to take advantage of Oracle Managed Files.C. Automatically registers the database with Oracle Restart.D. Helps you to easily upgrade the database from a prior release.E. Enables the Installation of Grid Infrastructure files on block or raw devices.
Which statement is true about the database and database-user used during installation of IMS Server？（）A、A preexisting database user may be used but a new database has to be created during installation.B、A preexisting database may be used but a new database user has to be created during installation.C、A preexisting database and user may be used or a new database and user are created during installation.D、A preexisting database and user cannot be used； a new database and user are created during installation.
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.
The DB_BLOCK_CHECKING initialization parameter is set to OFF. 数据库块检测初始化参数被设定为关 Which block checking would be performed?（）A、The Oracle database will perform block checking for the index blocks only B、The Oracle database will not perform block checking for any of the data blocks C、The Oracle database will perform block checking for the default permanent tablespace only D、The Oracle database will perform block checking for the data blocks in all user tablespaces E、The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only Oracle
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 FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architecture
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.
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（） A、 The Oracle database will perform block checking for the index blocks onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
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、2B、3C、1 and 2D、3 and 4E、1，2，and 4
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）A、to minimize plan regression due to the use of a new optimizer versionB、to completely avoid the use of new plans generated by a new optimizer versionC、to prevent plan capturing when the SQL statement is executed after the database upgradeD、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
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 FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management
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
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题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（）AMultiplex all database files.BConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）A The Oracle database will perform block checking for the index blocks onlyB The Oracle database will not perform block checking for any of the data blocksC The Oracle database will perform block checking for the default permanent tablespace onlyD The Oracle database will perform block checking for the data blocks in all user tablespacesE The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
多选题What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）AEffectively implements role separationBEnables you to take advantage of Oracle Managed Files.CAutomatically registers the database with Oracle Restart.DHelps you to easily upgrade the database from a prior release.EEnables the Installation of Grid Infrastructure files on block or raw devices.
单选题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（）AMultiplex all database filesBConfigure the Flash Recovery Area.CConfigure the database instance for ARCHIVELOG mode.DConfigure the FAST_START_MTTR_TARGET initialization parameter.
单选题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（）AOracle Managed FilesBOracle Grid ArchitectureCOptimal Flexible ArchitectureDOracle database architectureEAutomatic Storage Management
单选题You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. Which statement is true in this case（）AThe ORACLE_BASE parameter is not set.BThe installation is being performed by the root user.CThe operating system group that will be specified should have root user as its member.DThe installation is being performed without the Create Starter Database option selected.EThe operating system group that will be specified must have permission to write to the inventorydirectory.
单选题You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used
单选题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.
单选题Which statement is true about the database and database-user used during installation of IMS Server？（）AA preexisting database user may be used but a new database has to be created during installation.BA preexisting database may be used but a new database user has to be created during installation.CA preexisting database and user may be used or a new database and user are created during installation.DA preexisting database and user cannot be used； a new database and user are created during installation.
单选题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.
单选题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（）A2B3C1 and 2D3 and 4E1，2，and 4
单选题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（）AOracle Managed FilesBOracle Grid ArchitectureCOptimal Flexible ArchitectureDOracle database architectureEAutomatic Storage Management