Upload Button Icon Add office photos

Filter interviews by

Tbo Holidays SQL Engineer Interview Questions and Answers

Updated 15 Sep 2021

Tbo Holidays SQL Engineer Interview Experiences

1 interview found

SQL Engineer Interview Questions & Answers

user image Anonymous

posted on 15 Sep 2021

I applied via Naukri.com and was interviewed in Mar 2021. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Types of Joins, Stored Procedures, Trigger and it's type
  • Ans. 

    Types of Joins, Stored Procedures, Trigger and it's type

    • Types of Joins: Inner Join, Left Join, Right Join, Full Outer Join

    • Stored Procedures: Precompiled SQL statements, stored in database, reusable

    • Trigger: Special type of stored procedure, executed automatically on specific events

    • Types of Triggers: DML Trigger, DDL Trigger, Logon Trigger, CLR Trigger

  • Answered by AI
  • Q2. Absolute functions Rank,Dense Rank,Row_Number, Partition by
  • Q3. Difference between row_number and row_id
  • Ans. 

    row_number assigns a unique number to each row in a result set, while row_id is a unique identifier assigned to each row in a table.

    • row_number is a function used in SQL to assign a unique number to each row in a result set

    • row_id is a unique identifier assigned to each row in a table

    • row_number is used for ranking and pagination purposes

    • row_id is used for identifying a specific row in a table

    • row_number is not persistent ...

  • Answered by AI
  • Q4. Basic questions like difference between delete truncate , natural join - inner join

Interview Preparation Tips

Interview preparation tips for other job seekers - Most important thing is the confidence all we have to do is to prove the interviewer that we are a good fit for their required position. Most of us are not flawless so we need to show that we are keen to learn the relevant technology and will be an asset for their company after few months.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Oct 2019. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basic questions of Python and pytest framework
  • Q2. Questions will be based on the resume in hand

Interview Preparation Tips

Interview preparation tips for other job seekers - Be genuine with your resume. Understand the project, that you handle. Be aware of the software market and be bold to open up with your views. It is not always true, that when new technologies come up, the old goes down. It is the less adaptability of the technology, that pulls it back.

I applied via Campus Placement and was interviewed in May 2021. There were 3 interview rounds.

Round 1 - Assignment 

Mcq and 2 coding(basic)

Round 2 - Technical 

(1 Question)

  • Q1. Explain about oops concept
  • Ans. 

    OOPs is a programming paradigm based on the concept of objects, which can contain data and code.

    • OOPs stands for Object-Oriented Programming.

    • It focuses on creating objects that interact with each other to solve a problem.

    • Encapsulation, Inheritance, Polymorphism, and Abstraction are the four main pillars of OOPs.

    • Encapsulation is the process of hiding the implementation details of an object from the outside world.

    • Inherita...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. About myself, my family and goal

Interview Preparation Tips

Interview preparation tips for other job seekers - Be polite if you have basic knowledge you will select here

I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Wap of bubble sort
  • Ans. 

    Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.

    • Start from the first element and compare it with the next element

    • If the next element is smaller, swap them

    • Repeat this process for all elements in the array

    • Continue this process until no more swaps are needed

  • Answered by AI
  • Q2. Wap of prime number
  • Ans. 

    A program to print all prime numbers

    • Take input from user for range of numbers

    • Loop through the range and check if each number is prime

    • Print the prime numbers

  • Answered by AI
  • Q3. What is hashmap?
  • Ans. 

    Hashmap is a data structure that stores key-value pairs and allows constant time access to values based on their keys.

    • Hashmap uses a hash function to map keys to indices in an array.

    • Collisions can occur when multiple keys map to the same index, which can be resolved using techniques like chaining or open addressing.

    • Examples of hashmap implementations include Java's HashMap class and Python's dict type.

  • Answered by AI
  • Q4. What is inheritance
  • Ans. 

    Inheritance is a mechanism in object-oriented programming where a new class is created by inheriting properties of an existing class.

    • Inheritance allows code reuse and promotes code organization.

    • The existing class is called the parent or superclass, and the new class is called the child or subclass.

    • The child class inherits all the properties and methods of the parent class and can also add new properties and methods.

    • For...

  • Answered by AI
  • Q5. Call by value and call by reference

Interview Preparation Tips

Interview preparation tips for other job seekers - Be yourself

Skills evaluated in this interview

I applied via Superset and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Aptitude consists of general thinking, pseudo code, and game aptitude

Round 2 - Technical 

(3 Questions)

  • Q1. Resume mentioned technologies are going to ask you in the interview.
  • Q2. Any knowledge about web technologies and questions on Angular, JavaScript and java.
  • Q3. How would you manage your team. If you are on leave and you don't find any network to connect with them.
  • Ans. 

    Delegate responsibilities and establish clear communication channels for team members to handle situations in my absence.

    • Assign clear roles and responsibilities to each team member

    • Establish communication channels and protocols for emergencies

    • Ensure team members have access to necessary resources and information

    • Provide training and support to team members to handle unexpected situations

    • Regularly check in with team membe...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure you perform well. Try mock interviews before your main interview. Try to fill out the resume with the technologies that you know well.

I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - say individual ideas,plans, story's.say different opinions,speek confidentially, correctly answer Yes or no questions, correctly say interested and confidential job,

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

I applied via Naukri.com and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Technical qns, role based qns

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was smooth and qns were from technical concepts.

I applied via Campus Placement and was interviewed before Apr 2021. There were 4 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 

There were three questions hosted on hacker rank that were solved within the time limit questions were of different difficulties

Round 3 - Aptitude Test 

The guy just awesome basic questions about Python and programming and stuff nothing hard

Round 4 - HR 

(2 Questions)

  • Q1. Just ask me about myself ask me to describe my resume ask
  • Q2. Ask me about my struggle activities and project work

Interview Preparation Tips

Interview preparation tips for other job seekers - Just become know your resume very properly don't lie on your resume and be well prepared

I applied via Campus Placement and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - They asked me questions based on my resume and language i learned.

Tbo Holidays Interview FAQs

How to prepare for Tbo Holidays SQL Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Tbo Holidays. The most common topics and skills that interviewers at Tbo Holidays expect are .Net, C#, Db2, MySQL and RDBMS.
What are the top questions asked in Tbo Holidays SQL Engineer interview?

Some of the top questions asked at the Tbo Holidays SQL Engineer interview -

  1. Types of Joins, Stored Procedures, Trigger and it's t...read more
  2. Difference between row_number and row...read more
  3. Basic questions like difference between delete truncate , natural join - inner ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Amazon Interview Questions
4.0
 • 5.1k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
View all

Tbo Holidays SQL Engineer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Operations Executive
49 salaries
unlock blur

₹2.4 L/yr - ₹5 L/yr

Senior Executive Operations
25 salaries
unlock blur

₹3 L/yr - ₹6.8 L/yr

Senior Software Engineer
23 salaries
unlock blur

₹10 L/yr - ₹27 L/yr

Assistant Manager
17 salaries
unlock blur

₹4.5 L/yr - ₹10.9 L/yr

Senior Executive
15 salaries
unlock blur

₹3.5 L/yr - ₹6.3 L/yr

Explore more salaries
Compare Tbo Holidays with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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