Multiple choice

MILLER is an administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile as shown below, he receives the given error message. 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 is a mandatory system profile that cannot be dropped from Oracle database - it must always exist. MILLER has full DBA privileges, so this is not a permission issue (option B is incorrect). Option C is incorrect because SYS can drop most profiles it creates, but DEFAULT is special. Option D is incorrect because CASCADE is used when dropping a profile assigned to users, but DEFAULT cannot be dropped regardless.

Keep practicing — related questions