what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 15878 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / jebastin unnatha raja
Joins-> Joins allow You to view and retrive the data from multible related tables in a single result set.
Primary key-> A primary key is used to uniquely identify each row in a table.A primary key columns can not contain a nULL values.
foriegn key-> A foreign key is a field (or fields) that points to the primary key of another table. The purpose of the foreign key is to ensure referential integrity of the data
super Key-> A superkey is a combination of attributes that can be uniquely used to identify a database record. A table might have many superkeys.
Candidate key-> A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are audit control procedures?
What are the two authentication modes in sql server?
what is a join? : Sql server database administration
What is correlated subquery in sql server?
How do I find the size of a sql server database?
Explain transaction server implicit?
What are the authentication modes in sql server? How can it be changed?
What are the advantages of mirroring?
How to call stored procedure using http soap?
What are the advantages of passing name-value pairs as parameters?
Introduction of rollup clause using sum and group by clause?
How do you troubleshoot errors in a SQL Server Agent Job?
what are different types of backups available in sql server? : Sql server database administration
Where in ms sql server is ’100’ equal to ‘0’?
What are the built in functions in sql server?
