ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  DB Development
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Define candidate key, alternate key, composite key? 
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 1
A composite Key can be either Primay or Unique Key
More then One Key columns are said to be composite keys

Candidate Key(Primary Key) is a Key which Maintains the Row 
Uniue .Can be defined based on the Entity


Alternate Key or Unique Key is similar to PK ,except it 
accepts null Values .So that the records can still be 
entered submitting null values to this attribute.
 
Is This Answer Correct ?    9 Yes 14 No
Ramesh
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 2
primary key:-  The attribute or combination of attributes
that uniquely identifies a row or record.

Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.

Composite key:- A primary key that consistsof two or more
attributes is known as composite key

candidate key:-  is a column in a table which has the
ability to become a primary key.

Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
 
Is This Answer Correct ?    27 Yes 3 No
Piyush Kathayat
 
 
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 3
candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a 
table, in which one should be a primary key.

alternate key:-In the candidate key the key which is not 
primary key is the alternate key.

composite key:- A key formed bythe combination of 2 or more 
columns is the composite key.
 
Is This Answer Correct ?    7 Yes 3 No
Deepak V
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 4
A candidate key is able to identify a unique tuple in a 
relation through an attribute or attribute set.

A foreign key makes sure that a tuple in a relation does 
not match a tuple in another relation which does not exist
 
Is This Answer Correct ?    1 Yes 4 No
Jeff
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 5
Candidate Key.....???? Help me out..!!!!!
 
Is This Answer Correct ?    3 Yes 1 No
Nnnn
 
  Re: Define candidate key, alternate key, composite key?
Answer
# 6
A candidate key is one that can identify each row
of a table uniquely. Generally a candidate key becomes the
primary key of the table. If the table has more than one
candidate key, one of them will become the primary key, and
the rest are called alternate keys.
           A key formed by combining at least two or more
columns is called composite key.
 
Is This Answer Correct ?    2 Yes 0 No
Kumaresan Chandran
 

 
 
 
Other DB Development Interview Questions
 
  Question Asked @ Answers
 
What is an extended stored procedure?  1
What are the disadvantages of cursors? How can you avoid cursors?  1
What is the system function to get the current user's user id?  1
Given an employee table, how would you find out the second highest salary?  4
What is denormalization and when would you go for it?  2
what is Normalization? TCS2
What is normalization? Explain different levels of normalization? IBM2
What are cursors? Explain different types of cursors?  3
Explain the general syntax for a SELECT statements covering all the options.  2
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? SQL-Star1
What are defaults? Is there a column to which a default can't be bound?  1
how will I find the duplicate rows count from employees tablein oracle.  1
What is a self join? Explain it with an example?  2
Define candidate key, alternate key, composite key?  6
What is bit datatype and what's the information that can be stored inside a bit column?  2
 
For more DB Development Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com