what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 179813 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / anbarasu
UNIQUE KEY: A Table may contain one or more UNIQUE
constraints. It’s allowing only one null value. Use this
key we maintain unique vales in the table.
FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys
must contain unique values, foreign keys may have
duplicates. For instance, if we use student ID as the
primary key in a Students table (each student has a unique
ID), we could use student ID as a foreign key in a Courses
table: as each student may do more than one course, the
student ID field in the Courses table (often shortened to
Courses. student ID) Will hold duplicate values.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ase database?
What is the Difference Primary key and Unique Key
Explain various types of locks in a transaction? Which is better and why?
Why do we need distributed database?
define primary key index, bitmap index, hash index,virtual indwx
How heap is implemented in database?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
What are the advantages of normalizing a database.
How does non-cluster index functions?
aht is the difference b/w network & hierarchial & relational dbms????
Explain file manager?
Explain natural key?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is difference between server and database?
Under which circumstance should you create an index on a table?
