JobsJob TrackerJob alerts

Sopra Steria ยท 33 questions

All 33Coding 17Low-Level Design 1Behavioral 3
  • Decorators and generators; yield vs return; loop types
  • Problem using the Best Time to Buy and Sell Stock conceptCoding
  • Longest subsequence without repeating charactersCoding
  • Primary vs foreign key, DROP/DELETE/TRUNCATE, DBMS vs RDBMS, SQL vs MySQL
  • Rate your technology knowledge out of 10 and why we should hire youBehavioral
  • Normalization and Transactions
  • Linked list reversalCoding
  • Find 2nd last element of linked listCoding
  • Find Kth Largest Element with Difference AdditionsCoding
  • Value equal to index valueCoding
  • Find first and last positions of an element in a sorted arrayCoding
  • Kth smallest elementCoding
  • Rotate a Linked ListCoding
  • Vertical Traversal of Binary TreeCoding
  • Sorting, array, and searching questionsCoding
  • Function Overloading
  • Count VowelsCoding
  • Normalization
  • Cartesian Product
  • Joins
  • Unique Rows and Foreign Keys
  • Sum of first N termsCoding
  • Merge two tables using INNER JOIN and alias columns
  • OOP concepts, identification, and inheritance
  • Technical online test on DBMS and Data Structures
  • Free time, project planning, and work flexibilityBehavioral
  • Function overloading and vowel counting programCoding
  • Normalization, Cartesian product, joins, and foreign keysLow-Level Design
  • Basic Algorithms and SQL Output QuestionsCoding
  • Fibonacci series in right angle triangle patternCoding
  • Remove a node from a linked listCoding
  • Basic GeeksforGeeks puzzle
  • Discuss approach and optimization of last solved DSA problemBehavioral
โ† Sopra Steria questions
  1. Interview questions
  2. Sopra Steria
  3. Joins

Joins

Filed under Sopra Steria

The question

Explain left and right joins.

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

Related Sopra Steria questions

  • Decorators and generators; yield vs return; loop types
  • Problem using the Best Time to Buy and Sell Stock concept
  • Longest subsequence without repeating characters
  • Primary vs foreign key, DROP/DELETE/TRUNCATE, DBMS vs RDBMS, SQL vs MySQL
  • Rate your technology knowledge out of 10 and why we should hire you
โ† Cartesian ProductUnique Rows and Foreign Keys โ†’

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