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.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file
SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges
SYSOPERVARCHAR2(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.
B and E should be the correct answer
I believe is E general statement. For this question there is more closer statement D with listed sys accounts.
BD the password file is already in 12c format.
Based on screen output it assumes that password file is still not 12c format.
Have you passed 12c Upgrade exam?
BE is the correct answer. See in question that you have upgraded pre 12c database. I think that upgrade process does not upgrade the password file. So password file is still from version 11.
BD
for D .. If you recreate pasword file in 12c , format 12 is default.You have to specify SYSBACKUP,SYSDG and SYSKM as well.
Correct Answer is B,D
BD
BD
E is obviously incorrect because the output clearly shows that it is already in 12c format.
A: incorrect and also is C.
Hence the correct answers are: B, D
It’s said: add users with SYSBACKUP, SYSDG, and SYSKM privilege
B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
— So B is not needed because the intended user already have the related privilege which do not need grant again.
D, E can be the right one.
BD is right
I believe question should be asking with of the two options…
1) you can grant SYSBACKUP, SYSDG , SYSKM to user
or
2) you can force these with orapwd command like below.
orapwd file = entries=10 password=x format=12 sysbackup=y syskm=y sysdg=y force=y
So ANS is B or D. Two statements are not must. only one.
BD are correct. chose it in exam and passed it.
BD
Finished the Exam today successfully, But was very tensed until I saw the score of 80 and 81% in Certview, The Choices are Jumbled, you need to be absolutely spot on to remember the answers, Some of the very few questions ask for more choices than given here instead of two , they ask 3. Read and Answer the questions as many times as possible before taking the exam.
Best of Luck,
Congrats!!
And with regard to this question, the correct answers in the B and D?
Great Congrats !!