Explain the difference between a primary key and a unique key?
Submitted by: Administrator► Both are defined to ensure unique row.
► Primary key creates a clustered index on the column by default.
► Unique creates a non-clustered index by default.
► Primary key doesn't allow NULLs, but unique key allows one NULL only.
Submitted by: Administrator
► Primary key creates a clustered index on the column by default.
► Unique creates a non-clustered index by default.
► Primary key doesn't allow NULLs, but unique key allows one NULL only.
Submitted by: Administrator
Read Online SQL Notification Services Job Interview Questions And Answers
Top SQL Notification Services Questions
| ☺ | Explain OPENQUERY function and OPENROWSET function? |
| ☺ | Define data, entity, domain and referential integrity? |
| ☺ | Define transaction and transaction isolation levels? |
| ☺ | How does Notification Services Work? |
| ☺ | What is Isolation Levels? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
