JobsJob TrackerJob alerts

TCS ยท 1,487 questions

All 1,487Coding 601System Design 10Low-Level Design 89Behavioral 288Product Sense 11
  • Handling Deadline Discrepancies with BossBehavioral
  • Explain Pega projects done during certificationBehavioral
  • Technical questions related to Pega and featuresLow-Level Design
  • Why did you choose Pega?Behavioral
  • 5-year career visionBehavioral
  • Handling work allocated at the end of working hoursBehavioral
  • Family background detailsBehavioral
  • Number of employees in TCS
  • Describe your cityBehavioral
  • Employment agreement and salary details
  • Technical skills, data structures, and algorithms discussionCoding
  • Career goals, strengths, and weaknessesBehavioral
  • Self Introduction and InternshipsBehavioral
  • Agile methodology and incremental model
  • Current internship status and relocationBehavioral
  • Center of gravity puzzle
  • Three consecutive days puzzle
  • Why TCS and job retentionBehavioral
  • Remote location adjustment and night shiftsBehavioral
  • TRIM in SQL and Count Query
  • Left Outer Join with Example
  • Numpy coding problem
  • Separating dots in a circle
  • Root Mean Squared Error formula
  • Node.JS vs PHP and HTTP vs HTTPS
  • Introduce yourself and express interests in digital technologiesBehavioral
  • Explain core machine learning concepts and metricsLow-Level Design
  • Describe project implementation of facial expression detectionBehavioral
  • Data structure trade-offs for BST, linked lists, and large datasetsLow-Level Design
  • How to handle being assigned to a non-digital projectBehavioral
  • Python Pickling and Unpickling
  • Python Docstrings
  • Explain ML project and handle imbalanced dataLow-Level Design
  • Pass by Value and Pass by Reference Example
  • Why don't you code in Java?Behavioral
  • Regression and Classification methods
  • Zeno's Paradox: Wall distance logic
  • Project Technical Stack
  • Programming languages known
  • Explain constructors and their relation to classesLow-Level Design
  • Managing a backend project with frontend experienceBehavioral
  • Difference between JRE and JDKLow-Level Design
  • Current version of Java
  • Why is Java better than other languages?
  • Project selection and alternative methodsBehavioral
  • Why TCS instead of an NGO?Behavioral
  • Monthly expensesBehavioral
  • Handling a tedious and unliked jobBehavioral
  • Explain Quicksort
  • Handling large data inputs with CachingSystem Design
  • URL Request Lifecycle
  • MongoDB vs Relational Databases
  • Database connectivity in Python and database concepts
  • Explain Semaphores, Deadlock, and the Dining Philosophers Problem
  • SDLC phases, UML, and software development models
  • A time you were completely stuck and adapted a new approachBehavioral
  • Walking time puzzle: 1 hour 20 minutes vs 80 minutes
  • AI, ML, and Deep Learning definitions
  • What is Big Data Analytics?
  • Tech Giant OperationsProduct Sense
  • Water Jar Puzzle
  • SQL Basics
  • Movie NarrationBehavioral
  • Write an email regarding poor car service facility
  • Discuss background, interests, and career aspirationsBehavioral
  • Define normalization and explain 1st, 2nd and 3rd normalizationLow-Level Design
  • Fetch name, age, department of person drawing 5th largest salaryLow-Level Design
  • Difference between JS and Angular7?
  • What is blockchain and its advantages?
  • What is Arduino and voice/gesture-controlled bots?
  • Difference between OOPs and Procedural language?
  • Normal forms in DBMS
  • Impromptu speechBehavioral
  • REST API and HTTP methods
  • Why are manholes circular?
  • Waterfall vs Agile SDLC models
  • Cloud computing implementation in banking
  • Database connections and SQL operations
  • Weaknesses and company selection justificationBehavioral
  • Core concepts in data mining and machine learning
  • Linux file listing and text stream processing tools
  • Data structure selection for banking customer records
  • Maze solver bot algorithm discussionBehavioral
  • Day summary and handling rejectionBehavioral
  • Basic CS Concepts
  • Project deadline dilemmaBehavioral
  • Microprocessor vs Microcontroller
  • Explain Flight Reservation System projectLow-Level Design
  • Define Data Structures
  • Explain Left and Right Outer Joins
  • Changes you want to bring in your hometownBehavioral
  • DBMS properties, normalization and SQL joins query
  • JDK, JRE and Java Platform Independence
  • SQL execution approach and query writing
  • React vs JavaScript and Asynchronous Functions
  • React Component Lifecycle and State Management
  • Career Aspirations and AdaptabilityBehavioral
  • Drop Column QueryLow-Level Design
  • SQL ViewsLow-Level Design
  • SQL IndexesLow-Level Design
โ† TCS questions
  1. Interview questions
  2. TCS
  3. Left Outer Join with Example

Left Outer Join with Example

Filed under TCS

The question

Explain left outer join using an example.

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

Related TCS questions

  • Palindrome check
  • Check if a number is Prime or not
  • Star pattern printing
  • Check Armstrong Number
  • Sort array by parity conditions
โ† TRIM in SQL and Count QueryNumpy coding problem โ†’

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