what are the joins,primary key,foriegn key, candidate key,
super key and expain them?

Answer Posted / hari

Joins are retrive the data multiple tabels
primary key ;-doesn' allow null vales

Is This Answer Correct ?    24 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you choose between a clustered and a non-clustered index?

547


Write a sql query to get zero records from a table having n number of records?

709


How will you optimize a stored procedure optimization?

517


What is subquery explain with example?

616


Explain system rowset functions?

558






What is normalization? Explain its different types?

604


Is a primary key unique?

540


What authentication modes does sql server support?

599


What is the difference between migration and upgradation in sql server?

608


Tell me the phases a transaction has to undergo?

552


Is INSTEAD OF trigger directly applicable to Table ?

575


How to delete duplicate rows from table except one?

545


What is difference between getdate and sysdatetime in sql server 2008?

600


Explain indexed views and partitioned view with their syntax.

688


What are the disadvantages of primary key and foreign key in SQL?

634