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 it important to partition hard disk?
how can we destroy the cookie? : Sql dba
what tools available for managing mysql server? : Sql dba
What is oracle sql developer?
Show the two pl/sql cursor exceptions.
How to rename a column in the output of sql query?
What is sql*loader and what is it used for?
Is postgresql a nosql database?
what is the difference between where clause and having clause? : Sql dba
Why commit is not used in triggers?
Explain what is sql*plus?
tell us something about heap tables. : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
What are different functions in sql?
What is form and report?