Online Access Free 1Z1-052 Exam Questions

Your database instance is running. db01 is a net service name. You issue a connection request using the following command:
SQL> CONNECT scott/tiger@db01
Which component receives the request and establishes the appropriate connection?

• A.user process
• B.server process
• C.listener
• D.service name

When would you use memory advisors?

• A.to get a recommendation whether Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) should be implemented.
• B.to generate memory-related alerts when memory demand exceeds a specified percentage
• C.to determine the impact of adding memory on hard parse count
• D.to determine the impact of adding or reducing memory on DB Time
• E.to determine the impact of adding memory on logical and physical reads

Which two are true about the Inventory directory? (Choose two.)

• A.It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server
• B.It should be created before installing Oracle software for the first time on a server
• C.It is required only for Oracle Grid Infrastructure and Oracle Database software installations
• D.It is shared by all Oracle software installations on a single server
• E.It can be created only if the ORACLE_BASE environment variable is set

Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

• A.The snapshots collected by the AWR are accessible through data dictionary views
• B.All AWR tables belong to the SYSTEM schema
• C.The AWR contains systemwide tracing and logging information
• D.The snapshots collected by the AWR are used by self-tuning components in the database

In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

• A.Modify the procedure to run with a definer's right.
• B.Modify the procedure to run with an invoker's right.
• C.Recompile the PL/SQL procedure.
• D.Grant the EXECUTE privilege on the PL/SQL procedure to PUBLIC.