What is a primary key, and how is it different from a unique key?
- 3 Answers
- 526 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
• 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 are the two different parts of the pl/sql packages?
Enlist the characteristics of pl/sql?
What are the different types of triggers?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is pl sql collection?
What does the argument [or replace] do?
Does sql use python?
What is a full join?
how to see the create table statement of an existing table? : Sql dba
What is %type in pl sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Can a commit statement be executed as part of a trigger?
Is crud a cuss word?
Why function is used in sql?
What is full join?
