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 auto increment?
Can we commit in trigger?
Are sql connections encrypted?
how to use like conditions? : Sql dba
What is pl sql commands?
What are the packages in pl sql?
Is nosql faster than sql?
What do you mean by stored procedures? How do we use it?
What is query syntax?
What is the difference among union, minus and intersect?
How does cross join work in sql?
Why use triggers in sql?
Which certification is best for sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is full form of rtm?