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 are the differences between lov and list item?
master table and child table performances and comparisons in Oracle ?
How to view existing locks on the database?
How to display employee records who gets more salary than the average salary in the department?
How to loop through a cursor variable?
How to store pictures on to the database?
How index is implemented in oracle database?
What is a tns service name?
Explain self joins in oracle?
What are the attributes that are found in a cursor?
What is connection pooling in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What are the oracle built-in data types?
How to update a table row with a record?
What is a table index?