网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()
A
Automatic PGA Memory Management
B
Automatic SGA Memory Management
C
Automatic Shared Memory Management
D
Automatic Memory Management
E
Manual SGA Memory Management
F
None of the above
参考答案
参考解析
解析:
暂无解析
更多 “单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above” 相关考题
考题
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.
考题
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.
考题
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 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
考题
You are configuring for Oracle Shared Server. Which service is required? ()A、Oracle Net ServiceB、Oracle HTTP ServiceC、Oracle Paging ServiceD、Internet Directory Service
考题
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.
考题
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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
考题
Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()A、 If you select a non-XA JDBC driver, you can use WebLogic AQ JMS in both local global transactionsB、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSC、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerD、 If you select an XA JDBC driver, you can use WebLogic AQ JMS in both local and global transactions
考题
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).
考题
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
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.
考题
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
考题
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?() A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
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
考题
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
考题
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
考题
Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g?() A、 Generate reports on data failure such as data file failures.B、 You can track the Service Request (SR) and implement repairs.C、 You can package and upload diagnostic data to Oracle Support.D、 You can manually run health checks to gather diagnostic data for a problem.
考题
单选题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
考题
单选题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 filesB
Configure the Flash Recovery Area.C
Configure the database instance for ARCHIVELOG mode.D
Configure the FAST_START_MTTR_TARGET initialization parameter.
考题
单选题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()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 inventorydirectory.
考题
单选题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.
考题
单选题For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?()A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题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()A
2B
3C
1 and 2D
3 and 4E
1,2,and 4
热门标签
最新试卷