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
State some properties of relational databases?
What are conditional predicates?
Are sql connections encrypted?
How much does sql cost?
What is memory optimized?
What are the different operators available in sql?
What is scalar data type in pl sql?
What has stored procedures in sql?
Differentiate between syntax and runtime errors.
What is on delete set null?
Is subquery faster than join?
what is single byte over head in oracle..?
What are the uses of sysdate and user keywords?
Is oracle and sql same?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?