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 pl sql package?
Can you sum a count in sql?
What are the advantages of sql? Explain
What does seeding a database mean?
What is nvl?
What are the constraints available in sql?
What are packages in pl sql and also explain its advantages?
differentiate between float and double. : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How do I view tables in sql developer?
what is a database lock ? : Sql dba
Define commit?
What is a parameter query?
how to calculate expressions with sql statements? : Sql dba
What are aggregate and scalar functions?