Database Analyst Question:

Download Job Interview Questions and Answers PDF

Tell me what are the differences between primary and foreign keys?

Database Analyst Interview Question
Database Analyst Interview Question

Answer:

The primary key is the column or set of columns used to uniquely identify the items in a table. A foreign key is used to uniquely identify the items in a different table, allowing join operations to happen.

Download Database Analyst Interview Questions And Answers PDF

Previous QuestionNext Question
Explain me what is self JOIN?Tell me what is the criteria to say whether a developed data model is good or not?