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 records the usernames and passwords of users when granted the DBA role.
B.
It contains the usernames and passwords of users for whom auditing is enabled.
C.
Is used by Oracle to authenticate users for remote database administration.
D.
It records the usernames and passwords of all users when they are added to the OSDBA or
OSOPER operating system groups.
E.
It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
Explanation:
C: Creating a password file via orapwd enables remote users to connect with
administrative privileges through SQL*Net.
D, not A, Not B: When SYSDBA or SYSOPER privileges are granted to a user, that user’s name
and privilege information are added to the password file.
Incorrect:
Not E: The Oracle orapwd command line utility assists the DBA with granting SYSDBA and
SYSOPER privileges to other users.
Note:
* You can create a password file using the password file creation utility, ORAPWD. For some
operating systems, you can create this file as part of your standard installation.
* ORAPWD FILE=filename [ENTRIES=numusers]
[FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
FILEName to assign to the password file. See your operating system documentation for namerequirements. You must supply a complete path. If you supply only a file name, the file is written to
the current directory.
ENTRIES(Optional) Maximum number of entries (user accounts) to permit in the file.
FORCE(Optional) If y, permits overwriting an existing password file.
IGNORECASE(Optional) If y, passwords are treated as case-insensitive.
NOSYSDBA(Optional) For Data Vault installations. See the Data Vault installation guide for your
platform for more information.
C, E
D is not correct because password file doesn’t correspond to operating system groups.
E is correct because format=12 is mentioned
TRUE. because format=12
C and D
Please check the below link
http://docs.oracle.com/cd/E24693_01/server.11203/e17120/dba006.htm#i1006677
Vijaya:
The link you propose is about 11.2 but not 12.1. C,E are correct answers for 12c.
NO TRUE are: C, D
not E becouse if you need support SYSBACKUP, SYSDG, and SYSKM you mast write parameters :
SYSBACKUP (Optional) If y, creates a SYSBACKUP entry in the password file. You are prompted for the password. The password is stored in the created password file.
SYSDG (Optional) If y, creates a SYSDG entry in the password file. You are prompted for the password. The password is stored in the created password file.
SYSKM (Optional) If y, creates a SYSKM entry in the password file. You are prompted for the password. The password is stored in the created password file.
http://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11059
sorry D is FALSE becouse OSDBA and OSOPER this is groups in OS to OS authenticate not password file!!!!
HMMMMM
in this way TRUE are: C, E
CE
C and E
E is correct :
(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.
CE
V$PWFILE_USERS has username, sysdba,sysoper,sysasm, sysbackup, sysdg, syskm columns. The password file does not store the passwords for the accounts. A, B, D can be easily ruled out.
Here is an example where the password file is created in 12format and therefore supports
SYSBACKUP and SYSDG administrative privileges in the password file.
Correct answers: C, E
CE
CE