1Z0-060 · Question #123
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 correct answer is C. Is used by Oracle to authenticate users for remote database administration. E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges. This question covers the purpose and capabilities of an Oracle password file created with the orapwd utility using the 12c format.
Question
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?
Options
- AIt records the usernames and passwords of users when granted the DBA role.
- BIt contains the usernames and passwords of users for whom auditing is enabled.
- CIs used by Oracle to authenticate users for remote database administration.
- DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER
- EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
How the community answered
(52 responses)- A6% (3)
- B2% (1)
- C90% (47)
- D2% (1)
Why each option
This question covers the purpose and capabilities of an Oracle password file created with the orapwd utility using the 12c format.
The password file stores credentials for users granted SYSDBA or SYSOPER (and related) administrative privileges, not users granted the DBA role, which is tracked solely in the database data dictionary.
The password file has no relationship to auditing; it stores credentials for privileged remote connections only, while audit configuration is managed separately within the database.
The Oracle password file is used specifically to authenticate privileged users (SYSDBA, SYSOPER, etc.) who connect to the database remotely, enabling secure remote administration when OS authentication is not available.
The password file stores users explicitly granted SYSDBA or SYSOPER privileges via GRANT, not all OS users who are members of the OSDBA or OSOPER groups, as those groups are authenticated by the operating system directly.
When a password file is created with format=12, it supports the extended administrative privileges introduced in Oracle 12c - SYSBACKUP, SYSDG, and SYSKM - in addition to the traditional SYSDBA and SYSOPER privileges.
Concept tested: Oracle password file purpose and orapwd format=12 capabilities
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/getting-started-with-database-administration.html
Topics
Community Discussion
No community discussion yet for this question.