{"id":3756,"date":"2013-07-04T06:05:08","date_gmt":"2013-07-04T06:05:08","guid":{"rendered":"http:\/\/vskills.in\/certification\/blog\/?p=3756"},"modified":"2024-04-03T13:24:05","modified_gmt":"2024-04-03T07:54:05","slug":"sql-server-common-interview-questions","status":"publish","type":"post","link":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/","title":{"rendered":"SQL Server Common Interview Questions"},"content":{"rendered":"<p><a ref=\"magnificPopup\" href=\"http:\/\/vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3765\" src=\"http:\/\/vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\" alt=\"SQL Server\" width=\"149\" height=\"122\"><\/a><\/p>\n<p><strong>What do you understand by the term primary key?<\/strong><br \/>\nPrimary Key in a table identifies each and every row uniquely.&nbsp;Primary key should not allow null values and primary key could be assigned on only column or more than one column also.<\/p>\n<p><strong>Differentiate between primary key and unique key.<\/strong><br \/>\nThe major differences between Primary key and Unique key are<\/p>\n<ul>\n<li>Primary key does not allow null values where as unique key will allow null values.<\/li>\n<li>By default Primary key is created as clustered index whereas unique key is created as non-clustered index.<\/li>\n<\/ul>\n<p><strong>Illustrate &nbsp;different levels of data integrity in SQL Server.<\/strong><\/p>\n<ul>\n<li>Entity Integrity:&nbsp;Entity Integrity ensures that there are no duplicate rows in a table.<\/li>\n<li>Domain Integrity:&nbsp;Domain Integrity enforces valid entries for a given column by restricting the type, the format, or the range of possible values.<\/li>\n<li>Referential integrity:&nbsp;Referential integrity ensures that rows cannot be deleted, which are used by other records.<\/li>\n<\/ul>\n<p><strong>What are the different constraints to maintain data integrity in SQL Server?<\/strong><\/p>\n<ul>\n<li><span style=\"color: #ff0000\">Check constraints:&nbsp;<\/span>Check constraints are useful to limit the range of possible values in a column.&nbsp;We could create check constraints at two different levels &#8211;&nbsp;Column-level check constraints are applied only to the column and cannot reference data in another other column where&nbsp;Table-level check constraints can reference any column within a table but cannot reference columns in other tables<\/li>\n<li><span style=\"color: #ff0000\">Default constraints:&nbsp;<\/span>Default constraints enable the SQL Server to write default value to a column when user doesn\u2019t specify a value.<\/li>\n<li><span style=\"color: #ff0000\">Unique constraints:&nbsp;<\/span>A unique constraint restricts a column or combination of columns from allowing duplicate values.<\/li>\n<li><span style=\"color: #ff0000\">Primary key constraints:&nbsp;<\/span>Primary key constraints will allow a row to be uniquely identified. This will perform by primary key on the table.<\/li>\n<li><span style=\"color: #ff0000\">Foreign key constraints:&nbsp;<\/span>Foreign keys constraints will ensure that the values that can be entered in a particular column exist in a specified table.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What do you understand by the term primary key? Primary Key in a table identifies each and every row uniquely.&nbsp;Primary key should not allow null values and primary key could be assigned on only column or more than one column also. Differentiate between primary key and unique key. The major differences between Primary key and&#8230;<\/p>\n","protected":false},"author":1,"featured_media":3765,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[10,920],"tags":[55,54],"class_list":["post-3756","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-career-tips","category-information-technology","tag-it","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Questions<\/title>\n<meta name=\"description\" content=\"SQL Server Common Interview Questions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Questions\" \/>\n<meta property=\"og:description\" content=\"SQL Server Common Interview Questions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"Vskills Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-04T06:05:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-03T07:54:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\" \/>\n\t<meta property=\"og:image:width\" content=\"248\" \/>\n\t<meta property=\"og:image:height\" content=\"203\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"teamvskills\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvskills\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/\",\"name\":\"SQL Questions\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\",\"datePublished\":\"2013-07-04T06:05:08+00:00\",\"dateModified\":\"2024-04-03T07:54:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/db89ed45879ddc5d130a8aae4309d90a\"},\"description\":\"SQL Server Common Interview Questions\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png\",\"width\":248,\"height\":203},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Common Interview Questions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/blog\/\",\"name\":\"Vskills Blog\",\"description\":\"Vskills - A Initiative in Assessment to Enhance Employability\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/db89ed45879ddc5d130a8aae4309d90a\",\"name\":\"teamvskills\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b622f2772f7029565ef961f615b0727ed219929be1c95fa7aeda53560feec085?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b622f2772f7029565ef961f615b0727ed219929be1c95fa7aeda53560feec085?s=96&d=mm&r=g\",\"caption\":\"teamvskills\"},\"url\":\"https:\/\/www.vskills.in\/certification\/blog\/author\/teamvskills\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Questions","description":"SQL Server Common Interview Questions","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"SQL Questions","og_description":"SQL Server Common Interview Questions","og_url":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/","og_site_name":"Vskills Blog","article_publisher":"https:\/\/www.facebook.com\/vskills.in","article_published_time":"2013-07-04T06:05:08+00:00","article_modified_time":"2024-04-03T07:54:05+00:00","og_image":[{"width":248,"height":203,"url":"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png","type":"image\/png"}],"author":"teamvskills","twitter_misc":{"Written by":"teamvskills","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/","url":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/","name":"SQL Questions","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png","datePublished":"2013-07-04T06:05:08+00:00","dateModified":"2024-04-03T07:54:05+00:00","author":{"@id":"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/db89ed45879ddc5d130a8aae4309d90a"},"description":"SQL Server Common Interview Questions","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png","contentUrl":"https:\/\/www.vskills.in\/certification\/blog\/wp-content\/uploads\/2013\/07\/SQL-Server.png","width":248,"height":203},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/blog\/sql-server-common-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server Common Interview Questions"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/blog\/#website","url":"https:\/\/www.vskills.in\/certification\/blog\/","name":"Vskills Blog","description":"Vskills - A Initiative in Assessment to Enhance Employability","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/db89ed45879ddc5d130a8aae4309d90a","name":"teamvskills","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b622f2772f7029565ef961f615b0727ed219929be1c95fa7aeda53560feec085?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b622f2772f7029565ef961f615b0727ed219929be1c95fa7aeda53560feec085?s=96&d=mm&r=g","caption":"teamvskills"},"url":"https:\/\/www.vskills.in\/certification\/blog\/author\/teamvskills\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/posts\/3756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/comments?post=3756"}],"version-history":[{"count":7,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/posts\/3756\/revisions"}],"predecessor-version":[{"id":75454,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/posts\/3756\/revisions\/75454"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/media\/3765"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/media?parent=3756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/categories?post=3756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/blog\/wp-json\/wp\/v2\/tags?post=3756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}