WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
THAN U.
- 1 Answers
- 5614 Views
- Synergy, I also Faced
- E-Mail Answers
Answer Posted / sakthi
Primary key:
It is an unique identifier, it wont allow null value, in a
table there will be only one column as primary key.
Composite key:
It same as Primary key but combination of more that one
column.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is the difference between set and select?
What are the tables in sql?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Does sql server 2016 have ssms?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is transaction server consistency?
What is SQL Server?
What happens if null values are involved in bitwise operations?
What are the properties of sub-query?
Write a program using SQL queries to find a unique entry in a table.
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are the dmvs?
What is the full meaning of dml?
Explain different forms of normalization?
List some of the rules that apply to creating and using a ‘view’
