网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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 data file location should be on separate disks.DFlash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.” 相关考题
考题
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.
考题
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.
考题
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.
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate?()
A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations
考题
Which setting enables the baselines by default in Oracle Database 11g?()
A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
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.
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)
A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations
考题
The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
考题
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.
考题
The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
考题
What are the different logging modes available in Oracle Database 11g？（） A、 NOLOG modeB、 NOARCHIVELOG modeC、 LOGGING modeD、 HOTDATABASE modeE、 ARCHIVELOG mode
考题
While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software， you are prompted to run orainstRoot.sh script. What does this script accomplish？（）A、It creates the pointer file.B、It creates the base directory.C、It creates the Inventory pointer file.D、It creates the Oracle user for installation.E、It modifies the Unix kernel parameters to match Oracle’s requirement.
考题
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
考题
In Oracle 11g， which recommendations does the SQL Access Advisor generate？（） A、 partitioning recommendationsB、 statistics collection recommendationsC、 index creation recommendationsD、 materialized view recommendationsE、 materialized view log recommendations
考题
In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)A、partitioning recommendationsB、statistics collection recommendationsC、index creation recommendationsD、materialized view recommendationsE、materialized view log recommendations
考题
单选题Which setting enables the baselines by default in Oracle Database 11g?（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor (ADDM)C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations
考题
多选题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?（）AThe source database backup must be copied over the net for test database.BThe source database must be run in ARCHIVELOG mode if the database is open.CThe source database must be shut down cleanly if the database is in mounted state.DA net service name should be set up and a listener configured with the target as well as the source database.
考题
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor （ADDM）C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）A
OracleSIDsonlyB
Oracle homes onlyC
Oracle install timestampD
Oracle inventory pointer filesE
Oracle database creation timestampF
OracleSIDsand Oracle homes onlyG
OracleSIDs， Oracle homes and flag for auto startup
考题
单选题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
1B
2C
3D
4E
1，2，and 4F
1，2，3，and 4
考题
单选题While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software， you are prompted to run orainstRoot.sh script. What does this script accomplish？（）A
It creates the pointer file.B
It creates the base directory.C
It creates the Inventory pointer file.D
It creates the Oracle user for installation.E
It modifies the Unix kernel parameters to match Oracle’s requirement.
考题
多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations
考题
单选题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.
考题
多选题What are the different logging modes available in Oracle Database 11g？（）ANOLOG modeBNOARCHIVELOG modeCLOGGING modeDHOTDATABASE modeEARCHIVELOG mode
热门标签
最新试卷