Multiple choice technology databases

REMOTE_LOGIN_PASSWORDFILE parameter can have

  1. SHARED

  2. EXCLUSIVE

  3. NONE

  4. All the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The REMOTE_LOGIN_PASSWORDFILE parameter in Oracle can have three values: NONE (no password file, OS authentication only), EXCLUSIVE (password file used by one database instance for privileged users), and SHARED (password file shared by multiple databases). 'All the Above' is correct because all three values are valid settings. NONE disables password file authentication, EXCLUSIVE is the default and recommended setting for single databases, and SHARED allows multiple databases to share the same password file (less secure, used in specific RAC or consolidated scenarios).

Keep practicing — related questions