Which three statements are true about the users (other than sys) in the output?

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

A.
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

B.
The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

C.
The C # # A_ADMIN user can perform wallet operations.

D.
The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage
Management (ASM).

E.
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or
SQL* Plus.

Explanation:
A: a SYSBA can perform backup and recovery operations.
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup
and shutdown) using Data Guard Broker or dgmgrl.
Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption
wallet operations.



Leave a Reply 11

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


Sunil

Sunil

Should be B, D and E.

A is not correct. E option can replace A

noori

noori

Hi Sunil what about c?

JRD

JRD

The correct answers are: BDE; C wrong

Shawn

Shawn

I think it is B, C and E.

C is right: “The SYSKM administrative privilege enables the SYSKM user to manage Transparent Data Encryption (wait for it…) wallet operations!”

D is wrong, we don’t “backup and recover” ASM. You should rather try it on your database.

Eder Couto

Eder Couto

B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup
E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database

Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.

Daniel

Daniel

Hi Shawn,

Regarding the “backup and recover” ASM, I kind of agree with you about the recovery bit. However, you can indeed backup and restore the ASM Metadata using md_backup and md_restore.

I wonder if one can discard D as it uses the word “Recover”…

Regards

k

k

SYSDBA – username SYS/PUBLIC – same system operations and privileges as 11g and earlier
SYSOPER – username SYS/PUBLIC – same system operations and privileges as 11g and earlier
SYSASM – username SYS – privileges for administering an ASM instance only (first introduced in 11g)
SYSBACKUP – username SYSBACKUP – the ability to perform RMAN backup and recovery commands both from SQL and RMAN command line – new in 12c
SYSDG – username SYSDG – the ability to perform Data Guard operations with Data Guard Broker or the DGMGRL command line – new in 12c
SYSKM – username SYSKM – the ability to manage the encryption keys for Transparent Data Encryption – new in 12c