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 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 name

requirements. 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.



Leave a Reply 13

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


R

R

C, E

D is not correct because password file doesn’t correspond to operating system groups.
E is correct because format=12 is mentioned

Joe

Joe

TRUE. because format=12

Eugene

Eugene

Vijaya:
The link you propose is about 11.2 but not 12.1. C,E are correct answers for 12c.

JanK

JanK

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

JanK

JanK

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

Mohammad Rafiq

Mohammad Rafiq

C and E

John

John

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.

RS VASAN

RS VASAN

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