200.Which operation requires that you create an auxiliary instance manually before executing the

operation? (Choose all that apply.)

A. Backup-based database duplication.

B. Active database duplication.

C. Tablespace point-in-time recovery.

D. No operation requires the creation of an auxiliary instance.

202.In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching.

B. It can be installed and uninstalled via OPatch unlike conventional patching.

C. It takes more time to install or uninstall compared with conventional patching.

D. It does not require down time to apply or remove unlike conventional patching.

E. It is not persistent across instance startup and shutdown unlike conventional patching.

206.Which statements are true regarding the Query Result Cache? (Choose all that apply.)

A. It can be set at the system, session, or table level.

B. It is used only across statements in the same session.

C. It can store the results from normal as well as flashback queries.

D. It can store the results of queries based on normal, temporary, and dictionary tables.

207.You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database.

Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

A. Every SQL statement in the STS is considered only once for execution.

B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.

C. The execution plan and execution statistics are computed for each SQL statement in the STS.

D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

211.You want to disable resumable space allocation for all sessions.

Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space

allocation for all sessions?

A. 0

B. 10

C. 100

D. NULL

214.You issued the following command on the temporary tablespace LMTEMP in your database:

SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

Which requirement must be fulfilled for this command to succeed?

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

216.Which three elements can a job chain process involve? (Choose three)

A. an event

B. a schedule

C. a program

D. another chain

E. a lightweight job

218.Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the

DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:

ALTER TABLESPACE data1 BEGIN BACKUP;

While you are performing the backup, an error occurs that causes the instance to terminate abnormally.

Which statement about the DATA1 tablespace is true?

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

220.Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?

(Choose all that apply.)

A. It can be used to allow the access privilege settings for users but not roles.

B. It can be used to allow the access privilege settings for users as well as roles.

C. It can be used to control the time interval for which the access privilege is available to a user.

D. It can be used to selectively restrict the access for each user in a database to different host computers.

E. It can be used to selectively restrict a user‘s access to different applications in a specific host computer.

221.To generate recommendations to improve the performance of a set of SQL queries in an application,

you execute the following blocks of code:

BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,‘TASK1‘); END;/

BEGIN dbms_advisor.set_task_parameter(‘TASK1‘,‘ANALYSIS_SCOPE‘,‘ALL‘);

dbms_advisor.set_task_parameter(‘TASK1‘,‘MODE‘,‘COMPREHENSIVE‘);

END;

/

BEGIN

dbms_advisor.execute_task(‘TASK1‘);

dbms_output.put_line(dbms_advisor.get_task_script(‘TASK1‘));

END;

/

The blocks of code execute successfully; however, you do not get the required outcome.

What could be the reason?

A. A template needs to be associated with the task.

B. A workload needs to be associated with the task.

C. The partial or complete workload scope needs to be associated with the task.

D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.

223.You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

A. Compute the baseline statistics.

B. Take an immediate AWR snapshot.

C. Decrease the window size for the baseline.

D. Decrease the expiration time for the baseline.

225.View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. You executed the following commands:

SQL> VAR tname VARCHAR2(60);

SQL> BEGIN :tname := ‘my_instance_analysis_mode_task‘;

DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,‘Sg_directive‘,‘SCOTT‘);

END;

Which statement describes the consequence?

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.

C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.

D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

227.You plan to control idle sessions that are blocking other sessions from performing transactions. Your

requirement is to automatically terminate these blocking sessions when they remain idle for a specified

amount of time.

How would you accomplish this task?

A. Set metric threshold

B. Implement Database Resource Manager

C. Enable resumable timeout for user sessions

D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

228.Evaluate the following statements:

CREATE TABLE purchase_orders (po_id NUMBER(4),

po_date TIMESTAMP, supplier_id NUMBER(6), po_total NUMBER(8,2),

CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date)

