QUESTION 50

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

sql>select * from v$pwfile_users;

username    sysdb    sysop    sysas     sysdg    sysem    con_id

-----------------------------------------------------------------------

sys true true false false false  0

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 t he Oracle Database 12c format.

Correct Answer: BD

(解析： Administrative Privileges

Administrative privileges that are required for an administrator to perform basic

database operations are granted through the following special system privileges:

■ SYSDBA

■ SYSOPER

■ SYSBACKUP

■ SYSDG

■ SYSKM

您必須擁有其中一個授予您的特權(quán)，這取決于您需要的授權(quán)級別。

從 Oracle 數(shù)據(jù)庫 12c 開始，可以使用 SysBackup、SysDG 和 SysKM 管理權(quán)限。每個新的管理權(quán)限都授予完成每個管理領(lǐng)域任務(wù)所需的最低權(quán)限。新的管理權(quán)限使您能夠避免授予 sysdba 管理權(quán)限對于許多常見的任務(wù)。

查詢使用密碼文件是用戶：

SQL> select * from v$pwfile_users;

)