what is the difference between primary key & foreign key?

Answer Posted / sravan kumar

A attribute which it is uniquely identifies in a row in a
table is called Primary key..


A column in a table whose values matches the primary key in
some other table is called Foreign key

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to select some rows from a table in oracle?

608


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1799


What is the data type of dual table?

539


Explain oracle 12c new features for developers?

549


How to view the data files in the current database?

608






How to export your own schema?

586


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1514


How many types of cluster table in Oracle?

589


State all possible different index configurations a table can possibly have?

582


is there a tool to trace queries, like profiler for sql server?

626


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1879


how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

1600


Explain the truncate in oracle?

559


Why is oracle database so popular?

579


State and explain about oracle instance?

560