In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values? MCQ with Answer and Explanation
In MS Access, which join type in a Query design screen extracts all records from Table A and only those records from Table B that have matching key values?
A. Full Cross Join
B. Right Outer Join
C. Inner Join
D. Left Outer Join
Answer: Option D
Solution (By JKSSB Mock Tests)
A Left Outer Join includes all records from the left table (Table A) and matching rows from the right table (Table B). If no match exists, NULL values appear on the right side.
Explanation:
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.
No comments yet. Be the first to start the discussion!