Multiple choice

Which SQL phrase is not supported by Oracle?

  1. ON DELETE CASCADE

  2. ON UPDATE CASCADE

  3. CREATE SEQUENCE [SequenceName]

  4. DROP SEQUENCE [SequenceName]
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle SQL supports ON DELETE CASCADE for foreign key constraints, which automatically deletes child rows when the parent row is deleted. However, Oracle does not support ON UPDATE CASCADE - this is a MySQL-specific feature. If you need to update primary key values, you must manually update all dependent foreign key values or recreate the rows. Options A, C, and D are all supported Oracle SQL statements.

Keep practicing — related questions