what is primary key,unique key, foreign key? can u teach me
in simple language?
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 relationship that exists inside in E-R diagram?
If the master device is full, how do I make the master database bigger?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
i have windows-xp processor with P4 system. whenever I tried to download foxpro for windows 2.6 on windows XP, my operating system failed to install foxpro for windows 2.6.please. how could i download , install & run foxpro for windows 2.6 easily on windows XP ?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is a sequence? Explain it with one example?
Data structure used to implements a menu:
Explain the record term used in database.
aht is the difference b/w network & hierarchial & relational dbms????
What is a reference table in database?
define primary key index, bitmap index, hash index,virtual indwx
What is lagging in DBMS ?
Should I store images in database?
What is the Lock Based Protocol used for?