Which three are true in Oracle 19c and later releases? (Choose three.)
Which three are true in Oracle 19c and later releases? (Choose three.)
In Oracle 19c and later releases, if the password file location changes, then the new location is used automatically by the Oracle Server, which provides flexibility in managing password files. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault, making it easier to track and manage user privileges. Additionally, Unified Auditing can be configured to audit only events that are issued directly by an audited user, allowing for more precise auditing and monitoring of database activities.
BDF You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct) -Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct) -The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data. (F correct) https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html
BDF is correct
It's BDE.
BDF it is
I've checked it myself, answer BDF is correct.
B is not correct
Check again, 'B' is correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-5A1DE85F-6485-402E-9D76-34D63186E555
alter user c##test_sysdba no authentication Error report - ORA-40367: An Administrative user cannot be altered to have no authentication type. 40367. 00000 - "An Administrative user cannot be altered to have no authentication type." *Cause: An attempt was made to alter an administrative user to have no authentication type. *Action: Revoke administrative privilege from the user before attempting to alter the user.
here the references: https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-5490FE65-562B-49DC-9246-661592C630F9