what is primary key,unique key, foreign key? can u teach me
in simple language?
Answer Posted / kavita ahuja
primary key is an attribute or set of attribute of a table
that uniquely identified each record whereas foreign key is
the attribute that is used to create relation between two
tables.and the values for foreign key must match with the
values of primary key to which it refers.
| Is This Answer Correct ? | 21 Yes | 12 No |
Post New Answer View All Answers
What are the types of indexes that are present inside a database?
Explain the field term used in database.
What is dialect in database?
Explain database partitioning. What is its importance?
What is the difference between oracle and MS Access?
Write a query to retrieve for many to many relationships?
Differentiate between delete and truncate table?
How to implement database security?
Explain buffer manager?
What is Data Modelling?
What does specialization in DBMS mean?
What are different types of blocks used in stored procedure?
Explain entity type?
List the properties of a transaction.
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp