Interested to Buy Any Domain ? << Click Here >> for more details...
what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 17038 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 is the purpose of the tempdb database?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is blocking and how would you troubleshoot it? : sql server database administration
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What are distinctive joins find as a part of sql?
How to create an inline table-valued function?
How to run sql server 2005 books online on your local system?
What is spid in sql server profiler?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is master database? : SQL Server Architecture
Why do you need a sql server?
What is tablesample?
What is the difference between indexing and hashing?
Explain syntax for viewing, dropping and disabling triggers?
Explain triggers in sql?
