1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

hi,i want t0 knom d syntax for a super key with an example

Question Posted / skskumar_18


hi,i want t0 knom d syntax for a super key with an example..

Answer / shikha

PersonID
PersonID + LastName
PersonID + FirstName
PersonID + DOB
PersonID + LastName + FirstName
PersonID + LastName + DOB
PersonID + FirstName + DOB
PersonID + LastName + FirstName + DOB
LastName + FirstName + DOB
All of these will uniquely identify each record, so each
one is a superkey. Of those keys, a key which is comprised
of more than one column is a composite key; a key of only
one column is a simple key.

A candidate key is a superkey that has no unique subset; it
contains no columns that are not necessary to make it
unique. This table has 2 candidate keys:

PersonID
LastName + FirstName + DOB
Not all candidate keys make good primary keys: Note that
these may work for our current data set, but would likely
be
.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

How can we Use Linked Server? Uses of Linked server

1 Answers   IBM,

What do you mean by tablesample?

0 Answers  

can you any body tell me the how to decrease the logfile

4 Answers  

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  




What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

What do you understand by a view?

0 Answers  

What are out-of-range errors with date and time literals?

0 Answers  

do views contain data ?

0 Answers   MCN Solutions,

How to create a simple stored procedure in ms sql server?

0 Answers  

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

For more SQL Server Interview Questions Click Here
Categories