Question

DDL statements not used for Synonym is __________

(a) CREATE SYNONYM

(b) DROP SYNONYM

(c) ALTER SYNONYM

(d) None of the mentioned

I have been asked this question in a national level competition.

This key question is from Data Definition Language topic in section Creating the Physical Database Schema of SQL Server

Answer 1

The correct choice is (c) ALTER SYNONYM

For explanation I would say: Synonyms allow client applications to use the single-part name of a synonym to reference a base object.