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  >>  ERP CRM  >>  SAP  >>  ABAP
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question
what is Primary key and unique key and what is the 
Difference?
 Question Submitted By :: Naren
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is Primary key and unique key and what is the Difference?
Answer
# 1
PRIMARY KEY IS A FIELD WHICH IS USED TO IDENTIFY THE TABLE 
AND THESE CANNOT BE CHANGED, IF IT IS CHANGED THE DATA 
INTEGRITY WILL GET LOST.

UNIQUE KEY IS A GROUP OR A SINGLE FIELD WHICH IS USED TO 
REPRESENT THE NUMERIC FIELDS WHICH DOESNT CHANGE.
THE GROUP OF NUMERIC FIELDS IS THE UNIQUE KEY.

PRIMARY KEY IS USED FOR DATABASE TABLES WHERE AS UNIQUE KEY 
IS USED FOR INTERNAL TABLES.
 
Is This Answer Correct ?    0 Yes 2 No
Arun Prasad
 
  Re: what is Primary key and unique key and what is the Difference?
Answer
# 2
ABOVE ITS WRONG FOR UNIQUE KEY, SORRY.

UNIQUE KEY REFERS TO THE NON-NUMERIC KEY .
 
Is This Answer Correct ?    2 Yes 1 No
Arun Prasad
 
 
 
  Re: what is Primary key and unique key and what is the Difference?
Answer
# 3
Primary key does not allow the null values but where as in 
unique key accepts the null values.
 
Is This Answer Correct ?    3 Yes 1 No
Mahender Achhe
 
  Re: what is Primary key and unique key and what is the Difference?
Answer
# 4
Fields in UNIQUE CONSTRAINTs can be NULL. They cannot with PRIMARY KEYs.
You can define more than one UNIQUE KEY in a table.
Because of this, the behaviour of UNIQUE CONSTRAINTs
is very different from PRIMARY KEY constraints.
As long as one of the fields in a UNIQUE CONSTRAINT is NULL
the constraint itself does not apply and you can set the other fields
to whatever you want without getting an error.
 
Is This Answer Correct ?    1 Yes 0 No
Andsens
 

 
 
 
Other ABAP Interview Questions
 
  Question Asked @ Answers
 
What is the reason, a BDC program is working in 'A' mode but not in 'N' mode ? Syntel3
which transaction is used to make dictionary adjustments when upgrading versions of SAP?  1
layout conversion?  1
what is the use of STOP,EXIT,CHECK,CONTINUE in internal table? Accenture3
You are running a report. It is taking long time for execution. What steps will you do to reduce the execution time.  1
which select statement is used in script?  1
what is process code?  3
Explain about roll area , Dispatcher, ABAP-Processor?  2
How to Business addin function in Standars transactiion code. how it is steps Accenture3
are all BAPI S are autocommited? if not what should we do? Cap-Gemini3
Difference bet'n simple and interactive reports?  1
what is the difference between at selection-screen output and at selection screen? SAP-Labs1
Whom you report if you face difficulty in understanding the business process given in Functional Spec. ACS1
Select option?  2
what is the transaction code to create LOGO in sap scripts? IBM5
defination of workarea? and header line  1
IDOC,CDM ..explain?  1
How to create MEDRUCK form?  1
How many fields(max) can be there in a transparent table? Unilogic-Software1
Suppose Idoc is strucked in the Q then how can I resend it?  3
 
For more ABAP 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