what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 15901 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / monal
Joins: Joins are used to retrieve data from two or more
tables when there is either matching row exist in another
table or not.
Primary Key: Primary key ensures uniqueness of data in a
table so that no two rows in the table can have same value.
Foreign Key: Foreign key ensures that data entered in a
column must be checked with data already entered in the
primary key column of another table.
Candidate Key: In some tables there is possibility that more
than one column can carry unique values to make sure
uniqueness of data all across the table. one of those key
column becomes Primary key and other column become candidate
key.
| Is This Answer Correct ? | 39 Yes | 9 No |
Post New Answer View All Answers
How do I start sql server 2017?
What is the purpose of indexing?
List some of the rules that apply to creating and using a ‘view’
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Suggest a method of joining two tables.
How do I view views in sql server?
What is the maximum size per database for sql server express?
What new data source types were added in ssrs 2014?
What is built-in/administrator?
What the different types of Replication and why are they used?
What is cursors? And what are the different types of cursor?
Explain transaction server distributed transaction?
What is difference between equi join and inner join?
What are the limitations/drawbacks or ssrs 2008 r2?
Can we do dml on views?
