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
- 17231 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
What is the contrast between sql and mysql?
Explain go command in sql server?
Give a example to search fr a string in all stored procedure in sql server.
What is the web service used for reporting services?
What is Lock table in SQL?
Explain system rowset functions?
What is database replication?
Explain SSRS Architecture?
What is the use of tempdb? What values does it hold?
What is resource governor in sql server?
What is a View ? Can we insert, Update and delete a view?
Why do we use trigger?
Explain how many types of relationship?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Do you think BCNF is better than 2NF & 3NF? Why?
