Which two statements are true about the password file?

You Execute the Following command to create a password file in the database server: $
orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two

statements are true about the password file?

You Execute the Following command to create a password file in the database server: $
orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two

statements are true about the password file?

A.
It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

B.
It records the usernames and passwords of all users when they are added to the OSDBA
or OSOPER operating system groups.

C.
Is used by Oracle to authenticate users for remote database administration.

D.
It records the usernames and passwords of users when granted the DBA role.

E.
It contains the usernames and passwords of users for whom auditing is enabled.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


parry teacher

parry teacher

A
reason :(Optional) If 12, the default, the password file is created in Oracle Database 12c format. This format supports the SYSBACKUP, SYSDG, and SYSKM administrative privileges.
If legacy, the password file is in legacy format, which is the format before Oracle Database 12c. This argument cannot be set to legacy when the SYSBACKUP, SYSDG, or SYSKM argument is specified

C
The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect.
So to use “racle to authenticate users for remote database administration”
we need to Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set.

Other option is saying storing password . in this case we need to execute different command with option “password”