Oracle
1Z0-060 · Question #123
1Z0-060 Question #123: Real Exam Question with Answer & Explanation
The correct answer is C: Is used by Oracle to authenticate users for remote database administration.. 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.
Explanation
This question covers the purpose and capabilities of an Oracle password file created with the orapwd utility using the 12c format.
Common mistakes.
- A. 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.
- B. 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.
- D. 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.
Concept tested. Oracle password file purpose and orapwd format=12 capabilities
Community Discussion
No community discussion yet for this question.