What is a primary key, and how is it different from a unique key?
Answer Posted / hr@tgksolutions.com
• Primary Key:
o Ensures each row in a table is unique.
o Cannot contain NULL values.
o A table can have only one primary key.
• Unique Key:
o Ensures all values in a column are unique.
o Can contain a single NULL value.
o A table can have multiple unique keys.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is application trigger?
Which data type is a composite type?
what is the difference between delete and truncate statement in sql? : Sql dba
What are tables in sql?
What is pl sql in oracle?
What is mutating sql table?
What is the life of an sql statement?
What is schema in sql?
what are the difference between clustered and a non-clustered index? : Sql dba
What is rtm in testing?
Cite the differences between execution of triggers and stored procedures?
Why do we use partitions in sql?
Is sql a backend language?
What is trigger point?
Does inner join return duplicate rows?