Which two are true in Oracle 19c and later releases?

• A.Schema Only accounts can be granted administrator privileges.
• B.If the password file location changes, then the new location is used automatically by the Oracle Server.
• C.All the Oracle-supplied accounts are Schema Only accounts.
• D.Unified Auditing can be configured to audit only events that are issued directly by an audited user.
• E.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle database methodology? (Choose two.)

• A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• B.The alert log should be used to find the database and instance areas most in need of tuning.
• C.The database instance memory should always be tuned before tuning any file systems.
• D.SQL statements should always be tuned before tuning any file systems.
• E.Tuning activities should stop once agreed service levels for performance have been met.
• F.Tuning activities should stop once the user is satisfied with performance.

Comment: *

Name: *

Email: *

Verification: *

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:
Install the SALES_APP application, induding the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

• A.1,3,5,6,7
• B.1,5,6
• C.2,5,6
• D.1,3,5,7
• E.3,4,1.6,8

Comment: *

Name: *

Email: *

Verification: *

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A.It is integrated with the SQL Access Advisor.
• B.It predicts the impact of system changes on SQL workload response time.
• C.It provides before and after execution statistics for each SQL statement in the analysis task
• D.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E.SQL statements that were originally run concurrently are run concurrently by SPA.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• B.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• C.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• D.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Comment: *

Name: *

Email: *

Verification: *