what is mean by prmary key and foreign key and how can we
diffrentiate that?
Please answer me.
Advance thanks.
Answer Posted / ysailajasantosh
Primary key means a unique key which is constant.
A foreign key (FK) is a column or combination of columns
that is used to establish and enforce a link between the
data in two tables. You can create a foreign key by
defining a FOREIGN KEY constraint when you create or modify
a table.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to connect ms access to oracle servers?
What are the roles of dba?
What is rich query?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to test null values?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What happens to the data files if a tablespace is dropped?
Will you be able to store pictures in the database?explain.
Please explain oracle left join with an example?
What is a sub query and what are the different types of subqueries?
How to do a full database export?
What is the usage of control file in oracle?
Which environment variables are absolutely critical in order to run the OUI?
Give the advantages and disadvantages of clusters.