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
It is not true that all Oracle-supplied accounts are schema-only accounts. While many are schema-only, particularly those with default passwords, there are exceptions, including administrative accounts like SYS and SYSTEM. These administrative accounts are essential for database administration tasks and require password authentication. So C is not correct
Why NOT A & F:
NOT A - normal restore point can age out of the control file (only guaranteed restore point never expire), see Oracle Doc: "7.1.5 About Guaranteed Restore Points
Like a normal restore point, a guaranteed restore point serves as an alias for an SCN in recovery operations. A principal difference is that guaranteed restore points never age out of the control file and must be explicitly dropped."
NOT F - not before, but after: see Oracle Doc: "RESTORE POINT restore_point_name - Creates a normal restore point matching the SCN to which RMAN must recover the backup to a consistent state, restore point name must not already exist, The SCN is captured just AFTER the data file backups COMPLETE."
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.
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
veginha
Highly Voted 4 years, 4 months agomarcinb32
4 years, 3 months agochindeka
Most Recent 5 days, 2 hours ago1451755
2 weeks, 5 days ago1451755
2 weeks, 5 days agoacesonly
5 months, 2 weeks agoantonica
7 months, 1 week agoacesonly
5 months, 2 weeks agoantonica
7 months, 1 week ago_gio_
1 year, 4 months agoNeil107
3 years, 2 months agojanw
4 years, 2 months ago