Is primary key = unique key,not null?
If yes,please explain
IF No,please explain

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


Please Help Members By Posting Answers For Below Questions

Is truncate autocommit in oracle?

870


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2102


How to pass a cursor variable to a procedure?

824


How to export data to a csv file?

875


What is the parameter mode that can be passed to a procedure?

816


How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1681


How to write date and time interval literals in oracle?

788


How to write an inner join with the where clause in oracle?

831


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2020


What is recycle bin in Oracle?

921


what is a Nested Loop join?

1828


How will you differentiate between varchar & varchar2?

827


How to build data dictionary view an new database?

806


How to load data through external tables?

884


How do I spool to a csv formatted file using sqlplus?

743