Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between primary key and unique key
?
- 2 Answers
- 5030 Views
- I also Faced
- E-Mail Answers
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 |
how will I find the duplicate rows count from employees tablein oracle.
Explain the general syntax for a SELECT statements covering all the options.
How to read and create .LDC data files which are used by linguatic dictionary.
What is an application role and explain a scenario when you would use one?
Where is dbms used?
Who are end users in dbms?
How to generate OIDS
Explain about xml databases?
Explain about the storage and physical database design?
How to customize error conditions.
Explain about the hierarchical model of the database?
Explain about normal forms?
-
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)
