网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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 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.

考题 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.

考题 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

考题 You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature

考题 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.

考题 If you create your database using Oracle Managed Files (OMF), what is true?()A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

考题 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 write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? ()A、On the Oracle server. B、Locally in each form module. C、In an attached PL/SQL library D、On your file network server.

考题 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

考题 单选题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()A SYSTEM B OUTLN C INTERNAL D SYS

考题 单选题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()A Multiplex all database files.B Configure the Flash Recovery Area.C Configure the database instance for ARCHIVELOG mode.D Configure the FAST_START_MTTR_TARGET initialization parameter

考题 单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

考题 单选题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 write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? ()A On the Oracle server. B Locally in each form module. C In an attached PL/SQL library D On your file network server.

考题 多选题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 maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()A  by using the RMAN utilityB  by using the export/import utilityC  by using the ALTER DATABASE commandD  by enabling the change tracking feature

考题 单选题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 using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A use the external table populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

考题 多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective?()ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.

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