Why is a primary key important?



Why is a primary key important?..

Answer / Geeta

A Primary Key is crucial in a database for several reasons: It uniquely identifies each record within a table, ensuring data integrity by preventing duplicate records. It serves as a foreign key in other tables, maintaining referential integrity. It can significantly improve query performance due to the ability to quickly find specific records. Lastly, it is an essential part of the relational model.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can you sum a count in sql?

1 Answers  


How do I upgrade sql?

1 Answers  


write a query to display diference between two dates in sql server

2 Answers  


How do we accept inputs from user during runtime?

1 Answers  


Compare SQL and PL/SQL.

3 Answers  


how to shut down the server with 'mysqladmin'? : Sql dba

1 Answers  


What is schema in sql example?

1 Answers  


Authentication mechanisms in Sql Server ?

1 Answers   BirlaSoft,


What is the difference between delete and truncate statement in sql?

1 Answers  


what is inline command?

2 Answers  


What is clause?

1 Answers  


How to trace the errors in pl/sql block code?

5 Answers   TCS,


Categories