You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable
databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the
password file?
A.
Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B.
Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument
set to No.
D.
Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set
to Yes.
E.
Re-create the password file in the Oracle Database 12c format.
Explanation:
* orapwd
/ You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname]
[FORMAT={12|legacy}] [SYSBACKUP={y|n}]
[SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force – whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted
the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
Column Datatype Description
USERNAME VARCHAR2(30) The name of the user that is contained in the password file SYSDBA
VARCHAR2(5) If TRUE, the user can connect with SYSDBA privileges SYSOPER VARCHAR2(5) If TRUE, the
user can connect with SYSOPER privileges
Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.