Interested to Buy Any Domain ? << Click Here >> for more details...
What is a primary key, and how is it different from a unique key?
- 3 Answers
- 1260 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
How many columns should be in an index?
What is rename in sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the difference between local and global temporary table?
what is single byte over head in oracle..?
What is t sql in sql server?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is the difference between delete and truncate statement in sql?
Explain the difference between drop and truncate commands in sql?
Can delete statement be rollbacked?
What problem one might face while writing log information to a data-base table in pl/sql?
How do I run sql profiler?
What is oracle sql called?
Is it possible to create startup or shutdown trigger for on-schema?
What is procedure and function in sql?
