nerdexam
Oracle

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.

New Features for Security

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)
  • A
    6% (3)
  • B
    2% (1)
  • C
    90% (47)
  • D
    2% (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.

AIt records the usernames and passwords of users when granted the DBA role.

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.

BIt contains the usernames and passwords of users for whom auditing is enabled.

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.

CIs used by Oracle to authenticate users for remote database administration.Correct

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.

DIt records the usernames and passwords of all users when they are added to the OSDBA or OSOPER

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.

EIt supports the SYSBACKUP, SYSDG, and SYSKM system privileges.Correct

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

#password file#orapwd#SYSBACKUP SYSDG SYSKM#remote administration

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice