what is the difference between primary key & foreign key?
Answer Posted / vaziuddin shaik
PRIMARY KEY
-------------
Primary key is a column in a table which is having unique
values......and it does not contain null values and
duplicate values...........
FOREIGN KEY
-------------
Foreign key is a column in a table which act as reference to
another table.....and it may contain null and duplicate
values.....(or)it may not contain null and duplicate
values...........
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to find out what oracle odbc drivers are installed?
What are the predefined tablespaces in a database?
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....
What is a nvl function? How can it be used?
What are a query and state the different types of queries and their uses?
How to start instance with a minimal initialization parameter file?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to shutdown your 10g xe server from command line?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
how the indexes are stored in the Oracle Database?
What is the difference between count (*), count (expression), count (distinct expression)?
How to use "for" statements in oracle?
How to empty your oracle recycle bin?
What is set verify off in oracle?
Can you assign multiple query result rows to a variable?