what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 174616 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sriniwaas41
dublicate values- means two same values not allowed
primary key:does not allow null values and does not allow
dublicate v
alues
-reapeated values and null values not allowed
-we can use primary key only once in a table
unique key:
-reapeated values not allowed as per primary key.
-but the difference is null values are allowed
-another difference is we can declare more thatn one
unique column in a table.primary is not allowed
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between specialization and generalization?
What is a Database?
define primary key index, bitmap index, hash index,virtual indwx
Can a database table exist without a primary key?
What is ole db used for?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
What is database schema name?
How heap is implemented in database?
What are the disadvantages of views in a database?
What is difference between data and database?
List some advantages of dbms.
Explain the table term used in database.
Does facebook use graph database?
What is meant by distributed system?
