Question 91

You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE.
You execute the following:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which is true about the result of this command?
  • Question 92

    You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
    Which statement is true?
  • Question 93

    In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
    On further investigation, you find that buffer busy waits is caused by contention on data blocks.
    Which option would you consider first to decrease the wait event immediately?
  • Question 94

    You executed this command to create a password file:
    $ orapwd file = orapworcl entries = 10 ignorecase = N
    Which two statements are true about the password file?
  • Question 95

    In your multitenantcontainerdatabase (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

    Which two statements are true?