READ Free Dumps For Oracle- 1z0-050
| Question ID 6071 | During the installation of Oracle Database 11 g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation? |
| Option A | The installation terminates with an error. |
| Option B | The installation proceeds with the default value without warnings and errors. |
| Option C | The installation proceeds with the default value but it would not be an OFA-compliant database. |
| Option D | The installation proceeds with the default value but a message would be generated in the alert log file. |
| Correct Answer | D |
| Question ID 6072 | 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? |
| Option A | to avoid round trips to the server by enabling caching of query results in client memory |
| Option B | to improve performance by storing a copy of the data from the private SQL area of the PGA |
| Option C | to enhance the query performance by creating a cache in the client memory for sorting operation |
| Option D | to avoid the storing of query plans and results in the server by creating a cache in the client memory |
| Correct Answer | A |