(PARTITION Q1 VALUES LESS THAN (TO_DATE(?1-apr-2007?d-mon-yyyy?), PARTITION Q2 VALUES

LESS THAN

(TO_DATE(?1-jul-2007?d-mon-yyyy?), PARTITION Q3 VALUES LESS THAN

(TO_DATE(?1-oct - 2007?d-mon-yyyy?), PARTITION Q4 VALUES LESS THAN

(TO_DATE(?1-jan-2008?d-mon-yyyy?));

CREATE TABLE purchase_order_items (po_id NUMBER(4) NOT NULL, product_id NUMBER(6) NOT

NULL, unit_price NUMBER(8,2), quantity NUMBER(8), CONSTRAINT po_items_fk FOREIGN KEY

(po_id) REFERENCES purchase_orders(po_id)) PARTITION BY

REFERENCE(po_items_fk);

What are the two consequences of the above statements? (Choose two.)

A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names.

B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each.

C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table.

D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns.

E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

229.Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

A. The amount of undo retained is user controlled.

B. SecureFile LOBs can be used only for nonpartitioned tables.

C. Fragmentation is minimized by using variable-sized chunks dynamically.

D. SecureFile encryption allows for random reads and writes of the encrypted datA.

E. It automatically detects duplicate LOB data and conserves space by storing only one copy.

231.You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing

users‘ passwords?

A. All passwords automatically become case-sensitive.

B. All passwords remain non-case-sensitive till they are changed.

C. All passwords remain non-case-sensitive and cannot be changed.

D. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

238.View the Exhibit to examine the output for the V$DIAG_INFO view.

Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)

A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

241.You issued the following RMAN command to back up the database:

RMAN> RUN{

ALLOCATE CHANNEL c1 DEVICE TYPE sbt

BACKUP DATABASE

TAG quarterly

KEEP FOREVER

RESTORE POINT FY06Q4;}

Which two statements are true regarding the backup performed? (Choose two.)

A. Archived redo log files are backed up along with data files.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. Archived log files are backed up along with data files, and the archived log files are deleted.

D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

246.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline.

Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the plan history.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

248.You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command:

RMAN> CONFIGURE RETENTIOH POLICY TO RECOVFRY WINDOW OF 7 DAYS;

After configuring the recovery window, you performed the database backup as follows:

A. Backup RB1 at log sequence number 12871 on 5th Jan

B. Backup RB2 at log sequence number 15622 on 12th Jan

C. Backup RB3 at log sequence 16721 on 15th Jan

D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

这道题的答案没理解到什么，不过知道CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;是什么意思就可以了。

Configuring a Recovery Window-Based Retention Policy

The RECOVERY WINDOW parameter of the CONFIGURE command specifies the number of days between the current time and the earliest point of recoverability. RMAN does not consider any full or level 0 incremental backup as obsolete if it falls within the recovery window. Additionally, RMAN retains all archived logs and level 1 incremental backups that are needed to recover to a random point within the window.

Run the CONFIGURE RETENTION POLICY command at the RMAN prompt. This example ensures that you can recover the database to any point within the last week:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

RMAN does not automatically delete backups rendered obsolete by the recovery window. Instead, RMAN shows them as OBSOLETE in the REPORT OBSOLETE output and in the OBSOLETE column of V$BACKUP_FILES. RMAN deletes obsolete files if you run the DELETE OBSOLETE command.

252.Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans can be manually loaded to the SQL plan baseline.

B. The plans in the SQL plan baseline are verified and accepted plans.

C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.

D. The plan baselines are stored temporarily in the memory as long as the database instance is running.

E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

253.You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile.

Which statement is true when you accept the suggested SQL profile?

A. The tuned plan is not added to the SQL plan baseline.

B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

254.Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

A. Only one I/O calibration process can run at a time.

B. It automates the resource allocation for the Automated Maintenance Tasks.

C. It improves the performance of the performance-critical sessions while running.

D. It can be used to estimate the maximum number of I/Os and maximum latency time for the system.

E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

255.Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

257.Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

A. flashback query

B. distributed transactions

C. logging in and logging out of sessions

D. all DDL statements having bind variables

E. direct path load of data from external files

258.Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement

crash.

C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

264.Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the

RMAN repository can be listed? (Choose two.)

A. stored scripts in the recovery catalog

B. backups that can be deleted from disk

C. backup sets and image copies are obsolete

D. backups that do not have the AVAILABLE status in the RMAN repository

官方参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta027.htm#RCMRF132

排除法：BC所表达的意思都是list命令能列出在磁盘上能被删除的备份集等。即obsolete状态。而obsolete状态是用report obsolete列出的。

266.View the Exhibit to examine the parameters set for your database instance. You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, - max_latency=>50,

-max_iops=>:max_iops, -max_mbps=>:max_mbps, -

actual_latency=>:actual_latency);

Which statement describes the consequence?

A. The command produces an error.

B. The calibration process runs successfully and populates all the bind variables.

C. The calibration process runs successfully but the latency time is not computed.

D. The calibration process runs successfully but only the latency time is computed.

在Oracle Database 11g Release 1中引入的过程CALIBRATE_IO从Oracle内部提供了获取存储系统性能的方法。该过程的使用存在一些限制。

该过程的调用需要SYSDBA权限。

TIMED_STATISTICS参数必须设置为TRUE，这是STATISTICS_LEVEL参数设置为TYPICAL时的默认值。

数据文件必须使用异步I/O进行访问，这是使用ASM时的默认设置。

Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles. This can be achieved by setting filesystemio_options to either ASYNCH or SETALL. One can also query the asynch_io status by means of the following SQL statement:

col name format a50 SELECT name, asynch_io FROM v$datafile f,v$iostat_file i
   WHERE f.file#        = i.file_no
   AND  filetype_name  = ‘Data File‘
  /

Only one calibration canbe run at a time. If another calibration is initiated at the same time, it willfail.

For an Oracle RealApplication Clusters (RAC) database, the workload is simultaneously generatedfrom all instances.

270.Which tasks are run automaticallyas part of the Automated Maintenance Task by default? (Choose

all that apply.)

A. Segment Advisor

B. SQL Access Advisor

C. Optimizer statistics gathering

D. Automatic SQL Tuning Advisor

E. Automatic Database DiagnosticsMonitor

271.Examine the output of the querythat you executed to list the objects in the recycle bin:

You verified that no table namedSALES_TAB exists in the schema. Then you executed the following command topurge the objects in the recycle bin:

SQL> PURGE TABLE sales_tab;

What would be the outcome of thiscommand?

A. All three tables in the recycle binare purged

B. Only the table with the oldestDROPSCN is purged

C. The command returns an errorbecause multiple entries with the same name exist in the recycle bin

D. Only the table with the latestDROPSCN is purged

273.Which statements are trueregarding the system-defined moving window baseline in Oracle

Database 11g? (Choose all that apply.)

A. It does not allow you to change themoving window size.

B. Adaptive threshold functionalitiesuse it by default to compute statistics.

C. It is created by default with thewindow size being equal to the AWR retention time.

D. It is created when the firstsnapshot is collected by the Automatic Workload Repository (AWR).

274.The SQL Tuning Advisor has beenconfigured with default configurations in your database instance.

Which recommendation is automaticallyimplemented without the DBA‘s intervention after the SQL Tuning

Advisor is run as part of the AUTOTASKframework?

A. statistics recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQLrecommendations

279.Identify theactivities performed as part of the Automatic SQL Tuning process in themaintenance window? (Choose all that apply.)

A. generating the SQLprofile

B. testing and acceptingthe SQL profile

C. generating a list ofcandidate SQLs for tuning

D. adding tuned SQL plansinto the SQL plan baseline

E. tuning each SQLstatement in the order of importance

F. generating baselinesthat include candidate SQLs for tuning

282.You are managing anOracle 11g database with ASM storage, for which the COMPATIBLE

initialization parameteris set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for thedisk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.

Which two statements aretrue in this scenario for the features enabled for ASM? (Choose two.)

A. The ASM-preferredmirror read feature is enabled.

B. The ASM supportsvariable sizes for extents of 1, 8, and 64 allocation units.

C. The ASM disk is droppedimmediately from a disk group when it becomes unavailable.

D. The RDBMS always readsthe primary copy of a mirrored extent of the ASM disk group.

289.You are managing theAPPPROD database as a DBA which is not using the Oracle-managed files.

You plan to duplicate thisdatabase in the same system with the name DUPDB.You want to create the

same directory structurefor duplicate database files as of the target database.

You executed the followingRMAN commands:

RMAN> CONNECT TARGET sys/sys@APPPROD

RMAN> CONNECT AUXILIARYsys/sys@DUPDB

RMAN> DUPLICATE TARGETDATABASE

TO dupdb

FROM ACTIVE DATABASE

PASSWORD FILE

SPILE

NOFILENAMECHECK;

What are the implicationsof this command?

A. It creates databasefiles for the duplicate database under the Oracle base with a differentdirectory for the duplicate database.

B. It overwrites datafiles of the target database because a different location for data files is notmentioned for the duplicate database.

C. It creates databasefiles for the duplicate database under the same Oracle home as that of thetarget database with the same directory structure.

D. It creates databasefiles for the duplicate database under the same Oracle home as that of thetarget but with a different directory for the duplicate database.

290.What are therecommendations for Oracle Database 11g installation to make it OptimalFlexible

Architecture(OFA)-compliant? (Choose all that apply.)

A. ORACLE_BASE should beset explicitly.

B. An Oracle base shouldhave only one Oracle home created in it.

C. Flash recovery area anddata file location should be on separate disks.

D. Flash recovery area anddata file location should be created under Oracle base in a non-Automatic StorageManagement (ASM) setup.

291.ENCRYPT_TS is an encryptedtablespace that contains tables with data. Which statement is true regardingthe effect of queries and data manipulation language (DML) statements on theencrypted data in the tables?

A. The data is decrypted during SORTand JOIN operations.

B. The data remains encrypted when itis read into memory.

C. The data remains encrypted when itis stored in the redo logs.

D. The data remains encrypted in theUNDO tablespace provided that the UNDO tablespace was created with theencryption option enabled.

292.You decided to use Direct NFSconfiguration in a non-RAC Oracle installation and created the

oranfstab file in /etc. Which twostatements are true regarding this oranfstab file? (Choose two.)

A. Its entries are specific to asingle database.

B. It contains file systems that havebeen mounted by Direct NFS.

C. It is globally available to allOracle 11g databases on the machine.

D. It contains file systems that havebeen mounted by the kernel NFS system.

295.Which statement about using RMANstored scripts is true?

A. To create and execute an RMANstored script, you must use a recovery catalog.

B. When executing a stored script anda command fails, the remainder of the script is executed, and a message iswritten to the alert log file.

C. RMAN stored scripts can always beexecuted against any target database that is registered in the

recovery catalog.

D. When you execute a stored script,it always executes using the persistent channel settings previously set withthe CONFIGURE command.

297.View the Exhibit forsome of the parameter settings. You start a session and issue the following

command:

SQL>CREATE INDEXemp_ename ON emp(ename)

TABLESPACE usersINVISIBLE;

What is the outcome of theabove command?

A. The index is not usedby the optimizer but is maintained during DML operations.

B. The index is not usedby the optimizer and is not maintained during DML operations.

C. The index is used bythe optimizer only if a hint is specified in the query statement and ismaintained during DML operations.

D. The index is used bythe optimizer only if a hint is specified in the query statement but is notmaintained during DML operations.

298.While tuning a SQLstatement, the SQL Tuning Advisor finds an existing SQL profile for thestatement that has stale statistics available.

What would the optimizerdo in this situation?

A. It updates the existingSQL profiles with current statistics.

B. It makes the statisticsinformation available to GATHER_STATS_JOB.

C. It initiates thestatistics collection process by running GATHER_STATS_JOB.

D. It logs a warningmessage in the alert log so that the DBA can perform statistics collectionmanually.