Upload Button Icon Add office photos

Shell

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Shell Database Tester Interview Questions and Answers

Updated 24 Aug 2024

Shell Database Tester Interview Experiences

1 interview found

Database Tester Interview Questions & Answers

user image Swati Mishra

posted on 24 Aug 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Difference between union and union all
  • Ans. 

    Union combines and removes duplicates, Union All combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union All combines result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Union requires sorting while Union All does not

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. DSA, development, oops, os

Interview Preparation Tips

Interview preparation tips for other job seekers - Had a fun time giving 5 rounds back to back

I applied via Campus Placement and was interviewed in Dec 2016. There were 2 interview rounds.

Interview Preparation Tips

Round: HR Interview
Experience: HR was really friendly and discussed resume in detail.

Round: Technical Interview
Experience: Had more discussion on technical terms on resume.

Round: Technical Interview
Experience: Asked questions on Programming and questions related to course work mentioned in the resume. The interview was completely candidate driven.

College Name: IIT Madras

I applied via Campus Placement and was interviewed in Dec 2016. There were 4 interview rounds.

Interview Preparation Tips

Round: Test
Experience: There were totally 8 sections to the test. But they could be broadly put under 4 categories. Firstly all questions were compulsory to attempt and there was no negative marking. Aptitude: Basic quantitative math questions were asked. There was one simple programming question where one could code in C/Java in your local IDE and upload the code file. It was a DO or DIE question, either you get the question and proceed to the next questions of the test or the test gets stopped if the code is not successfully compiled within 5 attempts. This programming question, as was told was an important criteria to filter out candidates for the next round. There was a descriptive question asking about a recent team project done.
Tips: Achievements in sports and other extra curricular activities are valued. Mention them in the resume, if applicable.
Duration: 1 hour 30 minutes

Round: Technical Interview
Experience: In this round, they look for the candidate's experience in coding in whatever language mentioned in the resume - I was asked to write some simple codes in c. I was also asked to explain some projects from the resume.
Tips: basic knowledge of data structures, resume preparation

Round: Technical + HR Interview
Experience: In this round, the questions were mostly based on the resume and the projects done. Also, HR questions like What do you know about Schlumberger, How do you perform in a team, What makes you unique from the other candidates etc. were asked. They also ask if you have any questions from your side - Better to ask questions if you have one or if you can't think upon any specific question, ask them a doubt from whatever they have said(usually they say a lot about their company and principles before they ask you for questions)
Tips: Prepare for a HR interview separately, resume preparation

College Name: IIT Madras

I applied via Campus Placement and was interviewed in Dec 2016. There were 2 interview rounds.

Interview Preparation Tips

Round: HR Interview
Experience: HR was really friendly and asked about projects in the resume.

Round: Technical Interview
Experience: Interviewer asked questions related to programming and algorithms.

Round: Technical Interview
Experience: Interviewer asked all technical details inside the resume. This round was more technical. More emphasis was on problem solving skills.

College Name: IIT Madras
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Nov 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Asked basic C++ Qs, tree and linked list Qs

Round 3 - One-on-one 

(2 Questions)

  • Q1. Manager related Qs
  • Q2. Future plans, how to maintain team , how do you work with others in the team etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good in communication skills,
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

1 que was asked regading linked list , little bit complex

Round 2 - Technical 

(1 Question)

  • Q1. One que on LRU cache, not simple one

I applied via Company Website and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

Apptitude test is first round

Round 2 - Group Discussion 

GD is my second round

Round 3 - HR 

(5 Questions)

  • Q1. Tell me about yourself.
  • Q2. Why should we hire you
  • Q3. What is your family background
  • Q4. Why are you looking for a change
  • Q5. What are your strength and weekness

Interview Preparation Tips

Interview preparation tips for other job seekers - Learning and improving your skills perfectly then you will get good job. Thank you

I applied via Company Website and was interviewed in Jan 2022. There was 0 interview round.

Interview Preparation Tips

Topics to prepare for Reliance Industries Software Engineer interview:
  • Computer Operating
Interview preparation tips for other job seekers - Amazing nd nic interview.first Round in subpurb
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Leetcode medium kind questions is good

Shell Interview FAQs

How many rounds are there in Shell Database Tester interview?
Shell interview process usually has 1 rounds. The most common rounds in the Shell interview process are One-on-one Round.

Tell us how to improve this page.

Shell Database Tester Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Adani Group Interview Questions
3.9
 • 188 Interviews
Bharat Petroleum Interview Questions
4.1
 • 148 Interviews
Schlumberger Interview Questions
3.9
 • 139 Interviews
Nayara Energy Interview Questions
4.2
 • 79 Interviews
GAIL Interview Questions
4.4
 • 64 Interviews
ExxonMobil Interview Questions
3.8
 • 64 Interviews
View all
Business Analyst
516 salaries
unlock blur

₹12 L/yr - ₹48 L/yr

Software Engineer
507 salaries
unlock blur

₹10.3 L/yr - ₹38 L/yr

Project Manager
236 salaries
unlock blur

₹19 L/yr - ₹50 L/yr

Process Data Engineer
234 salaries
unlock blur

₹5 L/yr - ₹12 L/yr

Data Engineer
227 salaries
unlock blur

₹12 L/yr - ₹33 L/yr

Explore more salaries
Compare Shell with

Reliance Industries

4.0
Compare

Indian Oil Corporation

4.4
Compare

Bharat Petroleum

4.1
Compare

Hindustan Petroleum

4.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview