Exit 1Z0-074 Upgrade Oracle DBA 11g or 12c to 12c R2
Question 4 of 5
0% complete
Q4 Single choice

USER1 is an OS user with the password oracle and is only a member of the oinstall group.
In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.

Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally;
SQL> GRANT create session TO ops$user1;

How can USER1 be given the SYSRAC privilege?

  • A

    Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

  • B

    Grant SYSRAC to user1.

  • C

    Grant SYSRAC to ops$user1.

  • D

    Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

  • E

    Grant SYSDBA to ops$user1