Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the difference between adding keys & constraints
into a phisical file

Answers were Sorted based on User's Feedback



what is the difference between adding keys & constraints into a phisical file..

Answer / cyjil

CONSTRAINTS ARE ADDED EXTERNALLY .... BUT KEYS ARE ADDED
INTERNALLY..

Is This Answer Correct ?    6 Yes 1 No

what is the difference between adding keys & constraints into a phisical file..

Answer / kkk

Contraints check the existing data
But keyfields doesnot check the existing data.

Is This Answer Correct ?    4 Yes 0 No

what is the difference between adding keys & constraints into a phisical file..

Answer / praseetha sandeep

when we add keys in a pf it has effect only in that
particular field of pf but when we add constrains to a pf it
has an effect to entire pf

Is This Answer Correct ?    5 Yes 2 No

what is the difference between adding keys & constraints into a phisical file..

Answer / megha

1. Keyfileds are with in DB and constraits are added from
addpfcst command externally

2. Using Addpfcst you can maintain the referential integrity

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB400 Interview Questions

How to retrieve a physical file after deleting that?

0 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,


YOU CAN DELETE THE RECORD SPACE PERMENANTLY IN PHYSICALFILE THROUGH CL?

4 Answers  


Which keyword is used both in subfile and subfile control record format of a DSPF?

8 Answers  


Define interactive jobs and batch jobs

6 Answers  


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


how to eliminate the level check error

2 Answers   TCS,


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  


When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  


i have a PF,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in PF

3 Answers  


What is the batch job?

0 Answers  


what is multiple member pf

1 Answers   Active Brains,


Categories