what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / uma maheswari
primary key:
IT IS THE MAIN KEY AND IT DOES NOT ALLOWS THE NULL VALUE...
Unique key:
IT IS SIMILAR TO PRIMARY KEY .IT ALSO DONT ALLOWS THE NULL VALUE.
foreign key:
IT IS USED TO REPRESENT THE PRIMARY KEY VALUE...
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the concept of Virtual field?
What is a super key?
Explain inner and outer joins with examples.
How does non-cluster index functions?
What is a database string?
What is the difference between specialization and generalization?
Is data lake a database?
What is the use of default key?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
How to shrink a database?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What are different types of resources?
What is the difference between a stored procedure and a query?
How to do Data size testing? Who does this testing (Developer or tester)?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance