what is the difference between unique and primary key

Answer Posted / vinod

uniqe key allow one null value only but primary key cannot
allow any null value

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the disadvantages of a query?

532


Define dml compiler.

613


What is rdbms architecture?

512


What is the purpose of a database?

537


Explain what are tp-lite and tp-heavy monitors?

512






What do you mean by deadlock dbms?

539


Which free database is best?

453


Why do we study dbms?

499


What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

460


What is the normal procedure followed by a java client to access the db?

436


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1341


What is meant by database management system?

483


How many number of columns can a RECORD GROUP have ?

1583


Why is data modelling important?

461


What are the different types of data tables?

467