what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / nitin kumar
A primary key is one which uniquely identifies a row of a
table. This key does not allow null values and duplicate
values.
A foreign key is one which identifies a set of columns in a
table or enforce link between the in two tables.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is ole db in ssis?
How does database replication work?
How to do Data integrity testing? Who does this testing (Developer or tester)?
What is a database call?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
Is hive a database?
What are the advantages of views in a database?
What is a trace file?
WHAT IS CARDINALITIES OF JOIN?
Write a query to retrieve for many to many relationships?
What is database and its types?
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 a database lookup?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
Explain alternate key?