Difference between primary key and unique key ?
- 77 Answers
- 197815 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 / vitthal parkar
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 35 Yes | 58 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Difference between hot backup vs. Cold backup?
Explain oracle 12c new features for developers?
How to delete an existing row from a table in oracle?
How to view the tablespaces in the current database?
How to create an oracle testing table?
What is the relationship among database, tablespace and data file?
What is the usage of control file in oracle?
Explain the use of grant option in imp command.
What do you understand by a database object?
What are the different editions of oracle?
What is max rowid in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is the difference between a hot backup and a cold backup in oracle?
Query to retrieve record for a many to many relationship ?
