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?

technology databases

  1. Control file and password file

  2. Password file

  3. Control file

  4. Listener control file

Show answer
Correct Option: B
Explanation:

To answer this question, the user needs to know about the authentication mechanism in Oracle databases and the files used to implement it.

In Oracle databases, SYSDBA privilege is required to perform administrative tasks on the database. The user APP_DBA has been granted this privilege to administer the database from a remote machine. To authenticate the user, Oracle uses a password file.

Therefore, the correct answer is:

The Answer is: B. Password file

Find more quizzes: