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
- 16822 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
Do you know data definition language, data control language and data manipulation language?
What command would you use to create an index?
What is store procedure?
Can you explain different types of joins?
How do you start single user mode in clustered installations?
How do I start sql server 2017?
What is the full form of ddl?
Mention the command used to rename the database.
Explain partitioned view?
What is a non-clustered index?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Why use “nolock” in sql server?
How do I start sql server agent automatically?
What are the methods used to protect against sql injection attack?
Explain index in sql server?
