OCP-1z0-050-11
QUESTION 1:
Identify two situations in which you can use Data Recovery Advisor for recovery.
(Choose two.)
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files
are missing.
D. The archived log files are missing for which backup is not available.
Answer: B,C
QUESTION 2:
In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been
set to YES and the users who need to access the database as DBAs have been granted
SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file
have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the
database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA
where DB01 is the net service name.
Which authentication method would be used first?
A. authentication by using the local OS of the database server
B. authentication by using the Oracle Internet Directory
C. authentication by password file
D. authentication by using certificates over SSL
Answer: C
QUESTION 3:
Examine the following values of the initialization parameters in the database having the
SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?
Page 1 A. /u01/app/oracle/product/11.1.0/db_1
B. /u01/app/oracle
C. $ORACLE_HOME/bdump
D. $ORACLE_HOME/log
Answer: B
QUESTION 4:
Observe the following PL/SQL block:
BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30);
END;
Which statement is correct regarding the above PL/SQL block?
A. It automatically purges the SQL management objects when SMB occupies more than
30% of the SYSAUX tablespace.
B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base
(SMB).
C. It reserves 30% of the space in the SYSTEM tablespace for SMB.
D. It generates a weekly warning in the alert log file when SMB occupies more than 30%
of the SYSAUX tablespace.
Answer: D
QUESTION 5:
Exhibit:
Page 2
View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?
A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
B. The database instance is running with manual shared memory management.
C. The database instance is running with manual PGA management.
D. The database instance has the MEMORY_TARGET value set to a nonzero value. Answer: D Page 3
QUESTION 6:
You are managing an Oracle Database 11g ASM instance having three disks in a disk
group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of
the disks in the disk group becomes unavailable because of power failure. Which
statements will be true in this scenario? (Choose all that apply.)
A. The disk is immediately dropped from the disk group.
B. The ASM tracks the extents that are modified during the outage.
C. The ASM migrates the extents from the unavailable disk to the remaining disks.
D. The disk automatically goes offline.
Answer: B,D
QUESTION 7:
The SQL Tuning Advisor has been configured with default configurations in your
database instance. Which recommendation is automatically implemented without the
DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK
framework?
A. statistics recommendations
B. SQL profile recommendations
C. restructuring of SQL recommendations
D. index-related recommendations
Answer: B
QUESTION 8:
Exhibit:
Page 4
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. All subsequent ADDM tasks including my_instance_analysis_mode_task are 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 ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
D. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
Answer: D
QUESTION 9:Page 5
Which statements are true regarding table compression? (Choose all that apply.)
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
Answer: A,C
QUESTION 10:
You are working as a DBA on the decision support system. There is a business
requirement to track and store all transactions for at least three years for a few tables in
the database. Automatic undo management is enabled in the database. Which
configuration should you use to accomplish this task?
A. Enable Flashback Data Archive for the tables.
B. Specify undo retention guarantee for the database.
C. Enable supplemental logging for the database.
D. Query V$UNDOSTAT to determine the amount of undo that will be generated and
create an undo tablespace for that size.
E. Create Flashback Data Archive on the tablespace on which the tables are stored.
Answer: A
QUESTION 11:
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. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so
that all the data in the tablespace is automatically encrypted.
B. Use Data Pump to transfer the existing data to a new encrypted tablespace.
C. Use ALTER TABLE..MOVE 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. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted
tablespace.
Answer: B,C,E
Page 6
QUESTION 12:
Exhibit:
View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome
the error. What can the solution be to reduce the chance of this error in future, when
implemented?
A. setting the PRE_PAGE_SGA parameter to TRUE
B. locking the SGA in memory
C. increasing the value of SGA_MAX_SIZE
D. automatic memory management
Answer: D
QUESTION 13:
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans generated for every SQL statement are stored in the SQL plan baseline by
default.
B. The plans can be manually loaded to the SQL plan baseline.
C. The plan baselines are stored temporarily in the memory as long as the database
instance is running.
D. The plans in the SQL plan baseline are verified and accepted plans.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace
must be online.
Answer: B,D,E
QUESTION 14:
You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a
SQL Tuning Set as a part of the workload capturing. What information is captured as part
of this process? (Choose all that apply.)
Page 7
A. the system change number (SCN)
B. the execution plan
C. the execution context
D. the SQL text
E. the execution frequency
Answer: C,D,E
QUESTION 15:
Which two statements are true regarding the Automatic Diagnostic Repository (ADR) in
Oracle Database 11g? (Choose two.)
A. The BACKGROUND_DUMP_DEST initialization parameter overrides the
DIAGNOSTIC_DEST initialization parameter for the location of the alert log file.
B. A single ADR can support multiple ADR homes for different database instances.
C. The alert files are stored in XML file format in the TRACE directory of each ADR
home.
D. If the environmental variable ORACLE_BASE is set, then DIAGNOSTIC_DEST is
set to $ORACLE_BASE.
Answer: B,D
QUESTION 16:
While deploying a new application module, the software vendor ships the application
software along with appropriate SQL plan baselines for the new SQLs being introduced.
Which two statements describe the consequences? (Choose two.)
A. The optimizer does not generate new plans for the SQL statements for which the SQL
plan baseline has been imported.
B. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
C. The plan baselines can be evolved over time to produce better performance.
D. The newly generated plans are directly placed into the SQL plan baseline without
being verified.
Answer: B,C
QUESTION 17:
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You
imported SQL Tuning Sets (STS) from the previous version. After changing the
OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL
Performance Analyzer, you observed performance regression for a few SQL statements.
What would you do with these SQL statements?
Page 8 A. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the
plans from being loaded to the SQL plan baseline.
B. Capture the plans from the previous version using STS and then load them into the
stored outline.
C. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of
regressed plans.
D. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
Answer: D
QUESTION 18:
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. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent
table by automatically duplicating the key columns.
C. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created
with four partitions each.
D. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS
table are automatically reflected in the PURCHASE_ORDERS table.
E. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as
the partitions of the PURCHASE_ORDERS table.
Answer: C,E Page 9
QUESTION 19:
You are managing an Oracle Database 11g instance with ASM storage. You lost an ASM
disk group DAT
A. You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore
command. Which of these methods would you use to achieve this? (Choose all that
apply.)
A. Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, failure group configurations, and data on
the disk group.
B. Restore the disk group with the exact configuration as the backed-up disk group, using
the same disk group name, same set of disks, and failure group configurations.
C. Restore the disk group with changed disk group specification, failure group
specification, disk group name, and other disk attributes.
D. Restore metadata in an existing disk group by passing the existing disk group name as
an input parameter.
Answer: B,C,D
QUESTION 20:
Examine the following RMAN command:
BACKUP DATABASE
TAG TESTDB
KEEP UNTIL 'SYSDATE+1'
RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN
command? (Choose two.)
A. Archived redo logs are backed up only if the database is open during the backup.
B. The backup is deleted after one day, regardless of the default retention policy settings.
C. The backup becomes obsolete after one day, regardless of the default retention policy
settings.
D. Only data files and the control file are backed up.
Answer: A,C
QUESTION 21:
Which statement describes the information returned by the
DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?
A. It returns space usage of only SecureFile LOB chunks.
Page 10 B. It returns space usage of only BasicFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for both partitioned and
nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned
tables.
Answer: A
QUESTION 22:
Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';
What is the impact of this setting on the usage of SecureFiles?
A. It forces SecureFiles to be created even if the BASICFILE option is specified to create
the LOB.
B. It forces BasicFiles to be created even if the SECUREFILE option is specified to
create the LOB.
C. It does not allow the creation of SecureFiles and generates an error if the
SECUREFILE option is specified to create the LOB.
D. It ignores the SECUREFILE option only if a Manual Segment Space Management
tablespace is used and creates a BasicFile.
Answer: B
QUESTION 23:
Which two statements are true regarding the functionality of the remap command in
ASMCMD? (Choose two.)
A. It reads the blocks from a good copy of an ASM mirror and rewrites them to an
alternate location on disk if the blocks on the original location cannot be read properly.
B. It repairs blocks by always reading them from the mirror copy and writing them to the
original location.
C. It repairs blocks that have read disk I/O errors.
D. It checks whether the alias metadata directory and the file directory are linked
correctly.
Answer: A,C
QUESTION 24:
Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?
A. only encryption and deduplication settings for only SecureFile CLOBs
B. only encryption and compression settings for all SecureFile LOBs
Page 11 C. deduplication, encryption, and compression settings for all SecureFile LOBs
D. deduplication, encryption, and compression settings only for SecureFile CLOBs
Answer: C
QUESTION 25:
Which statement describes the effect of table redefinition on the triggers attached to the
table?
A. All triggers on the table are invalidated and are automatically revalidated with the next
DML execution on the table.
B. All triggers on the table are invalidated and must be manually recompiled before the
next DML execution on the table.
C. All triggers on the table remain valid.
D. Only triggers that are affected by the changes to the structure of the table are
invalidated and automatically revalidated with the next DML execution on the table.
Answer: A
QUESTION 26:
Evaluate the following code:
SQL>VARIABLE task_name VARCHAR2(255);
SQL>VARIABLE sql_stmt VARCHAR2(4000);
SQL>BEGIN
:sql_stmt := 'SELECT COUNT(*) FROM customers
WHERE cust_state_province =''CA''';
:task_name := 'MY_QUICKTUNE_TASK';
DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR,
:task_name, :sql_stmt);
END;
What is the outcome of this block of code?
A. It creates a task and workload but does not execute the task.
B. It produces an error because the SQL Tuning Set has not been created.
C. It produces an error because a template has not been created.
D. It creates a task and workload, and executes the task.
Answer: D
QUESTION 27:
What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
Page 12 A. It improves performance by reading from a copy of an extent closest to the node.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves resync operations.
Answer: A
QUESTION 28:
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 a new nonfixed SQL plan baseline as a nonfixed plan.
D. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
Answer: D
QUESTION 29:
You plan to collect the Automatic Workload Repository (AWR) data every Monday
morning for a month. You want Oracle Database to automatically create a baseline every
Monday and remove the old baseline. What is the correct action to achieve this?
A. Create and populate a SQL Tuning Set from the AWR on every Monday.
B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
C. Create a repeating baseline template.
D. Insert a finding directive for future ADDM tasks.
Answer: C
QUESTION 30:
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
A. Persistent lightweight jobs modify several tables in the data dictionary to generate a
lot of redo.
B. The user cannot set privileges on persistent lightweight jobs.
C. Persistent lightweight jobs are useful when users need to create a large number of jobs
in a short time.
D. Persistent lightweight jobs are useful when users need to create a small number of jobs
that run infrequently.
E. The use of a template is mandatory to create persistent lightweight jobs. Page 13
Answer: B,C,E
QUESTION 31:
In which two aspects does hot patching differ from conventional patching? (Choose two.)
A. It takes more time to install or uninstall compared with conventional patching.
B. It can be installed and uninstalled via OPatch unlike conventional patching.
C. It does not require down time to apply or remove unlike conventional patching.
D. It is not persistent across instance startup and shutdown unlike conventional patching.
E. It consumes more memory compared with conventional patching.
Answer: C,E
QUESTION 32:
View the following SQL statements:
Transaction T1
INSERT INTO hr.regions VALUES (5,'Pole');
COMMIT;
Transaction T2
UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;
COMMIT;
Transaction T3
UPDATE hr.regions SET region_name='North and South Poles' WHERE
region_id = 5;
You want to back out transaction T2. Which option would you use?
A. It is possible, but transaction T3 also backs out.
B. It is possible with the NOCASCADE_FORCE option.
C. It is not possible because it has conflicts with transaction T3.
D. It is possible with the NONCONFLICT_ONLY option.
Answer: B
QUESTION 33:
Which statement is true when Automatic Workload Repository (AWR) baselines are
created using baseline templates?
A. AWR baselines are always created with infinite expiration duration.
B. AWR baselines are always created as repeating baselines.
C. AWR baselines are always created using the Automatic Workload Repository (AWR)
retention period as expiration duration.
Page 14 D. AWR baselines can be created on the basis of two time values.
Answer: D
QUESTION 34:
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
A. It drops the connection after the specified number of login attempts fail for any user.
B. It is enforced only if the password profile is enabled for the user.
C. It locks the user account after the specified number of attempts.
D. It drops the connection after the specified number of login attempts fail only for users
who have the SYSDBA privilege.
Answer: A
QUESTION 35:
Which statement is true regarding virtual private catalogs?
A. A virtual private catalog owner can create a local stored script, and have read/write
access to a global stored script.
B. The virtual private catalog owner cannot create and modify the stored scripts.
C. The set of views and synonyms that make up the virtual private catalog is stored in the
schema of the RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the
SYSDBA or SYSOPER privilege on the target database.
Answer: D
QUESTION 36:
Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A. All LOB data that is identical in two or more rows in a LOB column share the same
data blocks.
B. The LOB values are cached by default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. The LOB values are automatically compressed.
Page 15 Answer: A
QUESTION 37:
Which statements are true regarding the Query Result Cache? (Choose all that apply.)
A. It can store the results from normal as well as flashback queries.
B. It can be set at the system, session, or table level.
C. It is used only across statements in the same session.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
Answer: A,B
QUESTION 38:
You are working on a CATDB database that contains an Oracle Database version 11.1
catalog schema owned by the user RCO11. The INST1 database contains an Oracle
Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242,
registered in RCAT10, into the recovery catalog owned by RCO11.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)
A. They import metadata for all registered databases in the RCAT10 database.
B. They register all the RCAT10-catalog registered databases in the RCO11 catalog.
C. They overwrite all stored scripts in the RCO11 catalog with the same name as that in
the RCAT10 catalog.
D. They deregister all databases registered in the RCAT10 catalog.
Answer: A,B,D
QUESTION 39:
Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER)
RETURN NUMBER
RESULT_CACHE RELIES_ON (EMPLOYEES)
IS
avgsal NUMBER(6);
BEGIN
SELECT AVG(SALARY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENT_ID = dept_id;
RETURN avgsal;
Page 16 END get_dept_avg;
Which statement is true regarding the above function?
A. The cached result becomes invalid when any structural change is done to the
EMPLOYEES table.
B. If the function is invoked with a different parameter value, the existing result in the
result cache gets overwritten by the latest value.
C. Each time the function is invoked in a different session, the current result in the result
cache gets overwritten.
D. If the function execution results in an unhandled exception, the exception result is also
stored in the cache.
Answer: A
QUESTION 40:
Which tasks can be accomplished using the Enterprise Manager Support Workbench in
Oracle Database 11g? (Choose all that apply.)
A. Generate reports on data failure such as data file failures.
B. You can track the Service Request (SR) and implement repairs.
C. You can package and upload diagnostic data to Oracle Support.
D. You can manually run health checks to gather diagnostic data for a problem.
Answer: B,C,D
QUESTION 41:
Exhibit #1:
Exhibit #2:
Page 17
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 the plan in the first row of the exhibit2 because
OPTIMIZER_MODE was set to FIRST_ROW during its creation.
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 a new plan because none of the plans in the exhibit2 are fixed
plans.
Answer: B
QUESTION 42:
What are the advantages of variable extent size support for large ASM files? (Choose
two.)
A. It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
B. It improves performance in the extended cluster configuration by reading from a local
copy of an extent.
C. Fewer extent pointers are needed to describe the file and less memory is required to
manage the extent maps in the shared pool.
Page 18 D. This feature enables faster file opens because of the reduction in the amount of
memory that is required to store file extents.
Answer: C,D
QUESTION 43:
Which two are the uses of the ASM metadata backup and restore (AMBR) feature?
(Choose two.)
A. It can be used to back up all data on ASM disks.
B. It can be used to recover the damaged ASM disk group along with the data.
C. It can be used to gather information about a preexisting ASM disk group with disk
paths, disk name, failure groups, attributes, templates, and alias directory structure.
D. It can be used to re-create the ASM disk group with its attributes.
Answer: C,D
QUESTION 44:
Which two changes and their effect on the system can be tested by using the Database
Replay feature? (Choose two.)
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage
Answer: C,D
QUESTION 45:
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?
A. SQL statements that are part of the AWR baseline only
B. SQL statements based on the AWR top SQL identification
C. SQL statements that are part of the available SQL Tuning Set (STS) only
D. SQL statements that are available in the cursor cache and executed by a user other
than SYS
Answer: B
QUESTION 46:
While performing the backup of the flash recovery area, you notice that one of the
archived redo log files is missing. You have multiple destinations for archived redo log
Page 19 files. What implications does it have on the backup of the flash recovery area?
A. The backup fails because one of the archived redo log files is missing.
B. The backup succeeds but it would be without the missing archived log.
C. During backup, you are prompted for the alternative destination for the missing
archived redo log file.
D. The backup succeeds because it fails over to one of the alternative archived redo log destinations.
Answer: D
QUESTION 47:
You are working on a CATDB database that contains an Oracle Database version 11.1
catalog schema owned by the user RCO11. The INST1 database contains an Oracle
Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242,
registered in RCAT10, into the recovery catalog owned by RCO11. You executed the
following commands:
RMAN> CONNECT CATALOG rco11/password@catdb
RMAN> IMPORT CATALOG rcat10/oracle@inst1 NO UNREGISTER;
Which two statements are true regarding the tasks accomplished with these commands?
(Choose two.)
A. They register all databases registered in the RCAT10 catalog.
B. They import all metadata from the RCAT10 catalog.
C. They do not register the databases registered in the RCAT10 catalog.
D. They unregister the database from the RCAT10 catalog.
Answer: A,B
QUESTION 48:
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance
on the same machine. Both instances use the ASM instance as storage. Which statements
regarding the ASM disk group compatibility attributes are true in this scenario? (Choose
all that apply.)
A. The database-compatibility version settings for each instance must be greater than or
equal to the RDBMS compatibility of all ASM disk groups used by that database
instances.
B. RDBMS compatibility and the database version determines whether a database
instance can mount the ASM disk group.
C. The RDBMS compatibility settings for a disk group control the format of data
structures for ASM metadata on the disk.
D. ASM compatibility controls which features for the ASM will be enabled. Page 20