what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / siya
Primary Key:- The primary key is the key which is uniquely
identifing in a table which not take null value for that
particular field and we don't take dublicate value for that
key.
Foreign Key:- Foregin Key is a key which define the primary
key into another table or any particular field of primary
key.
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
if i want to display the name of students such that to which city they belong must have count greaer than two
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What is the function of cluster index?
how can you perform lookup range in lookup stage expalin in detail?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What is the use of graph database?
What is the difference between primary key, foreign key and candidate key?
What is replicaset?
Explain inner and outer joins with examples.
Explain the field term used in database.
What is the difference between a stored procedure and a query?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What happens when shared and exclusive locks are applied on data item?
What is difference between data and database?