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
Can we take the full database backup in log shipping?
Can the “if update (colname)” statement be used in a delete trigger?
What does executeupdate return?
What is the beast way to write CTE in SQL Server ?
How to create dbo table in sql server?
what are the reporting service components in SSRS?
Tell me what is a linked server?
Explain why variables called the most powerful component of ssis?
What are various aggregate functions that are available?
How to create a user name in a database?
What is difference between foreign key and unique key?
What are the advantages of partitioning?
What are the steps you can take to avoid “deadlocks”?
What do you mean by collation recursive stored procedure?
What is an indexing strategy?