what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / mohamed ibrahim
Primary Key :- Is a unique identify a table data,it is avoid null and duplicate value.In a table we can assign single primary key.
Unique Key :- Is same as primary key but it allow single null value and avoid duplicate value.In a table we can assign more than one no of unique key.
Foreign Key :- Is a connect two table from a single column name.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
WHAT IS CARDINALITIES OF JOIN?
What are the advantages of normalizing a database.
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What is ole db used for?
How heap is implemented in database?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
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
How do you pass parameter in stored procedure?
What are the types of indexes that are present inside a database?
What is the best database software for small businesses?
Give the syntax of exception handling used in DBMS?
What are the tools used for backup and ticketing?
What is the candidate key used for?
What is a sequence? Explain it with one example?
What is dialect in database?