what is primary key and foreign key when and where have to use

Answer Posted / prashant

primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to drop an existing table in oracle?

589


What is a initialization parameter file in oracle?

582


How to assign a tablespace to a users in oracle?

587


What is tns entry?

621


What are the attributes that are found in a cursor?

646






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

597


Explain an integrity constrains?

695


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?

1507


Explain implicit cursor.

553


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1434


Which is faster join or subquery in oracle?

535


What privilege is needed for a user to delete rows from tables in another schema?

562


When do you get a .pll extension in oracle? Explain its importance

572


Differentiate between post-database commit and post-form commit?

541


How to create a new table in oracle?

589