JobsJob TrackerJob alerts

Opera Solutions ยท 12 questions

All 12Coding 4
  • Why use semaphores instead of a simple lock?
  • Design a compiler for a 50-line text file
  • Two trains in a tunnel and a bird
  • Data structure for 1.2 billion Aadhaar numbers and names
  • Join two tables for common rows and left outer joinCoding
  • Convert a 40/60 biased function into a 50/50 function
  • Probability of 3 heads and 1 tail in 4 coin tosses
  • Second last node in one pass, then detect a loopCoding
  • Place odds first then evens in place, sort each groupCoding
  • Product of array except self without divisionCoding
  • Inheritance in Java, interface vs abstract class
  • Tables needed for a many-to-many relationship
โ† Opera Solutions questions
  1. Interview questions
  2. Opera Solutions
  3. Join two tables for common rows and left outer join
Coding

Join two tables for common rows and left outer join

Filed under Opera Solutions

The question

Given two tables sharing a column, get the common entries and show the output; then get all rows of the first table with only matching rows of the second.

No write-up yet. Related questions below have one.

Related Opera Solutions questions

  • Second last node in one pass, then detect a loop
  • Place odds first then evens in place, sort each group
โ† Data structure for 1.2 billion Aadhaar numbers and namesConvert a 40/60 biased function into a 50/50 function โ†’

Collected from public candidate posts and coding forums. Updated Nov 2026.