what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 15324 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / vikash kr pandey
1> JOIN:- JOIN IS USED TO VIEW AND RETRIEVE DATA FROM MULTIPLE TABLE OR RELATED TABLES IN A SINGLE RESULT SET.
2> PRIMARY KEY:-PRIMARY KEY IS A SET OF COLUMNS WHOSE VALUES UNIQUELY IDENTIFY ALL THE ROWS IN A TABLE AND CAN NOT CONTAIN NULL VALUES.
3> FORIEGN KEY:-A COLUMN IN ONE TABLE WHOSE VALUES MATCH THE PRIMARY KEY IN SOME OTHER TABLE IS CALLED A FORIEGN KEY.
4> CANDIDATE KEY:-ANY ATTRIBUTE THAT IS UNIQUELY IDENTIFIES A ROW IN A TABLE IS A CANDIDATE FOR THE PRIMARY KEY. THIS TYPE OF ATTRIBUTE IS CALLED CANDIDATE KEY.
5> SUPER KEY:-THE SUPERTYPE IS DESCRIBED BY ATTRIBUTES THAT BELONGS TO ALL SUBTYPES AND CONNECTED TO THE RELATIONSHIP WITH A LINE CONTAINING A CROSSBAR.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to send a ssrs report from ssis?
What is difference between stored procedure and user defined function?
What is the process of normalising?
What is PROJECTION Operation?
Is candidate a key?
What are the types of resultset?
Describe and explain about SQL native client?
How global temporary tables are represented and its scope?
What triggers long term care?
What is difference between view and materialized view?
What is cursors? And what are the different types of cursor?
What should be the fill factor for indexes created on tables? : sql server database administration
Can you explain different types of locks in sql server?
What does ss stand for sexually?
Explain different types of Normalization.
