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 tile?
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:
A: When SYSDBA or SYSOPER privileges are granted to a user, that user’s name
and privilege information are added to the password file.C: Creating a password file via orapwd enables remote users to connect with administrative
privileges through SQL*Net.
Not E: The Oracle orapwd command line utility assists the DBA with granting SYSDBA and
SYSOPER privileges to other users.
* 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.
Answer should be C and E. E because format=12 is mentioned
Please consider C D
Yip, C & E.
D is wrong as the password file doesn’t correlate to operating system groups.
Yes, the correct answer is C,E.
format – use format=12 for new 12c features like SYSBACKUP, SYSDG and
SYSKM support, longer identifiers, etc.
correct answer is C,D
E is wrong because sysbackup=y sysdg=y or syskm=y are not specified.
SQL> grant sysdba to frank;
Grant succeeded.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
—————————— —– —– —–
SYS TRUE TRUE FALSE
FRANK TRUE FALSE FALSE
For me ACE are correct.
A: see Frank’s example with grant sysdba above. The user FRANK and its Password are stored in the pwfile.
C: rf. Oracle document
E: even if options sysbackup=y, sysdg=y, syskm=y are missing in the orapwd command, the 3 sys privileges are supported.
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID entries=5 ignorecase=N format=12
$ sqlplus sys/oracle@hlt1 as sysdba
Connected.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
—————————— —– —– —– —– —– —– ———-
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
SQL> grant SYSBACKUP to test;
Grant succeeded.
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID
—————————— —– —– —– —– —– —– ———-
SYS TRUE TRUE FALSE FALSE FALSE FALSE 0
TEST FALSE FALSE FALSE TRUE FALSE FALSE 0
$ sqlplus test/test@hlt1 as sysbackup
Connected.
Note: the Options SYSBACKUP=y SYSDG=y SYSKM=y are there to tell the orapwd command to create the initial entries in the pwfile to allow the db users sysbackup, sysdg and syskm to log on remotely. Oracle 12c pwfile always Support those three System privileges.
C is right. E is right only in general for 12c password file but not for the created in this question. D could be right if we remove passwords which are stored in password file. So should be just C.
CE ! . A is wrong because the password is not included.
snapshot from guide <>
CE
CE