Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

• A. The size of the Flash Recovery Area for the database instance
• B. The retention period to support flashback
• C. The number of undo tablespaces in the database
• D. The expected length of the longest-running query

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

• A. Failure because a data file is renamed accidentally
• B. Failure due to loss of connectivity-for example, an unplugged disk cable
• C. Failure when no standby database is configured
• D. Failure that requires no archive logs to be applied for recovery

You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.
View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

• A. ORACLE_BASE/diag/rdbms/orcl/orcl/trace
• B. /u01/app/oracle/admin/orcl/adump
• C. ORACEL_HOME/rdbms
• D. /u01/app/oracle/flash_recovery_area
• E. ORACLE_BASE/diag/rdbms/orcl/alert
• F. ORACLE_HOME/dbs

USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.
SYS executes this command:
SQL>REVOKE UPDATE ON user1.emp FROM user1;
What will be the outcome?

• A. It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP
• B. It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP
• C. It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP
• D. It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP
• E. It will fail because USER1 is the owner of USER1.EMP

You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?

• A. Create the role with external authentication.
• B. Create a role and use Fine-Grained Access Control (FGAC) to secure the role.
• C. Create the role as a password-protected role.
• D. Create the role as a secure application role.