Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 18 of 118
Free Preview · 118 of 392 · questions 1–118 of 392 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- left_anti returns left rows with NO matching key in right — useful for 'not-in' semantics. left_semi is the opposite: left rows WITH at least one match (projects only left columns). full_outer keeps all rows. cross is Cartesian product.