IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????
Answer Posted / aritra biswas
With the creation of primary key the oracle server
automatically creates and maintains a index on the primary
key column(s). Because of that index, the searching
processes on that table will be very fast where as
declaring a column as a (unique+not null) will not create
any index on that colum(s).It has to be created manually by
the DBA/users if we wish to enhance the searching process.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What is the difference between mdf and ndf files?
What is meant by temporal data?
How do I add a database to sql?
Why sql query is slow?
Which are the different types of indexes in sql?
Why are sql stored procedures used?
What is sql deadlock?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is structural independence and why is it important?
What is the use of <> sql?
Which is faster subquery or join?
What is dml statement?
explain access control lists. : Sql dba
What is the file extension for sql database?
Which is better join or inner query?