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  >>  Microsoft Related  >>  ASP.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 SharePoint interview questions  SharePoint Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
can u create two Primary key for a table?
--Sivaa
 Question Submitted By :: Sivaprakasam
I also faced this Question!!     Rank Answer Posted By  
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 1
No
 
Is This Answer Correct ?    4 Yes 1 No
Sivaprakasam
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 2
S we can create its called composite key

ALTER TABLE TableName
 ADD CONSTRAINT CONSTRAINT _Name
  PRIMARY KEY (attribute1,attribute2)
 
Is This Answer Correct ?    6 Yes 0 No
Purushotham
 
 
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 3
no,we can't create two primary key's in 1 table.
 
Is This Answer Correct ?    1 Yes 3 No
Rambhopal Reddy
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 4
No, we cannot create more than one Primary key for a table. 
Composite Primary key as mentioned in the answer by 
Purushotham consists of more than one columns together 
making a Primary key. In such a case the columns may be 
more than one but the Primary key is one.
 
Is This Answer Correct ?    6 Yes 0 No
Monalisa Behera
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 5
No, we can't create two primary keys for a table. A table 
contains only one primary key.
A table can have one or more unique keys.
 
Is This Answer Correct ?    1 Yes 2 No
Santosh
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 6
It depends.
but we can use 2 primary key per table.
 
Is This Answer Correct ?    0 Yes 3 No
Saiish Bhat
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 7
no, we can't create more than 1 primary key on a 
table .Monalisa Behera is correct we can add more than 1  
columns together to make primary key.Srry misleading in 
earlier post
 
Is This Answer Correct ?    2 Yes 1 No
Purushotham Tella
 
  Re: can u create two Primary key for a table? --Sivaa
Answer
# 8
no we cant create 2 primary keys
 
Is This Answer Correct ?    0 Yes 1 No
Raghunath
 

 
 
 
Other ASP.NET Interview Questions
 
  Question Asked @ Answers
 
What is Http handler? Accenture4
what is the requirement that .Net web services can access the java application? iSoft6
In a page u have Web user controls . So what is the order in which the Page life Cycles takes place?  1
Can you store dataset in viewstate? Microsoft3
What is the difference between Postback and Ispostback Property? HCL2
How many column in table of sql server?  3
For a webapplication if i want to gice access controls like admin,users how can i give security like rolebased? Syncfusion1
what is manifest? Microsoft3
How to convert a string into an Integer in ASP.net?  6
Types of caching. How to implement caching? Microsoft2
How do we get only edited/deleted/inserted records from a Dataset? Syntax-Softtech1
is it possible to access website from a remote place, without deploying it on web server?  1
Which data types are supported by the RangeValidator control?  2
What definition correctly defines a label server control with the name set to lblHoop? a) <asp:Label name=?lblHoop? runat=?server? /> b) <Label id=?lblHoop? runat=?server? /> c) <asp:Label id=?lblHoop? runat=?server? /> d) <server label name=?lblHoop? runat=?asp? /> Syntax-Softtech1
How do you do exception management? Accenture1
What data types do the RangeValidator control support?  2
What are Themes? What is their use ?  1
How do you bind array to gridview? Will it works? HP4
1. What is the difference between Cache and Session? 2. I cache limited to page like viewstate or it's accessible through out the application like session? 3. Which one is better when I've some data that is to be used across the application? Why is to better than the other? 247Customer1
what is asp.net  10
 
For more ASP.NET 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