QUESTION $24$

What is true of foreign keys. Select the best answer from the following.

A$.$ A foreign is created by giving it the same name as the column that it matches in the primary $($parent$)$ table. The DBMS automatically links the tables based on the column names.

B$.$ A foreign key is a column or columns whose value is the same as the primary key of another table in the database. In some cases, a foreign key can be created within the same table as primary key, but this is rare.

C$.$ A foreign key is a hidden column in a table that contains multiple pieces of information so that two or more tables can be related together

D$.$ Foreign keys are not used in relational database design.