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 / prativa mishra
We can create more unique key in a table but we can not create more then one primary key in a table.At the time of primary key creation thr is a clusterd index created automatically and it sorts data physically. It helps in searching process which not possible in unique+notnull column
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are system versioned tables?
what does it mean to have quoted_identifier on? : Sql dba
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is join view in sql?
What is an implicit commit?
What is sql and its types?
Mention what plvcmt and plvrb does in pl/sql?
What is difference between sql and excel?
How delete all data from table in sql?
What is pl sql block in dbms?
What is a record in a database?
How to fix oracle error ora-00942: table or view does not exist
What is the order of sql select?
how to write date and time literals? : Sql dba
Does sql view stored data?