[单项选择] 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 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? （）
A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

[单项选择] You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）
A. The command succeeds but it retrieves only the disk names.
B. The command produces an error because the ASM instance is down.
C. The command succeeds but it shows only the status of the ASM instance.
D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

[单项选择] You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）
A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

[单项选择] You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）
A. all disks in the disk group
B. all disks that are currently in OFFLINE mode
C. all disks that are not currently in OFFLINE mode
D. all disks in the disk group only if all of them are ONLINE

[多项选择]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 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 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.

[单项选择]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 managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1. Which two statements are true in this scenario for the features enabled for ASM? （）
A. The ASM-preferred mirror read feature is enabled.
B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.

[单项选择]How many different calendars does Oracle 11g support?（）
A. 22
B. 7
C. 6
D. 15
E. 2

[单项选择]Oracle 11g是基于（）的。
A. 关系型
B. 文件系统
C. 层次型
D. 网络型

[单项选择] Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）
A. Oracle Data Pump.
B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
D. Online Table Redefinition.
E. Edition-Based Table Redefinition.

[多项选择]In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations

[判断题]在Oracle11g中，可以使用ADDINDEX语句创建索引。

[多项选择]Oracle11G软件可以安装在以下哪些系统（）。
A. UNIX
B. Linux
C. Windows
D. Mac
E. 只有UNIX、Linux和Windows

[多项选择]Oracle11G中可以使用（）数据字典视图查看有关用户和对象的权限信息。
A. USER_TAB_PRIVS_MADE
B. USER_COL_TAB_RECD
C. USER_COL_PRIVS_MADE
D. USER_TAB_PRIVS_RECD
E. USER_COL_PRIVS_RECD

[单项选择]用于在启动实例时配置数据库，确定Oracle 11g的运行环境文件是（）。
A. 参数文件
B. 数据文件
C. 可执行文件
D. 控制文件