Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between "Primary key" and "Unique key"?
- 4 Answers
- 9302 Views
- PreVator, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
1)unique key can be null but primariy key cant be null.
2)primariy key can be refrenced to other table as FK.
Primary key and unique are Entity integrity constraints
Primary key allows each row in a table to be uniquely
identified and ensures that no duplicate rows
exist and no null values are entered.
Unique key constraint is used to prevent the duplication of
key values within the rows of a table and allow null
values. (In oracle, one null is not equal to another null).
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / satya_k21
Hi,
Primary Key: Not Null+ unique.but it wont allows null
values.
Unique: It allows null values , but it should be unique.
Regards,
Satya.k
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nitin gupta
Uniques: Enforce unique data in the database
it allows row containing null value but only once
It implements non clustered index.
primary key: Enforce unique data in the database
it don't allow any record containing null value
it implements clustered index (data physically
sorted)
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kk
PRIMARY KEY=UNIQUE KEY+ NOT NULL KEY so its a combo drive
| Is This Answer Correct ? | 1 Yes | 2 No |
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
What is pragma exception and how, when, where us
How many types of index are there?
What is scalar function?
How to select random rows from a table?
What is rownum?
What is error ora-01000: maximum open cursors exceeded
What kind of join is join?
Can we create table inside stored procedure?
what is sql profiler
ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.
what is collation? : Sql dba
-
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)
