Free Oracle 1Z0-050 Exam Dumps Questions & Answers

The INVJHISTORY table is created using the command:
SQL>CREATE TABLE INV_HISTORY
(inv_no NUMBER(3),
inv_date DATE,
inv_amtNUMBER(10,2))
partition by range (inv_date)
interval (numtoyminterval(1 ,'month'))
(partition pO values less than (to_date(l01-01-2005llldd-mm-yyyy1)),
partition p1 values less than (to_date('01-01-2006','dd-mm-yyyy')));
The following data has been inserted into the INVJHISTORY table :
INV_NO INV_DATE INV_AMT
1 30-dec-2004 1000
2 30-dec-2005 2000
3 1-feb-2006 3000
4 1-mar-2006 4000
5 1-apr-2006 5000
You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR(TO_DATE(l15-feb-2006l,ldd-mon-yyyy,)),FOR(TO_DATE(l15-apr-20061))
INTO PARTITION sys_py;
What would be the outcome of this command?

• A.It produces an error because the partitions specified for merging are not adjacent.
• B.It produces an error because the date values specified in the merge do not match the date values stored in the table.
• C.It executes successfully, and the transition point is set to "l-apr-20061.
• D.It executes successfully, and the transition point is set to '15-apr-2006'.

Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command
Which statement describes the scenario that must have produced this warning?

• A.The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
• B.The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
• C.The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
• D.The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).

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(SAU\RY)INTO avgsal
FROM EMPLOYEES
WHERE DEPARTMENTJD = dept_id;
RETURN avgsal;
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.

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

• A.For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
• B.The plan baselines are stored temporarily in the memory as long as the database instance is running.
• C.The plans generated for every SQL statement are stored in the SQL plan baseline by default.
• D.The plans in the SQL plan baseline are verified and accepted plans.
• E.The plans can be manually loaded to the SQL plan baseline.

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

• A.You can package and upload diagnostic data to Oracle Support.
• B.You can manually run health checks to gather diagnostic data for a problem.
• C.Generate reports on data failure such as data file failures,
• D.You can track the Service Request (SR) and implement repairs.