what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
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 can you find out which stored procedures are recompiling?
Which tcl commands are available on the sql server?
How do I run sql server 2014?
What are the difference between “where” and “having” clause in sql server?
What are the differences between lost updates and uncommitted dependencies?
Explain datetime2 data type in sal server 2008?
what is a correlated sub-query? : Sql server database administration
What is tempdb database? : SQL Server Architecture
Explain what are partitioned views and distributed partitioned views?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are different types of subquery?
List the different types of collation sensitivities in sql server?
what kind of lan types do you know? : Sql server database administration
What is report subscription?
What is buffer cash and log cache in sql server?