1Z1-050 무료 덤프문제 온라인 액세스

You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

• A.to avoid the storing of query plans and results in the server by creating a cache in the client memory
• B.to improve performance by storing a copy of the data from the private SQL area of the PGA
• C.to avoid round trips to the server by enabling caching of query results in client memory
• D.to enhance the query performance by creating a cache in the client memory for sorting operations

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 the SYSAUX tablespace has been created.
• 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 11 g and Oracle Database 9i environments.

Examine the section of the Health Check report given below:
DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')
Run Name: HM_RUN_1061 Run Id: 1061 Check Name : Data Block Integrity Check Mode : REACTIVE Status : COMPLETED Start Time : 2007-05-12 22:11:02.032292 -07:00 End Time : 2007-05-12 22:11:20.835135 -07:00 Error Encountered: 0 Source Incident Id : 7418 Number of Incidents Created :0
Which two statements are true regarding the Health Check report? (Choose two.)

• A.Health Check was performed manually.
• B.Health Check was performed by the Health Monitor automatically in response to a critical error.
• C.Health Check was performed to verify the integrity of database files and report failures.
• D.Health Check was performed to check the disk image block corruptions
• E.Health Check was performed to check interblock and intersegment corruption.

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

• A.It contains only SQL profiles generated by SQL Tuning Advisor.
• B.It is part of the data dictionary and stored in the SYSAUXtablespace.
• C.It contains the statement log, the plan history, plan baselines, and SQL profiles.
• D.It is part of the data dictionary and stored in the SYSTEM tablespace.
• E.It stores plans generated by the optimizer using a stored outline.

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 newly generated plans are directly placed into the SQL plan baseline without being verified.
• B.The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• C.The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
• D.The plan baselines can be evolved over time to produce better performance