what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
Answer Posted / karthik
Join is a keyword which is used to join two or more table.
The unique column in a table is called primary key.
If primary key acting as a normal attribute in some other
table then this attribute is called foreign key.
If table is having more than one unique attribute then the
rest of the attributes of primary key is called candidate key.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How many cores do I need for sql server 2016?
How to define and use table alias names in ms sql server?
What area unit the various kinds of info compression introduced in sql server 2008?
Give me any three differences between Truncate and Delete.
Explain alternate key, candidate key and composite key in sql server?
What is the difference in accessing db between sql server vs sql azure?
Detail about query optimizer?
What is the use of tempdb? What values does it hold?
How to find the source of a table in sql server?
What is tempdb in sql server?
What is the difference between push and pull subscription? : sql server replication
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What are scalar functions?
What are sub reports?
Is it possible to update the views? If yes, how, if not, why?