Songdew Executive Producer Interview Questions and Answers

It was good but prepared on technical basis

Q1. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be NULL

• Example: In a table of students, student ID can be a primary key
Answered by AI
Add your answer
Q2. What is foreign key
Ans. 
Foreign key is a column or a set of columns in a table that uniquely identifies a row in another table.
• A foreign key establishes a relationship between two tables in a database.

• It ensures referential integrity by enforcing a link between the data in the two tables.

• Foreign key constraints prevent actions that would destroy links between tables, such as deleting a row that is referenced by another table.

• Example: In a dat...read more
Answered by AI
Add your answer