If a table column has is UNIQUE and has NOT NULL, is it
equivalent to a PRIMARY KEY column?

Answer Posted / bhakti

yes it is equivalent as primary key is nothing but unique
and not null.

Is This Answer Correct ?    16 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

984


How to use like conditions in oracle?

564


What is a trace file and how is it created in oracle?

546


What is set verify off in oracle?

568


How many memory layers are in the oracle shared pool?

634






How to calculate date and time differences in oracle?

521


How many types of cluster table in Oracle?

571


How many types of segments in Oracle?

525


Can we commit inside a function in oracle?

550


What is the difference between alert log file and tarce file ?

1628


What do you mean by merge in oracle and how can we merge two tables?

569


How to find the duplicate rows count from employees table in oracle?

539


What suggestions do you have to reduce the network traffic?

538


candidate key is subset of super key but not vice-verse explain

1571


How to export several tables together?

558