what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 15323 Views
- Polaris, I also Faced
- E-Mail Answers
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
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
How do I run sql server 2014?
Explain left outer join and right outer join?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is the contrast between sql and pl/sql?
What are cursors stored procedures and triggers?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Explain following error properties?
What types of Joins are possible with Sql Server?
Explain isolation levels that sql server supports?
What is sql collation?
what is database replication? : Sql server database administration
How we can refresh the view?
What is difference between getdate and sysdatetime in sql server 2008?
What are the advantages of sql stored procedure?
