What is a primary key, and how is it different from a unique key?
Answer Posted / nashiinformaticssolutions
• 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 the difference between left and left outer join?
What is a composite primary key?
What is oracle pl sql developer?
How to raise user-defined exception with custom sqlerrm ?
What is indexes?
What is sql keyword?
Why trigger is used in sql?
explain normalization concept? : Sql dba
What is an example of translating a date into julian format?
What is the difference between microsoft access and sql server?
What is the use of triggers?
what are numeric data types? : Sql dba
what is table? : Sql dba
Is mariadb nosql?
Explain raise_application_error.