Multiple choice technology databases

What are the DML statements you can use on a synonym created for a table?

  1. Select

  2. Insert

  3. Update

  4. Delete
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Explanation

Synonyms function as transparent aliases for underlying tables, supporting full DML operations. You can execute SELECT, INSERT, UPDATE, and DELETE statements on a synonym just as you would on the base table itself. The synonym simply redirects the operation to the actual table, so all standard table operations are available. This makes synonyms useful for simplifying long table names or providing location-independent references.

Keep practicing — related questions