Multiple choice technology databases

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

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

AI explanation

To connect remotely as SYSDBA without relying on OS-level authentication, Oracle uses a password file (created with orapwd) that stores authorized administrative usernames and passwords. The control file tracks the physical database structure (datafiles, redo logs) and isn't used for authenticating remote SYSDBA connections.

Keep practicing — related questions