Difference between primary key and unique key ?
Answer Posted / jeyasree
* Only one primary key is allowed per table (any number of
unique keys are allowed).
* Primary key columns automatically become NOT NULL (unique
keys can contain nulls).
* UNIQUE and DISTINCT are synonymous in a SELECT list.
Is This Answer Correct ? | 82 Yes | 45 No |
Post New Answer View All Answers
What is a table index?
How to create a server parameter file?
How can we find out the duplicate values in an oracle table?
What is columnar storage what is the advantage?
What is the difference between alert log file and tarce file ?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to use fetch statement in a loop?
How to assign query results to variables?
How to check the oracle tns settings?
ABOUT IDENTITY?
How to view all columns in an existing table?
What is a tns service name?
What is rich query?
Can you tell me how to add new column in existing views?how?How is possible?
How to compare dates in oracle sql?