When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.
A) do not use these two tables together
B) do not use the column names in the same statement
C) write both the table name and the column name, separated by a period
D) write the table name only

Question

When duplicate column names exist in a database and you need to indicate the column to which you are referring,____.​
A) ​do not use these two tables together
B) ​do not use the column names in the same statement
C) ​write both the table name and the column name, separated by a period
D) ​write the table name only

Quizplus · Accepted Answer

Writing both the table name and the column name, separated by a period, is called qualifying column names and is the best option when duplicate column names exist in a database. This helps to avoid ambiguity and ensures that the correct column is selected.

When Duplicate Column Names Exist in a Database and You