Oracle Database Administration I — Question 145

Which two statements are true about User Authentication in an Oracle Database? (Choose two.)

Answer options

• A. Password authentication must be used for system-privileged administrative users.
• B. Password File authentication must be used for system-privileged administrative users.
• C. Operating System authentication may be used for system-privileged administrative users.
• D. Password File authentication is supported for any type of database user.
• E. REMOTE_LOGIN_PASSWORDFILE must be set to exclusive to permit password changes for system-privileged administrative users.

Correct answer: A, C

Explanation

Option A is correct because password authentication is indeed required for certain system-privileged users. Option C is also correct since Operating System authentication can be utilized by these users. Options B, D, and E are incorrect as they either misrepresent the requirements for system-privileged users or the configuration settings related to REMOTE_LOGIN_PASSWORDFILE.