Multiple choice technology programming languages

You want the user APP_DBA to administer the oracle database from remote machine. APP_DBA is granted SYSDBA privilege to perform administrative task on the database. Which file is used by oracle database server to authenticate APP_DBA?

  1. Control file and password file

  2. Password file

  3. Control file

  4. Listener control file
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

For remote SYSDBA authentication, Oracle uses a password file to authenticate administrative users. The password file stores usernames and password hashes for users with SYSDBA, SYSOPER, or SYSASM privileges. Control files contain database structure information, not authentication data. Listener configuration files manage connection requests, not authentication.

Keep practicing — related questions