Difference between primary key and unique key ?

Answer Posted / saurabh

the no of primary key in a table is one but the no of
unique is more then one

Is This Answer Correct ?    25 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between data migration and production migration.

1813


How to view all columns in an existing table?

552


Why cursor variables are easier to use than cursors?

573


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?

1515


What is coalesce function?

577






How to write a query with a left outer join in oracle?

607


What is the difference between translate and replace?

560


Differentiate between translate and replace?

633


Explain what are the different type of segments?

580


What is a subquery?

617


How can windows applications connect to oracle servers?

524


What is a user role in oracle?

614


How do I manually uninstall oracle client?

519


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2457


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1490