Multiple choice

A company hired ALLEN, a DBA who will be working from home. Allen needs to have the ability to start the database remotely.A password file was created for the database and REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE was set in the parameter file. Which of the following commands adds Allen to the password file, allowing him remote DBA access?

  1. GRANT DBA TO ALLEN;

  2. GRANT SYSDBA TO ALLEN;

  3. GRANT RESOURCE TO ALLEN;

  4. orapwd file=orapwdSTUD user=ALLEN password=DBA
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To grant remote DBA access in Oracle, you must grant SYSDBA privilege to the user. The GRANT SYSDBA TO ALLEN command adds Allen to the password file with SYSDBA privileges, allowing remote database startup and administration. Option A is incorrect because DBA is a role, not a privileged connection. Option D shows orapwd syntax for creating password files, not granting privileges.

Keep practicing — related questions