Answer Posted / 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 View All Answers
Can we use distinct and group by together?
what is bcp? When does it used? : Sql dba
What is the current version of postgresql?
what is schema? : Sql dba
what are aggregate and scalar functions? : Sql dba
how to start mysql server? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
How do I remove duplicates in two columns?
What is the current version of sql?
how to use regular expression in pattern match conditions? : Sql dba
Is primary key clustered index?
what are all the common sql function? : Sql dba
Is primary key always clustered index?
what is collation? : Sql dba
Can delete statement be rollbacked?
