Interested to Buy Any Domain ? << Click Here >> for more details...
Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
- 8 Answers
- 18327 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / chandrika
if we define unique key column to not null
then first attempt it not allow to insert null value in
column but after inserting once we can edit its value to
null even if it is not null ( means its allow null)
if we assign primary key then its not allow (in every
situation it not allow null and duplication)
that is main difference between unique key and primery key
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How to resolve the ORA-39133 error in Oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to connect to the server with user account: sys?
What is oracle host variable?
What is Segment Advisor in Oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is an oracle function?
Explain the use of online redo log files in oracle.
What are the restrictions in a oracle read only transaction?
What is blob data type in oracle?
How do I reset a sequence in oracle?
What is the implicit cursor in oracle?
Explain oracle instance.
What is meant by recursive hints in oracle?
What are the extensions used by oracle reports?
