Can you please differentiate between a primary key and a unique key?
Submitted by: Administrator- By default, clustered index on the column are created by the primary key whereas nonclustered index are created by unique key.
- Primary key doesn't allow NULLs, but unique key allows one NULL.
Submitted by: Administrator
- Primary key doesn't allow NULLs, but unique key allows one NULL.
Submitted by: Administrator
Read Online SQL Database Concepts Job Interview Questions And Answers
Top SQL Database Concepts Questions
☺ | Explain what are Magic tables in SQL Server? |
☺ | Do you know how to send email from database? |
☺ | How to search for a string in all stored procedure in SQL Server? |
☺ | Explain how to use Linked Server? |
☺ | Explain difference between cross join and Full outer join? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |