Difference between primary key and unique key ?
- 77 Answers
- 198480 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 to assign a tablespace to a users in oracle?
What is the exact use of Collections?
Explain parameter file in oracle.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to delete all rows a table in oracle?
What do you understand by a database object? Can you list a few of them?
How to define a specific record type?
What is Library Cache in Oracle?
Which is faster join or subquery in oracle?
Explain the characteristics of oracle dba?
What happens if variable names collide with table/column names?
candidate key is subset of super key but not vice-verse explain
How to convert raw data type into text in oracle? Explain
What are the predefined tablespaces in a database?
What is the parameter mode that can be passed to a procedure?
