what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 15902 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
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
How do users use Report Builder with SQL Server data sources?
Explain magic tables in sql server?
Difference between uniqe index and uniqe constraint?
What is abstracting periodical?
Where to find ntwdblib.dll version 2000.80.194.0?
How many partitions a clustered index has by default in sql server 2012?
What is the difference between dropping a database and taking a database offline?
Write query to return all rows sql?
What is the difference between getdate and sysdatetime?
How to return the date part only from a sql server datetime datatype?
What are the three different part of rdl file explain them?
Distinguish between nested subquery and correlated subquery?
What is raiseerror? What is raiseerror?
Why I am getting this error when dropping a database in ms sql server?
