Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 209855 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / jeyasree
* Only one primary key is allowed per table (any number of
unique keys are allowed).
* Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
* UNIQUE and DISTINCT are synonymous in a SELECT list.
| Is This Answer Correct ? | 82 Yes | 45 No |
Post New Answer View All Answers
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is the difference between online and offline backups?
Explain compound trigger in oracle?
Describe the types of sub query?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the use of Merge statement in oracle 11g
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What happens to the data files if a tablespace is dropped?
How to create a new user account in oracle?
How to assign a tablespace to a users in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are the differences between interval year to month and interval day to second?
what are the default admin accounts in Oracle 10g ?
What is the difference between truncate & delete command?
How to connect to oracle using service name instead of sid?
