Which command will create a synonym for a table?
A) CREATE SYNONYM synonymname IN tablename;
B) CREATE SYNONYM synonymname ON tablename;
C) CREATE SYNONYM synonymname REFERENCE tablename;
D) CREATE SYNONYM synonymname FOR tablename;

Question

Which command will create a synonym for a table?​
A) ​CREATE SYNONYM synonymname IN tablename;
B) ​CREATE SYNONYM synonymname ON tablename;
C) ​CREATE SYNONYM synonymname REFERENCE tablename;
D) ​CREATE SYNONYM synonymname FOR tablename;

Quizplus · Accepted Answer

The correct syntax for creating a synonym for a table is "CREATE SYNONYM synonymname FOR tablename". Option D is the only choice that follows this syntax.

Which Command Will Create a Synonym for a Table?​

Which Command Will Create a Synonym for a Table?