PRIMARY KEY CREATED WITH INDEXES WHICH IS NOT HAPPEN WITH UNIQUE AND NOT

what are the advantages of primary key over unique+notnull

Question Posted / nitesh

7 Answers
22510 Views
Consultancy, LGS, Oracle, I also Faced
E-Mail Answers

Answer Posted / nitesh

PRIMARY KEY CREATED WITH INDEXES WHICH IS NOT HAPPEN WITH
UNIQUE AND NOT NULL

Is This Answer Correct ?

8 Yes

21 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

1130

Explain the difference between 'between' & 'and' operators in sql

1046

What are the commands used in sql?

1136

What is sql and how does it work?

1252

What is before trigger?

1051

What are the constraints available in sql?

1088

What is sql and also describe types of sql statements?

1114

What are predefined functions in sql?

1109

What are the ways on commenting in a pl/sql code?

1206

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2139

what are the security recommendations while using mysql? : Sql dba

1181

What are different sql data types?

1129

what is meant by nl2br()? : Sql dba

1107

Can we use commit inside a trigger?

1147

Which normal form is best?

999