Free Oracle 1Z1-050 Exam Dumps Questions & Answers

View the Exhibit exhibit1.

In the CUSTOMERS_OBE table, when the value of CUST_STATE_PROVINCE is "CA",
the value of COUNTRYJD is "US."
View the Exhibit exhibit2 to examine the commands and query plans.
The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?

• A.  Set the STATISTICS_LEVEL parameter to TYPICAL.
• B.  Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
• C.  Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.
• D.  Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns.

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:
SQL>@utlrp.sql
What is the significance of executing this script?

• A.  It performs parallel recompilation of any stored PL/SQL as well as Java code.
• B.  It performs sequential recompilation of any stored PL/SQL as well as Java code.
• C.  It performs sequential recompilation of only the stored PL/SQL code.
• D.  It performs parallel recompilation of only the stored PL/SQL code.

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

• A.  The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
• B.  Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).
• C.  Every problem has a problem key, which is a text string that describes the problem.
• D.  The problem key is the same as the incident number,
• E.  The database makes an entry into the alert log file when problems and incidents occur.

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

• A.  Drop the table.
• B.  Truncate the table.
• C.  Add a column to the table.
• D.  Rename a column in the table.
• E.  Partition the table

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 SQL plan baseline but not in the ENABLED state.
• B.  The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
• C.  The optimizer selects the new plan for the execution of the SQL statement.
• D.  The optimizer adds the new plan to the plan history.
• E.  The optimizer adds the new plan to the SQL plan baseline as an accepted plan.