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 orapwd utility creates a password file (orapworcl in this case) that Oracle uses to authenticate privileged connections made remotely with SYSDBA or SYSOPER privileges, where operating system group membership cannot be verified. The 'entries' parameter defines how many privileged users can be stored, and 'ignorecase=N' enforces case-sensitive password matching.

Answer

A. It records usernames and passwords of users when granted the DBA role The DBA role and its grantees are recorded in the data dictionary (DBA_ROLE_PRIVS), not in the external password file, which only holds SYSDBA/SYSOPER credentials.

Answer

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

Answer

D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating OSDBA and OSOPER operating system group membership is managed by the OS and does not require or use the Oracle password file for authentication.

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