Podcast
Play an AI-generated podcast conversation about this lesson
Questions and Answers
What is a primary key in a relational database?
What is a primary key in a relational database?
- A field that allows null values
- A unique identifier for each record in a table (correct)
- A foreign key in another table
- A field that stores duplicate values
What is the purpose of a foreign key in a relational database?
What is the purpose of a foreign key in a relational database?
- To enforce uniqueness of values in a column
- To define the data type of a column
- To establish a link between two tables (correct)
- To store duplicate values in a column
What is the role of SQL in a relational database management system?
What is the role of SQL in a relational database management system?
- To secure network communication
- To query and manipulate data (correct)
- To design user interfaces
- To optimize database storage
