QUESTION 219-add users with the SYSBACKUP, SYSDG, and SYSKM privileges to the password file

You upgrade your database from pre-12c to a multitenant container database (CDB) that

contains plugable database (PDBSs)

Examine the query and its output:

SQL> SELECT * FROM V$PWFILE_users;

USERNAME SYSDB SYSOP SYSAS SYSDG SYSKM CON_ID

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

SYS TRUE TRUE FALSE FALSE FALSE 0

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

A. Assign appropriate operating system groups to SYSBACKUP, SYSDG, and SYSKM.

B. Re-create or migrate the password file to the Oracle Database 12c format.

C. Grant the SYSDBA, SYSDG, and SYSKM privileges to the intended users.

D. Copy the password file from a sample file in the DBS directory.

Correct Answer: AC

2、Administrative
Privilege Operations Authorized
SYSDBA  ■ Perform STARTUPand SHUTDOWNoperations
■ ALTER DATABASE: open, mount, back up, or change character set
■ CREATE DATABASE
■ DROP DATABASE
■ CREATE SPFILE
■ ALTER DATABASE ARCHIVELOG
■ ALTER DATABASE RECOVER
■ Includes the RESTRICTED SESSIONprivilege
This administrative privilege allows most operations, including the
ability to view user data. It is the most powerful administrative
privilege.

SYSOPER  ■ Perform STARTUPand SHUTDOWNoperations
■ CREATE SPFILE
■ ALTER DATABASE: open, mount, or back up
■ ALTER DATABASE ARCHIVELOG
■ ALTER DATABASE RECOVER(Complete recovery only. Any form of
incomplete recovery, such as UNTIL
TIME|CHANGE|CANCEL|CONTROLFILErequires connecting as
SYSDBA.)
■ Includes the RESTRICTED SESSIONprivilege
This privilege allows a user to perform basic operational tasks, but
without the ability to view user data.

SYSBACKUP  This privilege allows a user to perform backup and recovery
operations either from Oracle Recovery Manager (RMAN) or
SQL*Plus.
See Oracle Database Security Guidefor the full list of operations allowed
by this administrative privilege.

SYSDG  This privilege allows a user to perform Data Guard operations. You
can use this privilege with either Data Guard Broker or the DGMGRL
command-line interface.
See Oracle Database Security Guidefor the full list of operations allowed
by this administrative privilege.

SYSKM  This privilege allows a user to perform Transparent Data Encryption
keystore operations.
See Oracle Database Security Guidefor the full list of operations allowed
by this administrative privilege.