What is a primary key, and how is it different from a unique key?
- 3 Answers
- 525 Views
- I also Faced
- E-Mail Answers
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
Differentiate between syntax and runtime errors.
How do you write an inner join query?
what are the t string functions available in tsql? : Transact sql
Is inner join same as self join?
Do we need to rebuild index after truncate?
What is thread join () in threading?
How do I view stored procedures?
Mention what is the use of function "module procedure" in pl/sql?
how to create a test table in your mysql server? : Sql dba
What is memory optimized?
Explain sql data types?
What are the three pl sql block types?
How do I truncate a sql log file?
what does it mean to have quoted_identifier on? : Sql dba
What is difference between hql and sql?
