{"id":16165,"date":"2024-04-15T04:56:58","date_gmt":"2024-04-15T04:56:58","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=16165"},"modified":"2024-04-15T04:56:58","modified_gmt":"2024-04-15T04:56:58","slug":"which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/","title":{"rendered":"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join"},"content":{"rendered":"

[amp_mcq option1=”Inner join” option2=”Left outer join” option3=”Right outer join” option4=”Self join” correct=”option1″]<\/p>\n

The answer is A. Inner join.<\/p>\n

An inner join is a join between two tables that returns all rows from both tables where there is a match on the join columns. In other words, it returns all rows from the left table that have a matching row in the right table, and all rows from the right table that have a matching row in the left table.<\/p>\n

A left outer join is a join between two tables that returns all rows from the left table, and the matching rows from the right table, if there is a match on the join columns. In other words, it returns all rows from the left table, even if there is no matching row in the right table, and all rows from the right table that have a matching row in the left table.<\/p>\n

A right outer join is a join between two tables that returns all rows from the right table, and the matching rows from the left table, if there is a match on the join columns. In other words, it returns all rows from the right table, even if there is no matching row in the left table, and all rows from the left table that have a matching row in the right table.<\/p>\n

A self join is a join between two tables that have the same name. In other words, it is a join between two tables that are related to each other.<\/p>\n

The default join between two recordsets is an inner join. This is because an inner join is the most common type of join, and it is the most efficient type of join.<\/p>\n","protected":false},"excerpt":{"rendered":"

[amp_mcq option1=”Inner join” option2=”Left outer join” option3=”Right outer join” option4=”Self join” correct=”option1″]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[672],"tags":[],"class_list":["post-16165","post","type-post","status-publish","format-standard","hentry","category-ms-access","no-featured-image-padding"],"yoast_head":"\nWhich of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join\" \/>\n<meta property=\"og:description\" content=\"[amp_mcq option1=”Inner join” option2=”Left outer join” option3=”Right outer join” option4=”Self join” correct=”option1″]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T04:56:58+00:00\" \/>\n<meta name=\"author\" content=\"rawan239\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rawan239\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join","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:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/","og_locale":"en_US","og_type":"article","og_title":"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join","og_description":"[amp_mcq option1=”Inner join” option2=”Left outer join” option3=”Right outer join” option4=”Self join” correct=”option1″]","og_url":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2024-04-15T04:56:58+00:00","author":"rawan239","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rawan239","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/","url":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/","name":"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2024-04-15T04:56:58+00:00","dateModified":"2024-04-15T04:56:58+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/which-of-the-following-is-the-default-join-between-two-recordsets-a-inner-join-b-left-outer-join-c-right-outer-join-d-self-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exam.pscnotes.com\/mcq\/"},{"@type":"ListItem","position":2,"name":"mcq","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/"},{"@type":"ListItem","position":3,"name":"Computer fundamentals","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/"},{"@type":"ListItem","position":4,"name":"Ms access","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/ms-access\/"},{"@type":"ListItem","position":5,"name":"Which of the following is the default join between two recordsets? A. Inner join B. Left outer join C. Right outer join D. Self join"}]},{"@type":"WebSite","@id":"https:\/\/exam.pscnotes.com\/mcq\/#website","url":"https:\/\/exam.pscnotes.com\/mcq\/","name":"MCQ and Quiz for Exams","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exam.pscnotes.com\/mcq\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209","name":"rawan239","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","caption":"rawan239"},"sameAs":["https:\/\/exam.pscnotes.com"],"url":"https:\/\/exam.pscnotes.com\/mcq\/author\/rawan239\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/comments?post=16165"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16165\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=16165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=16165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=16165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}