In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A.It succeeds and the generated undo is stored in SYSTEM.
• B.It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
  'UNDOTBS1' ".
• C.It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• D.It succeeds and the generated undo is stored in SYSAUX.
• E.It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Comment: *

Name: *

Email: *

Verification: *

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 all privileges used by all users but excluding administrative users in the database
• C.analysis of privileges that a user has on their own schema objects that they did not use
• D.analysis of privileges that a user has on their own schema objects that they did use
• 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 privileges granted indirectly to a role that are then used by a user who has been granted that role

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about interval data types?

• A.INTERVAL day to second columns support fractions of seconds.
• B.INTERVAL year to month columns only support monthly Intervals within a single year.
• C.INTERVAL year to month columns only support monthly intervals within a range of years.
• D.The year field in an interval year to month column must be a positive value.
• E.The value in an interval day to SECOND column can be copied into an interval year to month column.
• F.INTERVAL year TO month columns support yearly intervals.

Comment: *

Name: *

Email: *

Verification: *

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 all privileges used by all users but excluding administrative users in the database
• C.analysis of privileges that a user has on their own schema objects that they did not use
• D.analysis of privileges that a user has on their own schema objects that they did use
• 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 privileges granted indirectly to a role that are then used by a user who has been granted that role

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.External table files can be used for other external tables in a different database
• B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• C.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• D.They cannot be partitioned
• E.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• F.They support UPDATEs but not INSERTs and DELETEs

Comment: *

Name: *

Email: *

Verification: *