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 b

题目

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

1.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

2.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

3.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.

4.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 1”相关问题

  • 第1题：

    You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are： 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management （ASM） for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

    • A、4 and 6
    • B、2，3，4，and 6
    • C、1，2，4，5，and 6
    • D、1，2，3，4，5，and 6

    正确答案:C

  • 第2题：

    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

  • 第3题：

    You are working on a new Oracle Database 11g server， where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.  Some of the requirements set for your database creation task are：  1：Configure the database to operate in shared server mode.  2：Disable automatic maintenance tasks such as optimizer statistics collection.  3：Configure a naming method to help the remote user connect to the database instance.  4：Use Automatic Storage Management （ASM） for storing the database files.  5：Configure daily database backup to flash recovery area.  6：Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database（）

    • A、4 and 6
    • B、2，3，4，and 6
    • C、1，2，4，5，and 6
    • D、1，2，3，4，5，and 6

    正确答案:C

  • 第4题：

    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

    • A、Oracle Migration Assistant
    • B、Recovery Manager （RMAN）
    • C、Oracle Data Pump Export and Import
    • D、conventional Oracle Export and Import
    • E、operating system utilities to copy the files to the ASM instance

    正确答案:B

  • 第5题：

    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、2
    • B、3
    • C、1 and 2
    • D、3 and 4
    • E、1，2，and 4

    正确答案:E

  • 第6题：

    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 Files
    • B、Oracle Grid Architecture
    • C、Optimal Flexible Architecture
    • D、Oracle database architecture
    • E、Automatic Storage Management

    正确答案:C

  • 第7题：

    单选题
    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）
    A

     Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.

    B

     Oracle will automatically take the datafile out of hot backup mode and then open the database.

    C

     Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.

    D

     The database will open with the file in hot backup mode. You can restart the backup at any time.

    E

     The datafile in hot backup mode will be corrupted and you will have to recover it.


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

  • 第8题：

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


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

  • 第9题：

    单选题
    You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands：   RMAN> CONNECT TARGET sys/sys@APPPROD RMAN> CONNECT AUXILIARY sys/sys@DUPDB RMAN> DUPLICATE TARGET DATABASE TO dupdb  FROM ACTIVE DATABASE PASSWORD FILE SPILE  NOFILENAMECHECK；   What are the implications of this command？（）
    A

     It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

    B

     It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

    C

     It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

    D

     It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


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

  • 第10题：

    单选题
    You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?（）
    A

    When the instance is started 

    B

    When the database is mounted 

    C

    When the database is opened 

    D

    When the database is closed


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

  • 第11题：

    多选题
    The following are the details of your database：Instance name：test  Host name ： tech1.us.oracle.com IP address：145.33.230.186 Enterprise Manager Console HTTP Port number：5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control？（）
    A

    http：//145.33.230.186：5500/em

    B

    http：//www.145.33.230.186：5500/em

    C

    http：//tech1.us.oracle.com：5500/em

    D

    http：//test.145.33.230.186：5500/em

    E

    http：//test.tech1.us.oracle.com：5500

    F

    http：//www.tech1.us.oracle.com：5500/em

    G

    http：//test.tech1.us.oracle.com：5500/em


    正确答案： G,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.


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

  • 第13题：

    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 Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第14题：

    You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

    • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
    • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
    • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
    • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
    • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

    正确答案:D

  • 第15题：

    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

    • A、 The audit trail is stored in an operating system file.
    • B、 Auditing is disabled for all privileges.
    • C、 The audit trail is stored in the database.
    • D、 Auditing is enabled for all privileges.
    • E、 Auditing is enabled for certain privileges related to database security.

    正确答案:C,E

  • 第16题：

    When you create a backup control file， where is the resulting file written to？（）  

    • A、 The database user dump destination directory
    • B、 The database diagnostic destination directory
    • C、 To $ORACLE_HOME/rdbms
    • D、 To $ORACLE_HOME/admin
    • E、 To the directory and filename you specify in the command

    正确答案:E

  • 第17题：

    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 Manager
    • B、 Listener Control utility
    • C、 Database Configuration Assistant
    • D、 Oracle Net Configuration Assistant

    正确答案:B

  • 第18题：

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


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

  • 第19题：

    多选题
    You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
    A

    The audit trail is stored in an operating system file.

    B

    Auditing is disabled for all privileges.

    C

    The audit trail is stored in the database.

    D

    Auditing is enabled for all privileges.

    E

    Auditing is enabled for certain privileges related to database security.


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

  • 第20题：

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

    B

     Listener Control utility

    C

     Database Configuration Assistant

    D

     Oracle Net Configuration Assistant


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

  • 第21题：

    多选题
    The following are the details of your database：   Instance name：test   Host name：tech1.us.oracle.com   IP address：145.33.230.186  Enterprise Manager Console HTTP Port number：5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control？（）
    A

    http：//145.33.230.186：5500/em

    B

    http：//www.145.33.230.186：5500/em

    C

    http：//tech1.us.oracle.com：5500/em

    D

    http：//test.145.33.230.186：5500/em

    E

    http：//test.tech1.us.oracle.com：5500

    F

    http：//www.tech1.us.oracle.com：5500/em

    G

    http：//test.tech1.us.oracle.com：5500/em


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

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

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第23题：

    单选题
    When you create a backup control file， where is the resulting file written to？（）
    A

     The database user dump destination directory

    B

     The database diagnostic destination directory

    C

     To $ORACLE_HOME/rdbms

    D

     To $ORACLE_HOME/admin

    E

     To the directory and filename you specify in the command


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

  • 第24题：

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

    2

    B

    3

    C

    1 and 2

    D

    3 and 4

    E

    1，2，and 4


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

相关内容