READ Free Dumps For Oracle- 1z0-062
| Question ID 21747 | Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new
indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
|
| Option A | Database replay
|
| Option B | SQL Tuning Advisor
|
| Option C | SQL Access Advisor
|
| Option D | SQL Performance Analyzer
|
| Option E | Automatic Workload Repository compare reports
|
| Correct Answer | D |
Explanation Explanation: You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include: ·Database upgrades ·Configuration changes to the operating system, hardware, or database ·Database initialization parameter changes ·Schema changes, such as adding new indexes or materialized views ·Gathering optimizer statistics ·SQL tuning actions, such as creating SQL profiles http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961
| Question ID 21748 | An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?
|
| Option A | You can conned as a common user by using the connect statement.
|
| Option B | You can connect as a local user by using the connect statement
|
| Option C | You can connect by using easy connect.
|
| Option D | You can connect by using OS authentication.
|
| Option E | You can connect by using a Net Service name.
|
| Option F | You can connect as a local user by using the SET CONTAINER statement.
|
| Correct Answer | C,D,E,F |
Explanation Explanation: * The choice of threading model is dictated by the THREADED_EXECUTION initialization parameter. THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the multiprocess model. THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model. * OS Authentication is not supported with the multithreaded model. * THREADED_EXECUTION When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect to the database using operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to TRUE receive an ORA-01031"insufficient privileges" error. F: The new SET CONTAINER statement within a call back function: The advantage of SET CONTAINER is that the pool does not have to create a new connection to a PDB, if there is an exisitng connection to a different PDB. The pool can use the existing connection, and through SET CONTAINER, can connect to the desired PDB. This can be done using: ALTER SESSION SET CONTAINER=
This avoids the need to create a new connection from scratch.