Shell interview questions
Online test → Technical·100% entry level
CS fundamentals
Showing 44 of 70 reported in this area
What are class loaders in Java?
Explain reference objects in Java.
Explain the garbage collector in Java.
Differentiate between SQL and NoSQL databases.
Given a C program, determine the output of the program.
Differentiate between static loading and dynamic loading.
Explain different types of joins in DBMS and how they work
Explain DDL, DML, DQL, DCL, and TCL commands with examples.
C++ questions on row-major vs column-major order and pointer concepts
When a class is initialized and no object is created, is memory consumed?
Write an SQL query using JOINs on given tables to produce the required output
Explain inheritance or polymorphism and answer follow-up questions on inheritance.
What is your strategy for data modeling and why is it better than other approaches?
Given a database table, perform normalization and explain the normalization process.
Conceptual questions on machine learning fundamentals based on resume-mentioned skills
How do you approach SQL query tuning to improve performance in large-scale data operations?
What are the steps involved in JDBC connectivity? Mention the important classes and methods.
Write a nested SQL query (up to 2 levels) to retrieve data from a complex table with multiple clauses
Advanced SQL and DBMS theory questions including normalization, relations, transactions, ER model, and complex queries
Have you worked on databases?
List a few JavaScript frameworks.
Explain the types of joins in SQL.
What is an immutable class in Java?
What are the key features of Python?
What is the use of interfaces in Java?
Which is better, Azure or AWS, and why?
What is Java Database Connectivity (JDBC)?
Are Java and Python both compiled languages?
What is the difference between MySQL and SQL?
What is the load factor of a HashMap in Java?
Explain JDK, JRE, and JVM and how they differ.
Explain database triggers and ACID properties.
Explain the static and final keywords in Java.
Are pointers supported in Java? Explain your answer.
What are the purposes and use-cases of HashMap in Java?
What is the difference between SQL and NoSQL databases?
Is Python a scripting language or a programming language?
Differentiate between method overloading and method overriding.
Share your experience using Linux in a data engineering context.
Can a non-static variable be accessed by a static method in Java?
Have you used shell scripting or Python scripting in ETL workflows?
Which approach is better while programming: recursive or iterative?
Basic DBMS theory questions (keys, normalization, transactions, joins)
What is the difference between method overloading and method overriding?
Behavioural
Showing 4 of 24 reported in this area
Given a workplace situation, how would you react and handle it?
If one of your team members is not contributing to the work, how would you handle the situation?
Describe a situation where you faced a major obstacle while completing a project. How did you deal with it and what steps did you take?
Describe your experience with Agile delivery methods such as Scrum or Kanban.
DSA
Showing 8 of 15 reported in this area
Explain a sorting algorithm and its time complexity.
Find the sum of the K largest (or smallest) elements in an array.
Explain binary search and its time complexity. Why is it O(log n)?
Given an array, find an element such that subtracting it from all elements makes exactly K elements have the same value.
Given an array, count the number of elements present before the current element that are greater than the current element. For example, Input: [2,9,5,1,10,3], Output: [0,0,1,2,0,3].
In a social network with N users labeled from 2 to N+1, each user i is friends with all users labeled with multiples of i. Find the number of groups formed such that each person in a group is a direct friend or friend-of-a-friend of every other person in the group. Example: Input: 10, Output: 3.
Basic DSA questions on commonly used data structures
Write a program to find the occurrence count of character 'A' in a given string.
Aptitude
Showing 3 of 7 reported in this area
Logical reasoning questions based on arrangements and pie charts
Quantitative aptitude questions based on percentages, ages, and profit & loss
Aptitude and logical reasoning questions from common quantitative and reasoning chapters
System design
1 questions reported in this area
How do you design an ETL methodology using Informatica?
Showing 60 of 98 questions. Ranked by how often the same question came back across reports.
Practise a Shell-style interview
A spoken interview built from these questions, scored when you finish; the report is yours.
Start practisingCommon questions
What questions does Shell ask?
Candidate interview reports most often cover CS fundamentals (60%) and Behavioural (21%).
How many rounds does Shell interview have?
Candidate interview reports show an average of 2.2 rounds per experience, with a typical sequence of Online test → Technical. Individual interview paths can vary.
Is the Shell interview hard?
Among questions with a reported difficulty, the mix is easy 59%, medium 40%, hard 1%.