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
How to estimate disk space needed for an export job?
Why is oracle so popular?
What is the scope of a local variable?
What privilege is needed for a user to create tables in oracle?
What is connection pooling in oracle?
How do I find my oracle client driver version?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Can we use bind variables in oracle stored procedure?
How to synchronize 2 schema's objects?
How many types of tables supported by oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Point out the difference between user tables and data dictionary?
What is a tns file?
What is a dead lock in oracle?