Multiple choice

MILLER is an administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile as shown, he receives the error message shown. Which of the following options best explains this error?

SQL> drop profile SYS.DEFAULT;

drop profile SYS.DEFAULT

*

ERROR at line 1:

ORA-00950: invalid DROP option

  1. The DEFAULT profile cannot be dropped.

  2. MILLER requires the DROP PROFILE privilege.

  3. Profiles created by SYS cannot be dropped.

  4. The CASCADE option was not used in the DROP PROFILE command.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DEFAULT profile in Oracle is a special system profile that cannot be dropped. Oracle requires this profile to exist as a fallback for users who are not explicitly assigned other profiles. Even a user with FULL DBA privileges cannot drop it because it's a protected system object. The error message ORA-00950 indicates an invalid DROP option for this reason. Option B is incorrect because DBA privileges already include all necessary permissions. Option C is incorrect because SYS-created objects can generally be dropped unless they're protected like DEFAULT. Option D is incorrect because CASCADE is used for profiles with assigned users, not for DEFAULT itself.

Keep practicing — related questions