what is primary key,unique key, foreign key? can u teach me
in simple language?
- 44 Answers
- 179777 Views
- Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rama
primary key:primary key is not allowed null values and
duplicate values.
unique key: this key allows null values but does not allow
duplicate values.
foreign key:
this key is used to refer another table.(i.e)other table
primary key values is used in foreign key table.it makes
relation ship between two tables.
| Is This Answer Correct ? | 19 Yes | 10 No |
Post New Answer View All Answers
How many indexes can be created on a table?
How is image stored in database?
How to implement database security?
if i want to display the name of students such that to which city they belong must have count greaer than two
How many types of locks are present in a database?
What is sharded database?
What is the purpose of TNS?
What are different types of blocks used in stored procedure?
aht is the difference b/w network & hierarchial & relational dbms????
What are the types of indexes that are present inside a database?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
how can we view column head in first page but not in remaining pages?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?
What is the use of default key?
