Prepare with Oracle 1Z1-050 exam torrent, pass for sure

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 track the Service Request (SR) and implement repairs.
• C. You can manually run health checks to gather diagnostic data for a problem.
• D. Generate reports on data failure such as data file failures,

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. Create extended statistics for the CUST_STATE_PROVINCE and CUSTOMERSJDBE columns.
• B. Change the STALE_PERCENT value for the CUSTOMERS_OBE table.
• C. Set the STATISTICS_LEVEL parameter to TYPICAL.
• D. Set the OPTIMIZER_USE_PENDING_STATISTICS parameter to FALSE.

You are managing an Oracle Database 11 g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

• A. A net service name should be set up and a listener configured with the target as well as the source database.
• B. The source database must be shut down cleanly if the database is in mounted state.
• C. The source database must be run in ARCHIVELOG mode if the database is open.
• D. The source database backup must be copied over the net for test database,

Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT .PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?

• A. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
• B. The plan baselines are verified with the SQL profiles.
• C. All the nonaccepted SQL profiles are accepted into the plan baseline.
• D. All fixed plan baselines are converted into nonfixed plan baselines.

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>@utlu111 i.sql
Which statement about the execution of this script is true?

• A. It must be executed from the Oracle Database 11 g environment.
• B. It must be executed from the environment of the database that is being upgraded
• C. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• D. It must be executed only after the SYSAUX tablespace has been created.
• E. It must be executed from both the Oracle Database 11 g and Oracle Database 9i environments.