Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between UNIQUE CONSTRAINT and
PRIMARY KEY?
1. There is no difference.
2. A PRIMARY KEY cannot be declared on multiple columns.
3. A UNIQUE CONSTRAINT cannot be declared on multiple
columns.
4. A table can have multiple PRIMARY KEYS but only one
UNIQUE CONSTRAINT.
5. A table can have multiple UNIQUE CONSTRAINTs but only
one PRIMARY KEY.
- 7 Answers
- 15178 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar.ramasamy
A table can have compite primarykey but only one unique
constraint
| Is This Answer Correct ? | 0 Yes | 15 No |
Post New Answer View All Answers
How does postgresql compare to mysql?
What are the different parts of a package?
Which operator is used in query for pattern matching?
Can sql function call stored procedure?
what are the advantages of sql ? : Sql dba
How to read/write files from pl/sql?
What are sql ddl commands?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are the types of keys?
How to combine two stored procedures in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How many row comparison operators are used while working with a subquery?
Why is sql better than hql?
What is the size of partition table?
What are sql queries used for?
