what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
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
Can you explain different types of joins?
Explain the different index configurations a table can have?
what method you can use to reduce the overhead of Reporting Services data sources?
Which trace flags are enabled in sql server?
How to change server name in sql server?
What is bookmark link in ssrs?
Explain the difference between clustered and non-clustered index?
How to use subqueries with the in operators in ms sql server?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Do you know what are the steps to process a single select statement?
How to connect a database with sql express.?
Explain sub-query?
What is the difference between a fill factor of 100 and 0?
What is acid mean in sql server?
Do you know what is similarity and difference between truncate and delete in sql?