Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 207488 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
Explain what are the characteristics of data files?
How to connect to oracle using service name instead of sid?
How to delete a column in an existing table in oracle?
Explain oracle’s system global area (sga).
What are the most common interview questions on ETL Testing for experience?
What is the difference between alert log file and tarce file ?
What is an oracle table?
What is a data lock in oracle?
Explain the use of show option in imp command.
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
Explain a synonym?
What is the difference between truncate & delete command?
Explain what are clusters?
Which is faster join or subquery in oracle?
what happened to the global index when I truncate the data in one of the partition?
