⼆二⼗十⼆二.Recover
49. Which two affect the time taken for instance recovery?
A) Size of archivelogs.
B) Size of existing RMAN backupsets.
C) FAST_START_MTTR_TARGET value.
D) Size of UNDO tablespace.
E) UNDO_RETENTION value.
F) Size of redo logs.
Answer：CF
need-to-insert-img
⼆二⼗十三.Tablespace
50. Which two are true about space management in tablespaces?
A) Free lists are used for managing free space for segments in locally managed tablespaces.
B) Locally managed tablespaces track adjacent free space automatically by using bitmaps.
C) Locally managed tablespaces have either ASSM or manual segment space management (MSSM),and all the segments in these tablespace are managed one way or the other.
D) Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces.
E) ASSM tablespaces prevent row chaining.
Answer：BC
51. Which four statements are true about tablespace space management?
A) ASSM prevents row chaining.
B) Locally managed tablespaces track adjacent free space using bitmaps.
C) Locally managed tablespaces can manage segments with automatic segment space management(ASSM).
D) Locally managed tablespaces track adjacent allocated space using bitmaps.
E) ASSM prevents row migration.
F) Locally managed tablespaces can manage segments with freelists
G) Bigfile tablespaces can be dictionary or locally managed.
Answer：BCFG
52. Your database is configured in archivelog mode. The USERS01 tablespace is currently online. You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?
A) either the NORMAL or the TEMPORARY clause
B) only the TEMPORARY clause
C) only the NORMAL clause
D) either the NORMAL or the IMMEDIATE clause
E) only the IMMEDIATE clause.
Answer：C（验证过）
need-to-insert-img
53. which two statements are true about tablespaces?
A) A database can contain multiple undo tablespaces.
B) A database instance stores undo data in the SYSTEM tablespace if no undo tablespace exists.
C) A database instance hangs if the SYSAUX tablespace becomes unavailable.
D) A database can contain only a single temporary tablespace.
E) A database with a locally managed SYSTEM tablespace can have dictionary-managed user tablespaces.
Answer：AE
54. which four statements are true about tablespaces?
A) A single instance database can have multiple temp tablespaces created.
B) A single instance database can have multiple temp tablespace used simultaneously by the instance.
C) The SYSAUX tablespace can be altered OFFLINE.
D) A single instance database can have multiple undo tablespaces used simultaneously by the instance.
E) The SYSTEM tablespace can be altered OFFLINE FOR RECOVERY.
F) A single instance database can have multiple undo tablespace created.
G) The SYSAUX tablespace can be altered READ ONLY.(验证过）
Answer：ABCF
55. Which is true about enabling AUTOEXTEND for data files?
A) It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablesapce have autoextend enabled.
B) It can be enabled only for data files in non-OMF tablespaces.
C) It can be enabled for data files only in bigfile tablespaces.
D) It can be enabled for data files only in smallfile tablespaces.
E) It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.
Answer：E
56. Which is true about the SYSTEM and SYSAUX tablespaces？
A) Both tablespaces must be online for a database to be accessible .
B) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace can not.
C) Only the SYSTEM tablespace contains data dictionary tables.
D) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.
need-to-insert-img
Answer：C
57. Which three tablespace can be set to OFFLINE IMMEDIATE in an Oracle Database？
A) The SYSTEM tablespace.
B) The Undo tablespace currently used by the instance.
C) A tablespace containing an RMAN CATALOG.
D) A tablespace containing an Enterprise Manager repository.
E) The SYSAUX tablespace （除非启用了介质恢复, 否则不允许立即脱机）
Answer：CDE
58. Examine these facts about a database.
1. The database default tabpespace is USERS.
2. DEFERRED_SEGMENT_CREATION is TRUE.
3. The default tablespace of USER1 is tbs1.
4. USER1 has only these privileges:
• CREATE SESSION
• CREATE TABLE
• UNLIMITED quota on tbs1
Examine these commands executed by USER1:
SQL> CREATE TABLE emp (eno NUMBER, ename VARCHAR2(20)) TABLESPACE TBS1;
Table created.
SQL> CREATE INDEX emp_inx ON emo(eno) TABLESPACE USERS;
Index created.
SQL> INSERT INTO emp VALUES (NULL,’Alan’);
What will be the outcome of the INSERT operation and why?
A) It will fail because an indexed column cannot have NULL values.
B) A row will be inserted into EMP and an index entry will be made into EMP_IDX.
C) It will fail because USER1 has no quota on USERS.
D) A row will be inserted into EMP and an index entry will be inserted into a virtual column of EMP because USER1 has no quota an USERS.
E) A row will be inserted into EMP but no index entry will be made into EXP_IDX.
Answer：C
59. SCOTT.CUST is in the SALES tablespace. SCOTT executes these commands:
SQL> INSERT INTO cost VALUES(101,’JACK’);
need-to-insert-img
1 row created.
SQL> INSERT INTO cost VALUES(102,’SMITH’);
1 row created.
AS a DBA, do this in a different session:
ALTER TABLESPACE sales READ ONLY;
Which two statements are true?
A) Scott’s transaction is automatically rolled back and the tablespace becomes read-only.
B) The ALTER TABLESPACE command fails.
C) Scott’s transaction is automatically committed and the tablespace becomes read-only.
D) The command hangs and the hang will end if the transaction is committed.
E) The command hangs and the hang will end if the transaction is rolled back.
Answer：DE （已验证）
need-to-insert-img
⼆二⼗十四.Profiles
60. Which two can be configured with profiles ?
A) the time after which an idle session is terminated
B) tablespace quotas for users
C) default object privileges for users
D) session CPU limits
E) default system privileges for users
F) default tablespace for users
Answer：AD
⼆二⼗十五.Alert log
61. Which two types of information can be found in the alert log?
A) a record of all actions performed by SYS and SYSTEM.
B) critical errors encountered by background processes.
C) a record of all DDL statements performed by non-DBA users.
D) instance recovery details
E) values of all initialization parameters whenever an instance is restarted.
Answer：BD（验证过）
62. You executed these commands:
SQL> SHOW PARAMETER BACKGROUND_DUMP_DEST NAMETYPEVALUE
——————————————————————————-
background_dump_deststring/u01/app/oracle/diag/rdbms/orcl/orcl/trace
SQL> SHOW PARAMETER DIAGNOSTIC_DEST NAMETYPEVALUE
——————————————————————————-
diagnostic_deststring/u01/app/oracle
in which two locations and in which format is the alert log stored?
A) as a text file in /u01/app/oracle/diag/rdbms/orcl/orcl/alert.
B) as a text file in /u01/app/oracle.
C) as an HTML file in /u01/app/oracle.
D) as an XML file in /u01/app/oracle
E) as an HTML file in /u01/app/oracle/diag/rdbms/orcl/orcl/alert
F) as an XML file in /u01/app/oracle/diag/rdbms/orcl/orcl/alert
Answer：AF
need-to-insert-img
⼆二⼗十六.Fast_start_mttr_target
63. Which two are true about FAST_START_MTTR_TARGET?
A) A higher value increases the I/O overhead.
B) It is overridden by LOG_CHECKPOINT_INTERVAL.
C) It is applicable only when the database is in ARCHIVELOG mode.
D) A lower value increase the time taken to perform instance recovery.
E) If it is set to 0, the MTTR Advisor is disabled.
Answer：BE
⼆二⼗十七.Install
64. You plan to install Oracle Grid Infrastructure and Oracle Database.
Which two mandatory tasks must be completed before you perform these installations?
A) setting the ORACLE_SID environment variable.
B) setting the ORACLE_BASE environment variable to an existing directory.
C) creating the Oracle Inventory and OSDBA groups in the operating system.
D) creating the oper and asmdba operating system groups.
E) creating an operating system user to be the owner of Oracle installation.
Answer：CE
65. You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI). You select the “Install and Configure Grid Infrastructure for a Standalone Server” option. Which task is performed by OUI as part of this installation?
A) creation and configuration of Enterprise Manager Cloud Control on the server.
B) creation of a general purpose database.
C) creation of an ASM disk group and registration of ASM components with Oracle Restart.
D) creation of privileged operating system groups that are used for OS authentication.
Answer：C
66. You want to install Oracle 11g database software and create a database on ASM immediately after the install.
You plan is to install both Oracle database and Grid Infrastructure. Which two are true in this scenario?
A) Both products must be of the same version.
B) Both procucts must be installed by the same OS user.
C) Each product must be installed in a different ORACLE_HOME.
D) Grid Infrastructure must be installed first
E) Both products must be installed by using the same ORACLE_BASE.
F) Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups.
Answer：CD
67. You are planning a softwore installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at least one database for each release managed by Grid Infrastructure for a Standalone Server. Which three are true in this scenario?
A) Both Oracle versions and Infrastructure can be owned by the same O/S account.
B) Oracle 11g Release 1 databases must be managed by Grid infrastructure 11g Release1.
C) Both Oracle versions and Infrastructure can be installed under the same ORACLE_BASE.
D) Both databases can be managed by Grid Infrastructure 11g Release 2.
E) Grid Infrastructure must be installed before both Oracle Database versions.
F) Each version of database may be managed by a separate version of Grid Infrastructure.
Answer：CEF
68. Which task would you perform before running the Oracle Universal Installer (OUI) in silent or suppressed mode ?
A) Install the dbhome script.
B) Install the coraenv script.
C) Create the oraInst.loc file.
D) Create the tnsnames.ora file.
E) Create the oratab file.
F) Install the oraenv script.
Answer：C
⼆二⼗十⼋八.Server-generated
69. Which two are true about server-generated alerts ?
A) They can be based only on database metrics.
B) They can ben based only on instance metrics.
C) They are visible in Oracle Enterprise Manger by default.
D) All stateful alerts can be found in DBA_ALERT_HISTORY.
E) Stateless alerts cannot be found in DBA_OUTSTANDING_ALERTS.
F) Stateful alerts must always be cleard manually.
Answer: CE （验证过）
70. Which two are true about server-generated alerts?
A) By default, an email is sent by the database instance for each server-generated alert.
B) Stateful alerts are preserved across instance restarts.
C) They are automatically written to alert.log.
D) Stateless alerts can be found in DBA_OUTSTANDING_ALERTS.
E) By default, a server-generated alert is raised for each tablespace that has 85% or more of its space used.
Answer：BE
71. Which four are true about server-generated alerts?
A) By default, a server-generated alert is raised for each tablespace that has 85% or more of its space used.
B) Server generated alerts for tablespace space usage occur only if the tablespace can no longer be automatically extended.
C) By default, a server-generated alert is raised for each tablespace that has 97% or more of its space used.
D) Stateless alerts can be seen by querying DBA_OUTSTANDING_ALERTS.
E) Stateful alerts that have not been cleared can be seen by querying DBA_ALERT_HISTORY.
F) Stateful alerts that have been cleared can be seen by querying DBA_ALERT_HISTORY.
Answer：ABCF
非阈值预警直接进入DBA_ALERT_HISTORY，阈值预警进入 DBA_OUTSTANDING_ALERTS清空后进入DBA_ALERT_HISTORY。
Oracle只提供预警，不会自动处理。只有管理员看到信息后处理，或达不到预警条件后消失。
⼆二⼗十九.DBCA
72. Your database instance is in NOMOUNT state.
You select the delete option in the Database Configuration Assistant(DBCA) for your database. What is the outcome?
A) DBCA is able to delete the services but not the data files.
B) DBCA prompts you to open the database, and then proceeds with the deletion.
C) DBCA is able to delete data files but not the services.
D) DBCA shuts down the instance and deletes the database.
Answer：A
73. Which is true about the Database Configuration Assistant (DBCA)?
A) It can use Oracle ASM for storing database files only if Oracle Managed Files(OMF) is configured.
B) It can change the server mode from dedicated to shared and vice versa for an existing database.
C) It can create new database templates only from existing templates or database.
D) It can register a database with Cloud Control and configure Database Control for the same database.
Answer：C
74. Which two are true about the Database Configuration Assistant (DBCA)?
A) It can create listeners on the server where it is configuring a database.
B) It can configure a Cloud Control agent on the server where it is configuring a database.
C) It can create new database templates from existing templates.
D) It can configure Oracle ASM on the server where it is configuring a database.
E) It can create new database templates from existing databases.
Answer：CE （验证过）
三⼗十.Dispatcher
75. Which two are true for shared server sessions?
A) They may use different shared server processes during the lifetime of the session
B) They communicate directly to the client
C) Session variables are stored in process memory
D) Session variables are stored in the UGA which is in the SGA
E) They communicate directly to the middle tier
Answer：AD（验证过）
76. For which requirement should you configure shared servers?
A) accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory.
B) using Recovery Manager(RMAN) to recover a database.
C) submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory.
D) accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory.
E) performing bulk-load operations in a DSS environment with limited memory.
Answer：A
77. Which two statements are true about dispatchers used by the Oracle shared server ?
A) They pull requests from the requests queue and process then until they are complete
B) A dispatcher is created for each user process.
C) Multiple user processes can connect to a single dispatcher.
D) They return completed requests to the appropriate user processes.
E) Multiple dispatchers can connect to a single server process.
Answer：CD
78. which two statements are true about dispatchers when using Oracle shared server?
A) Multiple dispatchers can be connected to a single shared server process.
B) A dispatcher is created for each user process.
C) They execute requests from the inbound requests queue
D) Multiple user processes can be connected to a single dispatcher process
E) They return shared server session output to user processes
Answer：DE（验证过）
79. In your database instance，shared server is enabled and the large pool is configured. Which two are true for shared server sessions？
A) The UGA is stored in the shared pool.
B) Session variables are stored in the PGA.
C) Cursor state is stored in the PGA.
D) SQL work areas are stored in the large pool.
E) All PGA components are store in the large pool.
Answer：DE
三⼗十⼀一.Advisor
97. When would you use memory advisors?
A) to determine the impact of adding memory on logical and physical reads.
B) to determine the impact of adding memory on hard parse count.
C) to determine the impact of adding or reducing memory on DB Time.
D) to generate memory-related alerts when memory demand exceeds a specified percentage.
E) to get a recommendation whether Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) should be implemented.
Answer：C（验证过）
98. Which is true about memory advisors?
A) If automatic memory Management is enabled, no memory advisors are available.
B) If automatic memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual SGA components.
C) If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
D) If Automatic shared Memory Management is enabled, both the SGA Advisor and PGA are available.
Answer：D
99. Which three are true about advisors in an Oracle 11g database?
A) The Automatic Database Diagnostic Monitor(ADDM) can provide recommendations for improving database performance.
B) The SQL Access Advisor can recommend the creation of materialized views and materialized view logs.
C) The SQL Tuning Advisor can recommend the creation of one or more indexes.
D) By default, the SQL Access Advisor runs automatically in each maintenance window.
E) The Segment Advisor on recommend the creation of partitioned tables.
Answer：ABC
100. Which three are true about advisors in an Oracle 11g database?
A) The Segment Advisor can recommend the creation of partitioned tables.
B) The SQL Tuning Advisor can recommend the creation of one or more indexes.
C) By default, this Memory Advisor runs automatically in each maintenance window.
D) The Automatic Database Diagnostic Advisor can provide recommendation to improve database performance.
E) The SQL Access Advisor can recommend the creation of materialized views and materialized view logs.
F) By default, the SQL Access Advisor runs automatically in each maintenance window.
Answer: BDE
三⼗十⼆二.Security
101. Which three are true about Oracle database security ?
A) By default,SYSDBA connections have access to all schema objects.
B) By default , SYSOPER connections have access to the data dictionary.
C) SYSDBA connections are always subject to mandatory auditing.
D) Fine Grained Auditing can be used to restrict access to sensitive date.
E) SYSOPER connections are always sbuject to mandatory auditing.
F) Mandatory auditing is enabled by setting AUDIT_SYS_OPERATIONS to TRUE.
Answer ：ACE（验证过）
三⼗十三.Lock
102. Which three can reduce lock contention in an Oracle database ?
A) The Database Resource Manager.
B) profiles
C) committing transactions in a timely manner.
D) manual locking of database objects for DML statements.
E) scheduling OLTP and batch workloads at different times.
Answer：ABC
103. Examine this query and its output:
SQL> select sid,event,blocking_session
2 from v$session
3 where blocking_session is not null;
SID EVENTBLOCKING_SESSION
----------- ------------------------------ -----------------
105 enq: TX - row lock contention15
Which two are true ?
A) The blocked session is waiting on a shared table lock.
B) Session 105 is blocking session 15
C) The blocked session is waiting on an enqueue.
D) The blocking session is waiting on a row-level lock.
E) Session 105 is blocked by session 15.
Answer：DE
验证过，BLOCKING_SESSION的意思是阻塞了别人的会话ID
