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?

Question

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?

Accepted Answer

C. It is used by Oracle to authenticate users for remote database administrator The Oracle password file created by orapwd is the mechanism Oracle uses to verify credentials for remote privileged connections (SYSDBA/SYSOPER). Because remote sessions cannot leverage operating system group membership (OSDBA/OSOPER), Oracle falls back to the password file. The 'entries=5' parameter sets the maximum number of privileged users whose credentials can be stored in the file.

Answer

A. It records usernames and passwords of users when granted the DBA role The DBA role is granted and managed entirely within the data dictionary; the password file stores only SYSDBA and SYSOPER credentials, not DBA role grantees.

Answer

B. It contains usernames and passwords of users for whom auditing is enabled Audit configuration and audit records are stored in the database itself (the AUD$ table or unified audit trail), not in the Oracle password file.

Answer

D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER OSDBA and OSOPER are operating system groups used for local OS authentication, which bypasses the password file entirely; the password file is relevant for remote connections, not OS group membership.

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…

Question

Options

How the community answered

Why each option

Topics

Community Discussion