Which two statements are true about trace files produced by the Oracle Database server?

• A. All trace files contain error information that requires contacting Oracle Support.
• B. They can be written by server processes to the Fast Recovery Area (FRA).
• C. Trace file names are based on the database name concatenated with a sequential number.
• D. They can be written by background processes to a file system.
• E. They can be written by server processes to a file system.

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?

• A. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role.
• B. Analysis of privileges that a user has on their own schema objects.
• C. Analysis of all privileges used by the SYS user.
• D. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role.
• E. Analysis of privileges that a user has on other schemas' objects.

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

• A. It creates new default schemas for the PDB.
• B. It creates a new local user ADMIN with restricted privileges.
• C. After the PDB is created, it is automatically opened Read/Write.
• D. It creates tablespaces to store metadata.
• E. It creates a new local user ADMIN with SYSDBA privileges.
• F. The PDB must be opened Read Only to complete the integration of the PDB into the CDB.

Which two are benefits of external tables?

• A. They can be queried while the database is in the MOUNT state like dynamic performance views.
• B. They support DELETEs, which transparently deletes records in the file system as if they were table rows.
• C. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
• D. They support UPDATEs, which transparently updates records in the file system as if they were table rows.
• E. They can be queried, transformed, and joined with other tables without having to load the data first.

Which three functions are performed by dispatchers in a shared server configuration?

• A. Broadcasting shared server session responses back to requesters on all connections.
• B. True. Dispatchers monitor the response queue.
• C. Checking for outbound shared server responses on the common outbound response queue.
• D. Writing inbound requests to the common request queue from all shared server connections.
• E. Receiving inbound requests from processes using shared server connections.
• F. Sending shared server session responses back to requesters on the appropriate connection.
• G. Sending each connection input request to the appropriate shared server input queue.