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
Explain architecture of sql server notification services?
Is sql harder than python?
What is sql catalog?
Can variables be used in sql statements?
What is a sql trace file?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How do you concatenate in sql?
How global cursor can be declare with dynamic trigger ?
What is asqueryable?
What is basic structure of pl sql?
Why is sql*loader direct path so fast?
What is consistency?
What are system versioned tables?
what is error ora-03113: end-of-file on communication channel?
What is thread join () in threading?