1Z0-083 · Question #254
You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output: SQL> SELECT * FROM v $PWFILE_users…
The correct answer is A. Re-create or migrate the password file to the Oracle Database 12c format B. Grant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users. Upgrading from pre-12c introduced three new administrative privileges (SYSBACKUP, SYSDG, SYSKM), but the old password file format lacks the columns to store them - as evidenced by the query output showing FALSE placeholders and the file still being in legacy format. You must…
Question
You upgrade your database from pre-12c to a multitenant container database (CDB) that contains pluggable databases (PDBs). Examine the query and its output:
SQL> SELECT * FROM v $PWFILE_users; USERNAME SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM CON_ID ----------------------------- ------------------------------------------- SYS TRUE TRUE FALSE FALSE FALSE FALSE 0 Which two tasks must you perform to add users with the SYSBACKUP, SYSDG, and SYSKM prileges to the password file?
Options
- ARe-create or migrate the password file to the Oracle Database 12c format
- BGrant the SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- CCopy the password file from a sample file in the DBS dierectory
- DAssign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.
How the community answered
(22 responses)- A77% (17)
- C5% (1)
- D18% (4)
Explanation
Upgrading from pre-12c introduced three new administrative privileges (SYSBACKUP, SYSDG, SYSKM), but the old password file format lacks the columns to store them - as evidenced by the query output showing FALSE placeholders and the file still being in legacy format. You must first re-create or migrate the password file to 12c format (using orapwd with format=12) so it gains the new privilege columns, and then GRANT the desired privileges to the intended users so their entries are written into that file.
C is wrong because copying a sample file from the $ORACLE_HOME/dbs directory gives you an empty skeleton with no real credentials or structure tied to your database instance. D is wrong because OS group membership (like backupdba, dgdba, kmdba) enables OS-authenticated local connections, but password file entries are required for remote privileged authentication - the two mechanisms are independent.
Memory tip: Think "Format Before Grant" - you can't grant what the file can't hold, so always upgrade the container before adding new privilege entries.
Topics
Community Discussion
No community discussion yet for this question.