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
Is sql a dbms?
Write an sql query to select all records from the table?
Is postgresql a server?
What pl/sql package consists of?
What is coalesce in sql?
How exception handling is done in advance pl/sql?
How to run sql functions in pl/sql?
What are the advantages of sql? Explain
What are all the different normalizations?
how to add a new column to an existing table in mysql? : Sql dba
What are the types of index in sql?
What is offset in sql query?
What is difference between stored procedures and application procedures?
What is dcl in sql?
describe transaction-safe table types in mysql : sql dba