nerdexam
Exams70-243Questions#35
Microsoft

70-243 · Question #35

70-243 Question #35: Real Exam Question with Answer & Explanation

The correct answer is A: LEFT. SQL LEFT JOIN Keyword The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2). Further information: SQL FULL JOIN Keyword The FULL JOIN keyword return rows when there is a match in one of the tables.

Question

Network contains a System Center 2012 Configuration Manager environment. You have the following query: Select R.Name, U.UserName from SMS_R_System R join SMS_R_User U on R.LastLogonUserName = U.UserName You need to ensure that all of the client computers are listed in the query results. Which join type should you use?

Options

  • ALEFT
  • BFULL
  • CINNER
  • DRIGHT

Explanation

SQL LEFT JOIN Keyword The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2). Further information: SQL FULL JOIN Keyword The FULL JOIN keyword return rows when there is a match in one of the tables. SQL INNER JOIN Keyword The INNER JOIN keyword returns rows when there is at least one match in both tables. SQL RIGHT JOIN Keyword The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-243 Practice