What is a primary key, and how is it different from a unique key?
Answer Posted / glibwaresoftsolutions
• 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 normalization? : Sql dba
Is sql a backend?
Why are sql stored procedures used?
What is left join in postgresql?
What is the least restrictive isolation level? : Transact sql
What is trigger in pl sql with examples?
Does google use sql?
Can we use insert statement in function?
What is the difference between rollback and rollback to statements?
How can you fetch common records from two tables?
What is AUTH_ID and AUTH_USER in pl/sql ?
In what condition is it good to disable a trigger?
Can we use distinct and group by together?
What is a file delimiter?
What are the different ways to optimize a sql query?