nerdexam
Oracle

1Z0-074 · Question #4

1Z0-074 Question #4: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #4. The question stem and answer options stay visible for context.

Question

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?

Options

  • AMake User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in
  • BGrant SYSRAC to user1.
  • CGrant SYSRAC to ops$user1.
  • DMake USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC
  • EGrant SYSDBA to ops$user1

Unlock 1Z0-074 to see the answer

You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-074 Practice