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 three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

• A. analysis of all privileges used by all users including administrative users in the database
• B. analysis of privileges that a user has on their own schema objects that they did use
• C. analysis of privileges that a user has on their own schema objects that they did not use
• D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
• E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F. analysis of all privileges used by all users but excluding administrative users in the database

Which two statements are true about the DUAL table? (Choose two.)

• A. It can be used to display only constants or pseudo columns
• B. It can display multiple rows and columns
• C. It can be accessed only by the SYS user
• D. It can be accessed by any user who has the SELECT privilege in any schema
• E. It can display multiple rows but only a single column
• F. It consists of a single row and single column of VARCHAR2 data type

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• B. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• C. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• D. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• E. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A. The primary key constraint will be enabled and immediate.
• B. The foreign key constraint will be enabled and immediate.
• C. The foreign key constraint will be disabled.
• D. The primary key constraint will be enabled and deferred.
• E. The foreign key constraint will be enabled and deferred.

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C. The Oracle join syntax supports natural joins
• D. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
• E. The Oracle join syntax only supports right outer joins
• F. The Oracle join syntax supports creation of a Cartesian product of two tables
• G. The SQL:1999 compliant ANSI join syntax supports natural joins