401.Which of the following are correct about block media recovery? (Choose all that apply.)
A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_
CORRUPTION.
B. Logical corruptions are repairable by BMR.
C. Physical corruptions are repairable by BMR.
D. RMAN can use any backup for a BMR restore.
E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.
Answer: AC
402.While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block
corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which
RMAN command do you use to perform BMR and repair the corrupt block?
A. RECOVER FILE=1201 BLOCK=1968;
B. RECOVER CORRUPTION LIST;
C. RECOVER DATAFILE 1201 BLOCK 1968;
D. RECOVER BLOCK CORRUPTION LIST;
E. None of the above
Answer: BC
403.To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should
you follow?
A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor
B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL
Tuning Advisor
C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors,
Automatic SQL Tuning Advisor
D. Either B or C
E. All of the above
Answer: D
404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the
SQL set by selecting specific operators and values?
A. Filter versions
B. Filter loads
C. Filter tasks
D. Filter options
Answer: D
405.To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?
A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D. Either B or C.
Answer: A
406.Which of these appropriately describes the results of a manual SQL Tuning Advisor task?
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the
recommended changes
D. All of the above
Answer: A
407.Which of the following is a potential performance tuning recommendation from the SQL Access
Advisor?
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above
Answer: E
408.Which statement most accurately describes the implementation of a SQL Access Advisor
recommendation?
A. SQL Access Advisor recommendations are automatically implemented.
B. Individual SQL Access Advisor recommendations can be scheduled for implementation.
C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
D. SQL Access Advisor recommendations are automatically scheduled for implementation during the
maintenance window.
E. None of the above.
Answer: B
409.Which of the following represents the correct sequence of events for Database Replay?
A. Capture, analyze, preprocess, replay
B. Capture, preprocess, analyze, replay
C. Capture, preprocess, replay, analyze
D. Analyze, capture, preprocess, replay
E. None of the above
Answer: C
410.Which of these recommendations should be followed before capturing a workload? (Choose all that
apply.)
A. Make sure your replay database has the same structure as the capture database, except without data.
B. Make sure the replay and capture databases are similar in data content.
C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.
D. Start the capture database in UNRESTRICTED mode, then start the capture.
E. Define inclusion and exclusion filters.
Answer: BC
411.Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?
A. Workload capture is per instance.
B. You only need to restart one instance to begin workload capture.
C. Specifically in RAC, you shut down all instances, restart them individually, and begin workload capture
with the last instance started.
D. RAC does not support workload capture, but it does support workload replay.
E. None of the above.
Answer: E
412.Performance divergence indicated in the Workload Replay report is most likely due to what?
A. DML and SQL statement results that do not match between the capture and replay systems
B. When errors that occur in the capture system dont occur in the replay system
C. Top SQL statements
D. Infrastructure or system-configuration differences
E. Time-of-day differences between capture and replay systems
Answer: D
413.Which of the following Oracle features is enabled by setting a nonzero value for the
MEMORY_TARGET initialization parameter?
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
Answer: D
414.By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a
nonzero value, you will enable which of the following memory-management options?
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
Answer: C
415.For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the
following memory-management features?
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above
Answer: D
416.To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you
can set values for which of the following initialization parameters? (Choose all that apply.)
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
Answer: ABCD
417.When manually configuring the SGA, which of the following parameter changes requires an instance
restart to take effect?
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
Answer: E
418.Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools
does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)
A. DB_CACHE_SIZE
B. SHARED_POOL_SIZE
C. LARGE_POOL_SIZE
D. JAVA_POOL_SIZE
E. SGA_MAX_SIZE
F. SORT_AREA_SIZE
Answer: AB
419.In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA
Memory Management?
A. Setting a nonzero value for SGA_TARGET
B. Configuring Automatic Shared Memory Management
C. Configuring Automatic Memory Management
D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E. None of the above
Answer: B
420.Automatic PGA Memory Management eliminates the need to manually configure which of the
following initialization parameters? (Choose all that apply.)
A. SORT_AREA_SIZE
B. HASH_AREA_SIZE
C. BITMAP_MERGE_AREA_SIZE
D. CREATE_BITMAP_AREA_SIZE
E. PGA_AGGREGATE_TARGET
Answer: ABCD
421.When tuning Automatic PGA Memory Management, which of the following views will provide the
information specified?
A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase
PGA_AGGREGATE_TARGET.
B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if
you change the value of PGA_AGGREGATE_TARGET.
C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the
V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA
Memory Management.
D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas
if you switch from Manual to Automatic PGA Memory Management.
Answer: A
422.To enable resumable space allocation for the instance, which of the following initialization parameters
should you set to a nonzero value?
A. RESUMABLE_SPACE_TIME
B. RESUMABLE_SPACE
C. RESUMABLE_TIME
D. RESUMABLE_TIMEOUT
E. TIME_RESUMABLE
Answer: D
423.Which of the following describes how a distributed resumable transaction behaves?
A. The resumable setting on the initiating session determines the resumable conditions for the entire
distributed transaction.
B. The resumable setting for the initiating instance determines the resumable conditions for the entire
distributed transaction.
C. The resumable setting on the initiating session controls only that part of the transaction that occurs
within the local instance; remote resumable settings determine the behavior of the distributed parts of the
transaction.
D. None of the above.
Answer: C
424.Which of these components correctly identify the unique value of the NAME column in the
DBA_RESUMABLE view?
A. Username, instance number, session ID
B. Instance number, username, session ID
C. Instance number, session ID, username
D. Username, session ID, instance number
E. None of the above
Answer: D
425.Which of the following are included in a transportable tablespace set? (Choose all that apply.)
A. The datafiles that make up a self-contained group of tablespaces required for copy
B. The system tablespace
C. An export of the tablespace metadata
D. The spfile
E. All of the above
Answer: AC
426.The following query will provide what information about transportable tablespaces for the current
database? (Choose all that apply.)
select d.platform_name "Source", t.platform_name
"Compatible Targets", endian_format
from v$transportable_platform t, v$database d
where t.endian_format = (select endian_format
from v$transportable_platform t,
v$database d
where d.platform_name =
platform_name);
A. The list of target platforms having the same endian format as the source database
B. The list of target platforms requiring endian conversion
C. The list of target platforms that will not require endian conversion
D. The list of all target platforms that can receive transportable tablespaces from the source database
E. None of the above
Answer: AC
427.When exporting metadata for the transportable tablespaces, what is the correct next step after
confirming endian format?
A. Export the tablespaces using data pump.
B. Determine if the transportable set is self-contained.
C. Convert the datafiles using RMAN.
D. Copy the datafiles from source to destination.
Answer: B
428.Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the
intended destination is listed.
B. Verify that there are no restrictions or limitations that the source or destination database may
encounter.
C. Verify that the source and destination have the same Oracle version, critical updates, patch-set version,
and patch- set exceptions.
D. Determine if you will perform the conversion on the source or destination platform.
E. None of the above.
Answer: ABD
429.Which of the following supplied functions is used to identify external tables, directories, and BFILES?
A. DBMS_TDB.CHECK_DIRECTORIES
B. DBMS_TDB.CHECK_EXTERNAL
C. DBMS_TDB.CHECK_BFILE
D. DBMS_TDB.CHECK_EXT
Answer: B
430.Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful
completion?
A. The database must be in read-write mode.
B. The database must have no external files.
C. The database must open in read-only mode.
D. The database must be mounted but not opened.
Answer: C
431.Which of the following options describes Segment Shrink?
A. Reclaims space above and below the high-water mark without using additional space
B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during
the operation
C. Deallocates space above the high-water mark that is currently not in use
D. None of the above
Answer: A
432.For which of the following can you use Segment Shrink? (Choose all that apply.)
A. Heap tables
B. Tables with function-based indexes
C. Indexes
D. Partitions and subpartitions
E. None of the above
Answer: ACD
433.When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK
SPACE command. Which clause should you use?
A. INCLUDING DEPENDENCIES
B. INCLUDING DEPENDENCIES CASCADE
C. COMPACT
D. CASCADE
E. None of the above
Answer: D
434.Which of these represent the main components of Database Resource Manager? (Choose all that
apply.)
A. Resource consumer groups
B. Resource plans
C. Resource-plan groups
D. Resource-plan directives
E. All of the above
Answer: ABD
435.Every resource plan must contain an allocation to which consumer group?
A. LOW_GROUP
B. SYS_GROUP
C. DEFAULT_GROUP
D. BASE_GROUP
E. OTHER_GROUPS
Answer: E
436.Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?
A. CREATE_MAPPING_PRIORITY
B. SET_MAPPING_PRIORITY
C. SET_MAPPING_ORDER
D. PRIORITIZE_MAPPING_ORDER
E. This functionality is not available through the DBMS_RESOURCE_MANAGER package.
Answer: B
437.Within a resource-plan definition, what differentiates a top-level plan from a subplan?
A. A subplan has the PLAN_SUB parameter value set to SUB.
B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the
resource-plan definition.
C. There is no difference in the resource-plan definition.
D. A subplan always has the CPU_MTH parameter value set to RATIO.
E. The string TOP_LEVEL is appended to the name of top-level resource plans.
Answer: C
438.When setting arguments for a job, which procedure do you use for types that cannot be implicitly
converted to and from a VARCHAR2 datatype?
A. SET_JOB_ARGUMENT_VALUE
B. SET_JOB_VALUE_ANYDATA
C. SET_JOB_ANYDATA_VALUE
D. SET_SPECIAL_JOB_VALUE
E. SET_JOB_ANYTYPE_VALUE
Answer: C
439.Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)
A. ENABLE
B. ENABLE_PROGRAM
C. VALIDATE_PROGRAM
D. SET_ATTRIBUTE
E. SET_ENABLED
Answer: AD
440.Which of the following is not a valid calendaring syntax element?
A. FREQ
B. BYHOUR
C. RUNDATE
D. INTERVAL
E. BYMINUTE
Answer: C
441.Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that
apply.)
A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS
C. DBA_SCHEDULER_CURRENT_JOBS
D. DBA_SCHEDULER_JOBS
E. DBA_SCHEDULER_EXECUTING_JOBS
Answer: BD
442.A schedule defined entirely within the confines of a Scheduler job object is known as a (n)
________________.
A. Fixed schedule
B. Inline schedule
C. Stored schedule
D. Hard-coded schedule
E. None of the above
Answer: B
443.Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that
apply.)
A. SET_ATTRIBUTE_NULL
B. ALTER_JOB
C. ALTER_JOB_PARAMETERS
D. ALTER
E. SET_ATTRIBUTE
Answer: AE
444.What is the default value for the ENABLED attribute of a job or program when it is created?
A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D. PENDING
E. NULL
Answer: B
445.To set the history retention period for either window logging or job logging individually, which
parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME
Answer: AD
446.Consider the following code snippet:
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => ,,lne_job1,
attribute => ,,job_priority,
value => 1);
END;
/
If this code were executed, which of the following statements would be true?
A. The priority of the lne_job1 job would be set to 1.
B. The lne_job1 job would be executed synchronously.
C. The lne_job1 job would run immediately in the users current session.
D. The lne_job1 job would retain its current priority.
E. The job will immediately take priority over all running jobs.
Answer: A
447.Which of the following calendaring syntax expressions would evaluate to the last day of every month?
A. FREQ = MONTHLY; BYMONTHDAY = 31
B. FREQ = MONTHLY; BYMONTHDAY = -1
C. FREQ = DAILY; BYDAY = -1
D. FREQ = MONTHLY; BYDAY = 31
E. FREQ = DAILY; BYMONTHDAY = LAST_DAY
Answer: B
448.Which of the following tasks is not performed by the job coordinator?
A. Update job log when a job completes
B. Spawn and remove job slaves
C. Write/read job info to/from memory cache
D. Query job table
E. Pass job information to job slaves
Answer: A
449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)
A. Schedule object
B. Program object
C. Job object
D. Resource plan
E. Resource consumer group
Answer: AD
450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A. PLSQL_BLOCK
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL
Answer: AD
451.Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object
or the JOB_TYPE parameter in a job object?
A. PLSQL_BLOCK
B. JAVA_STORED_PROCEDURE
C. STORED_PROCEDURE
D. EXECUTABLE
E. None of the above are invalid settings.
Answer: B
452.Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)
A. Schedule objects
B. Program arguments
C. Job classes
D. Job arguments
E. All of the above
Answer: ABD
453.What is the danger associated with stopping a running job by using the STOP_JOB procedure?
A. The job will need to be reenabled before it will execute again.
B. The job may hold locks on objects referenced within it.
C. All jobs within the job group will also be stopped.
D. The job may leave data in an inconsistent state.
E. There is no danger in using the STOP_JOB procedure.
Answer: D
454.If a job references a schedule that has been disabled, what will be the result?
A. The job will be automatically disabled.
B. The job will never execute.
C. The job will attempt to execute but will fail.
D. The job will inherit the DEFAULT_SCHEDULE schedule.
E. A schedule object cannot be disabled.
Answer: E
455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?
(Choose all that apply.)
A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B. The job will
only be disabled if the value of the AUTO_DROP attribute is FALSE.
C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is
FALSE.
D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and
the value of the CASCADE attribute is TRUE.
E. The STATE column of the job table will be set to COMPLETED for the job.
Answer: ABE
456.Which of the following is true about job chains?
A. They consist of one or more Scheduler programs.
B. They are used to implement dependency scheduling.
C. They are used to implement time-based scheduling.
D. They are used to implement event-based scheduling.
E. None of the above.
Answer: B
457.If two windows overlap, which window attribute will determine whether one should be chosen over the
other?
A. WINDOW_PRIORITY
B. PRIORITY
C. PRIORITY_LEVEL
D. WINDOW_PRIORITY_LEVEL
E. OVERLAP_RULE
Answer: A
458.Globalization support is implemented through the text- and character-processing functions provided
by which Oracle feature?
A. RSTLNE
B. NLSRTL
C. LISTENER
D. NLSSORT
E. Linguistic sorts
Answer: B
459.What elements of globalization can be explicitly defined using the NLS_LANG environment variable?
(Choose all that apply.)
A. NLS_LANGUAGE
B. NLS_SORT
C. NLS_CALENDAR
D. NLS_CHARACTERSET
E. NLS_TERRITORY
Answer: ADE
460.Given two different character sets (A and B), which of the following must be true for A to be
considered a strict superset of B? (Choose all that apply.)
A. A must contain all of the characters defined in B.
B. A must be Unicode.
C. The encoded values in A must match the encoded values in B for all characters defined in B.
D. A must be a multibyte character set.
E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters
in B.
Answer: AC
461.The NLS_SORT parameter sets the default sort method for which of the following
operations?(Choose all that apply.)
A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function
Answer: AD
462.Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and
NLS_CHARACTERSET parameters?
A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES
Answer: E
463.Which of the following datatypes store time-zone information in the database?
A. TIMESTAMP
B. DATE
C. TIMESTAMP WITH TIME ZONE
D. TIMESTAMP WITH LOCAL TIME ZONE
E. DATETIME
Answer: C
464.Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)
A. ASCII
B. ANSI
C. BINARY
D. MONOLINGUAL
E. MULTILINGUAL
Answer: BC
465.NLS parameters can be set using the five methods listed. Put the methods in order from highest to
lowest according to Oracles order of precedence:
A. Default setting
B. Client environment variable
C. Explicit ALTER SESSION statement
D. Inside SQL function
E. Server initialization parameter
F. b, d, e, a, c
G. e, a, b, c, d
H. d, c, b, e, a
I. a, b, d, c, e
J. d, c, b, a, e
Answer: C
466.What can you determine about the following linguistic sorts based only on their names?
1. GERMAN
2. FRENCH_M
A. 1 is a monolingual sort.
B. 2 is a monolingual sort.
C. 1 is case insensitive.
D. Both 1 and 2 are case insensitive.
E. Case sensitivity is unknown.
Answer: A
467.In a database with the database character set of US7ASCII and a national character set of UTF-8,
which datatypes would be capable of storing Unicode data by default?
A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG
Answer: C
468.Automatic data conversion will occur if which of the following happens?
A. The client and server have different NLS_LANGUAGE settings.
B. The client and server character sets are not the same, and the database character set is not a strict
superset of the client character set.
C. The client and server are in different time zones.
D. The client requests automatic data conversion.
E. The AUTO_CONVERT initialization parameter is set to TRUE.
Answer: B
469.Which of the following NLS_SORT parameter values would result in case-insensitive and
accent-insensitive binary sorts?
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.
Answer: B
470.Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic
for the SQL SELECT statement?
A. NLS_LANG
B. NLS_COMP
C. NLS_SORT
D. None of the above
Answer: D
471.Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?
A. All objects in the database
B. Tables owned by SYS and SYSTEM
C. Data dictionary tables
D. NCHAR columns
E. CHAR columns
Answer: E
472.Which is not a valid locale definition file type?
A. Language
B. Linguistic sort
C. Calendar
D. Territory
E. Character set
Answer: C
473.How many different calendars does Oracle 11g support?
A. 22
B. 7
C. 6
D. 15
E. 2
Answer: B
474.Which NLS parameter directly governs linguistic searches?
A. NLS_SEARCH_L
B. NLS_SORT
C. NLS_SEARCH
D. NLS_SORT_L
E. None of the above
Answer: B
475.Case-insensitive sorts are always accent insensitive by default.
A. True
B. False
Answer: B
476.What is the name of the file that identifies the set of available locale definitions?
A. locale.def
B. lxdef.ora
C. lx1boot.nlb
D. lx1boot.ora
E. lang.def
Answer: C
477.Which of the following is not a valid linguistic sort element?
A. Accent expansion
B. Canonical equivalence
C. Reverse secondary sorting
D. Ignorable characters
E. Character rearrangement
Answer: A
478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Answer: AC
479.Which two statements about workload capture and replay operations are true? (Choose two.)
A. The clients must be created manually on the test machines to perform more realistic testing.
B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state
for workload replay.
C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean
state for capturing the workload.
D. The application state of the capture system must be identical to the application state of the replay
system when the workload replay begins.
Answer: CD
480.View the Exhibit exhibit1 to examine the series of SQL commands.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first
row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.
Which statement is true if the SQL query in exhibit1 is executed again when the value of
OPTIMIZER_MODE is set to FIRST_ROWS?
A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to
FIRST_ROW during its creation.
Answer: B
481.Which statement is true about a running session that belongs to the online transaction processing
(OLTP) group?
A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests
or 2,500 MB of data transfer.
B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer
group, and then switches to the original group.
C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500
MB of data transfer and returns to the original group after the operation.
D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500
MB of data transfer for queries, but not for data manipulation language (DML) operations.
Answer: D
482.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to
convert all existing data in the USER_DATA tablespace and the new data into the encrypted format.
Which methods would you use to achieve this? (Choose all that apply.)
A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
B. Use ALTER TABL
E. MOVE to transfer the existing data to a new encrypted tablespace.
C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt
the tablespace.
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in
the tablespace is automatically encrypted.
Answer: ABC
483.Evaluate the following block of code:
BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl =>
'mycompany-com-permissions.xml', principal => 'ACCT_MGR', is_grant => TRUE, privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => 'mycompany-com-permissions.xml', host =>
'*.mycompany.com');
END;
What is the outcome of the above code?
A. It produces an error because a fully qualified host name needs to be specified.
B. It produces an error because the range of ports associated with the hosts has not been specified.
C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and
RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but
not the RESOLVE privilege.
Answer: C
484.Which steps are mandatory to enable Direct NFS?
1. Mount all required file systems using the kernel NFS driver.
2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3. Replace the ODM library libodm11.so_stub with libodm11.so.
A. 2 and 3
B. 1 and 3
C. 1 and 2
D. 1, 2 and 3
Answer: B
485.You want to back up your 100-GB database on a remote tape device. You are required to ensure that
minimum network bandwidth is consumed while transferring the backups to the tape device.
The current consumption of your CPU is approximately 40 percent.
Which type of backup should you perform?
A. standard backup set
B. image copy
C. compressed backup
D. user-managed backup
Answer: C
486.You execute the following Recovery Manager (RMAN) commands in (he following order:
BACKUP VALIDATE DATABAE
RECOVER CORRUPTION LIST;
Which (two tasks are performed by these commands? (Choose two.)
A. Repair the corrupted blocks. If any. In the backup created.
B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks-
C. Back up the database after checking whether array of the files have corrupted blocks.
D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view.
E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION
Answer: BC
487.When executing a SQL workload, you choose to generate execution plans only, without collecting
execution statistics.
Which two statements describe the implications of this? (Choose two.)
A. It produces less accurate results of the comparison analysis.
B. It automatically calls the SQL Tuning Advisor for recommendations.
C. It shortens the time of execution and reduces the impact on system resources.
D. Only the changes in the execution plan, and not performance regression, are detected.
Answer: AC
488.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? (Choose all that apply.)
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.
Answer: AD
489.For which two database objects can the VERSIONS clause of the Flashback Versions Query be
used?(Choose two.)
A.views
B.fixed tables
C.heap tables
D.external tables
E.temporary tables
F.index-organized tables (IOT)
Answer: CF
490.View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',
'(country_id, cust_state_province)') FROM dual;
Which statement describes the significance of this command?
A. It collects statistics into the pending area in the data dictionary.
B. It creates a virtual hidden column in the CUSTOMERS_OBE table.
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
D. It creates a histogram to hold skewed information about the data in the columns.
Answer: B
491.Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)
You restart the instance.
To what value will the MEMORY_MAX_TARGET parameter be set by default?
A. 120M
B. 320M
C. 480M
D. 600M
Answer: D
492.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.
Answer: C
493.Which three statements about performance analysis by SQL Performance Analyzer are true?
(Choose three.)
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
Answer: ABD
494.Which statement about Automatic Memory Management with Oracle 11g is true?
A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or
PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and
MEMORY_MAX_TARGET parameters in your parameter file.
D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the
current PGA size.
Answer: B
495.Which statement is true regarding the VALIDATE DATABASE command?
A. It checks the database for intrablock corruptions only.
B. It checks for block corruption in the valid backups of the database.
C. It checks the database for both intrablock and interblock corruptions.
D. It checks for only those corrupted blocks that are associated with data files.
Answer: A
496.Which two statements are true regarding an Automatic Storage Management (ASM) instance?
(Choose two.)
A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET
parameter is not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when
the database instance is started
Answer: CD
497.You are managing the APPPROD database as a DBA. You plan to duplicate this database in the
same system with the name DUPDB. You issued the following RMAN commands to create a duplicate
database:
RMAN> CONNECT target sys/sys@APPPROD
RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE
DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',
'/scratch/oracle/oradata/dupdb/' SPILE PARAMETER_VALUE_CONVERT
'/oracle/oradata/prod/', '/scratch/oracle/oradata/dupdb/' SET
SGA_MAX_SIZE = '300M' SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT
'/oracle/oradata/prod/redo/',
'/scratch/oracle/oradata/dupdb/redo/';
Which three are the prerequisites for the successful execution of the above command? (Choose three.)
A. The source database should be open.
B. The target database should be in ARCHIVELOG mode if it is open.
C. RMAN should be connected to both the instances as SYSDBA.
D. The target database backups should be copied to the source database backup directories.
E. The password file must exist for the source database and have the same SYS user password as the
target.
Answer: BCE
498.The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want
to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task,
you issued the following command:
SQL> ALTER TABLESPACE hi_data BEGIN BACKUP;
Which two statements are true in this scenario? (Choose two.)
A. No transaction on the tablespace is allowed but you can perform queries.
B. The tablespace will automatically come out of backup mode when the file copy is complete.
C. The checkpoint change number is frozen in headers of the data files until the file is removed from
backup mode.
D. The database writes the before image of an entire block to the redo stream before modifying. block tor
the first time.
Answer: AC
132 / 181
499.Which statement is true regarding the retention policy for the incidents accumulated in the Automatic
Diagnostic Repository (ADR)?
A. The incident metadata is purged when the problem is resolved and the DBA closes the SR.
B. The incident files and dumps are not retained in the ADR for the manually created incidents.
C. The incident files are retained but the incident metadata is purged when the problem is resolved and
the DBA closes the SR
D. The default setting is for one year after which the incident metadata is purged from the ADR and the
files are retained for one month.
Answer: D
500.You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace
DATAFILE '/home/user/oradata/secure01.dbf'
SIZE 150M
ENCRYPTION USING '3DES168'
DEFAULT STORAGE(ENCRYPT);
Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in
the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?
A. It creates the table and encrypts the data in it.
B. It generates an error because the wallet is closed.
C. It creates the table but does not encrypt the data in it.
D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
Answer: B