http://www.webdevelopmenthelp.net/2013/04/html5-interview-questions.html
Both PRIMARY KEY and UNIQUE KEY enforces the Uniqueness of the values (i.e. avoids duplicate values) on the column[s] on which it is defined. Also these key’s can Uniquely identify each row in database table. Below table lists out the major difference between PRIMARY KEY and UNIQUE KEY : PRIMARY KEY UNIQUE KEY NULL It doesn’t allow Null values. Because of this we refer PRIMARY KEY = UNIQUE KEY + Not Null CONSTRAINT Allows Null value. But only one Null value. INDEX By default it adds a clustered index By default it adds a UNIQUE non-clustered index LIMIT A table can have only one PRIMARY KEY Column[s] A table can have more than one UNIQUE Key Column[s] CREATE SYNTAX Below is the sample example for defining a single column as a PRIMARY KEY column while creating a table: CREATE TABLE dbo.Customer ( Id IN...
Top 15 HTML5 interview Questions with Answers
ReplyDeleteTop Jquery Interview Questions with Answers
Top JavaScript Interview Questions with Answers
Top CSS3 Interview Questions with Answers
Interview Questions for AngularJS
Really this HTML5 interview Questions is help full for new candidates. Currently I am doing job change in HTML5. I learned these questions before into interview with Cognizant Solution. Thanks I got few questions from this article. Nice one. I am sharing few more interview questions here for HTML5 Developers http://jharaphula.com/top-html5-interview-questions-with-answers
ReplyDelete