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
- 16972 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
Can we insert data into a view?
Explain the database you used in your final year project?
What are audit control procedures?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is the purpose of indexing?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is your recommendation for a query running very slow? : sql server database administration
List out the difference between union and union all in sql server?
What are the different types of triggers in SQL SERVER?
Which language rdl files made of?
What is a filestream?
What do you mean by data integrity?
Do you know what are pages and extents? : SQL Server Architecture
How are the unique and primary key constraints different?
What is standby servers? Explain types of standby servers.
