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?
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?
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?
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?
$ 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?

Which two statements are true?