Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

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?

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.



Leave a Reply 10

Your email address will not be published. Required fields are marked *


Noname

Noname

A, E

Noname

Noname

Sorry, It should be B, E. D is wrong because you cant recreate pwdfile with “privileges”.

winner2001

winner2001

B, D is the correct answer because y=in 12c you can create pwdfile with privileges.

Check – http://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11059

Creating a Database Password File with 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]

Di

Di

Thanks winner2001

rtp101

rtp101

Only B
There is no need to recreate password file.
Granting privilidges to users will create apropriate entries in password file.

Morilla

Morilla

You have two ways to give the privileges, one, when you create the password file and the second when you assign the privilege in the database to “grant”