Oracle Database 12c: Installation and Administration — Question 8

You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

Answer options

• A. It records usernames and passwords of users when granted the DBA role
• B. It contains usernames and passwords of users for whom auditing is enabled
• C. It is used by Oracle to authenticate users for remote database administrator
• D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Correct answer: A

Explanation

The correct answer is A because the password file is specifically used to store usernames and passwords for users granted the DBA role. Options B and C are incorrect as they refer to auditing and remote authentication, which are not the primary functions of the password file. Option D is also incorrect because the file does not log all users in OSDBA or OSOPER groups, but rather focuses on those with DBA privileges.