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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 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
What are primary keys and foreign keys?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are primary keys and foreign keys?
Answer
# 1
Primary keys are the unique identifiers for each row. They 
must contain unique values and cannot be null. Due to their 
importance in relational databases, Primary keys are the 
most fundamental of all keys and constraints. A table can 
have only one Primary key.
Foreign keys are both a method of ensuring data integrity 
and a manifestation of the relationship between tables.
 
Is This Answer Correct ?    1 Yes 0 No
Nevual
 
  Re: What are primary keys and foreign keys?
Answer
# 2
Primary key is a unique id for each table. This prevents 
duplication of records. Each table can have a single 
primary key. They can be refrenced by any tables as a 
foreign key.
 
Is This Answer Correct ?    1 Yes 0 No
Sudarsan
 
 
 
  Re: What are primary keys and foreign keys?
Answer
# 3
Primary keys are by default clustered index.
 
Is This Answer Correct ?    0 Yes 0 No
Jai Prakash Chauhan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the use of MOVE keyword in restore command IBM2
What is indexed views? plz explain with example?  1
Which TCP/IP port does SQL Server run on?  2
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs. APX2
How to find out name of all employees who has salary less than 200 Rs.?  7
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005  2
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me. 247Customer1
Is it possible to create tables in stored procedures using a variable for the table name?  2
When you first load SQL SERVER you will startup with what all databases? CompuSol3
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?  9
what purpose does OPENXML clause have in sql server stored procedure?  1
how to connect sybase to sql server 2005?. ABC1
1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them? Techno-Solutions1
How do you measure the performance of a stored procedure? Infosys1
how do u do Performance tunning ? Satyam1
how to rename the table  3
how to know description of a table in sqlserver 2000  7
How to Generate a Series of Random Integers With T-SQL?  1
Which data type can be used only on OUTPUT parameters of the stored proceduer?  2
explain different types of jions with examples briefly? Zensar3
 
For more SQL Server 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