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
- 16821 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 are types of scd? : sql server analysis services, ssas
How to defragment indexes with alter index ... Reorganize?
Explain the truncate command?
What information is maintained within the msdb database?
What are indexes in sql?
Can you type more than one query in the query editor screen at the same time?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is sql azure database?
How to replace null values in expressions using isnull()?
What are the disadvantages of merge replication?
How can we remove orphan records from a table?
How to rename databases in ms sql server?
What it means to be triggered?
What command is used to rename the database?
What is the difference between deallocate cursor and close cursor?
