what is difference between primary key and unique key
?
Answers were Sorted based on User's Feedback
Answer / chandonline
Basic difference between primary key and unique is that primary key is used to define a table in other tables for preventing data from anomalies,and unique key is used in a table to apply unifications among different values or columns of a tables and only in that table obviously.Their is no usage of unique key outward a table but primary key is often used to make relations between other tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ashish tyagi
The basic difference between primary key and unique key is that unique key allows null value but primary key did not allow null value.
| Is This Answer Correct ? | 2 Yes | 0 No |
Can you have a nested transaction?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
What are the disadvantages of cursors? How can you avoid cursors?
Write short notes on manual refreshes.
Write the fastest query to find out how many rows exist in a table?
Write the difference between case version and decode version.
Explain about the database management systems.
Explain the general syntax for a SELECT statements covering all the options.
Which data type cannot be used as a parameter in a udf?
can you give me the syntax of named procedure??
Explain the family trees and connection by clause.
Explain about the relational database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)