Upload Button Icon Add office photos

Filter interviews by

Thehive.ai Interview Questions and Answers

Updated 13 Jan 2024

Thehive.ai Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 13 Jan 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jan 2023. There were 4 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Tell me about yourself.
  • Q2. Why do you want to join this organization?
  • Q3. What do you know about Hive?
  • Ans. 

    Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.

    • Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop.

    • It allows users to write complex queries without needing to know Java or MapReduce.

    • Hive organizes data into tables, partitions, and buckets for efficient querying and analysis.

    • It supports custom MapReduce scri...

  • Answered by AI
Round 2 - Technical 

(6 Questions)

  • Q1. What is a Database management system?
  • Ans. 

    A Database Management System (DBMS) is a software that allows users to create, retrieve, update, and manage data in a database.

    • DBMS helps in organizing and structuring data efficiently

    • It provides tools for data manipulation, querying, and security

    • Examples include MySQL, Oracle, SQL Server

  • Answered by AI
  • Q2. What is a primary key?
  • Ans. 

    A primary key is a unique identifier for each record in a database table.

    • A primary key must contain unique values for each record in the table.

    • It cannot contain null values.

    • It can consist of one or multiple columns.

    • Example: In a table of students, the student ID can be a primary key.

  • Answered by AI
  • Q3. What are joins in SQL?
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column between them

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q4. What is a temporary table?
  • Ans. 

    A temporary table is a table that is created and exists only for the duration of a database session.

    • Temporary tables are typically used to store intermediate results during a complex query or to isolate data for a specific task.

    • They are automatically dropped when the session ends or when the table is explicitly dropped.

    • Temporary tables are often prefixed with a '#' or '##' to differentiate them from permanent tables.

  • Answered by AI
  • Q5. What is the trigger function in SQL?
  • Ans. 

    A trigger function in SQL is a stored procedure that is automatically executed in response to certain events on a particular table.

    • Triggers can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

    • They are useful for enforcing business rules, auditing changes, and maintaining data integrity.

    • Example: CREATE TRIGGER audit_trigger AFTER INSERT ON employees FOR EACH ROW EXECUTE PROCEDURE audit_

  • Answered by AI
  • Q6. Write a SQL query for the given table's "XYZ" scenario.
  • Ans. 

    SQL query for XYZ scenario

    • Use SELECT statement to retrieve data from the table

    • Use WHERE clause to filter data based on the XYZ scenario

    • Consider using JOIN if data from multiple tables is needed

  • Answered by AI
Round 3 - Behavioral 

(3 Questions)

  • Q1. Few behavioural questions
  • Q2. Questions about the projects mentioned in the resume
  • Q3. Situation based questions based real-life examples
Round 4 - Behavioral 

(2 Questions)

  • Q1. A normal discussion about why you want to join.
  • Q2. In how many days you can join?

Interview Preparation Tips

Topics to prepare for Thehive.ai Data Analyst interview:
  • Excel
  • google sheets
Interview preparation tips for other job seekers - Be confident and learn the basic concepts of the tools required in the analytics industry and you're good to go.

Skills evaluated in this interview

Top Thehive.ai Data Analyst Interview Questions and Answers

Q1. What is a Database management system?
View answer (1)

Data Analyst Interview Questions asked at other Companies

Q1. Suppose there is a room in the office and X people enter room throughout the day, Y people leave throughout the day [continuously people are entering the room, some are staying there, and rest are going out] .. so tell me the code to calcul... read more
View answer (11)

Interview questions from similar companies

I applied via Walk-in and was interviewed in Apr 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself and technical knowledge.

Interview Preparation Tips

Interview preparation tips for other job seekers - Stay calm you will achieve it.

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

Interview Questionnaire 

2 Questions

  • Q1. About my previous work experience
  • Q2. About achievements

Interview Preparation Tips

Interview preparation tips for other job seekers - It was good. I was asked everything in detail and the managers make you comfortable enough so that answer each and evry question

I applied via Naukri.com and was interviewed before Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Online technical MCQ exam you have to clear..
  • Q2. After online technical MCQ telephonic round approx 30min.

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic knowledge will be asked at technical round.
Be confident while giving answer.


Based on prior experience they will ask questions.

Interview Questionnaire 

1 Question

  • Q1. Ques related to spring, rest web services

Interview Preparation Tips

Interview preparation tips for other job seekers - Average difficulty, smooth process

I appeared for an interview before Dec 2020.

Round 1 - Coding Test 

(2 Questions)

Round duration - 90 Minutes
Round difficulty - Medium

2 coding questions and 20 mcq
 

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges in a grid.

    • Use Breadth First Search (BFS) to simulate the rotting process.

    • Track the time taken to rot all oranges and return -1 if any fresh oranges remain.

    • Handle edge cases like no fresh oranges or all oranges already rotten.

    • Consider using a queue to efficiently process adjacent oranges.

    • Ensure to update the grid with the new state of oranges after each second.

  • Answered by AI
  • Q2. 

    Calculate Sum of Proper Divisors

    Given a natural number N, return the sum of all its proper divisors.

    A proper divisor of Y is defined as a number X such that X < Y and Y % X = 0.

    Example:

    Input:
    T...
  • Ans. 

    Calculate the sum of proper divisors of a given natural number.

    • Iterate from 1 to sqrt(N) and check for divisors

    • If a divisor is found, add it to the sum and also add N/divisor if it is not the same as divisor

    • Return the sum as the result

  • Answered by AI
Round 2 - Video Call 

(1 Question)

Round duration - 45 Minutes
Round difficulty - Medium

Technical interview

  • Q1. 

    Rearrange Array to Form Largest Number

    Given an array ARR consisting of non-negative integers, rearrange the numbers to form the largest possible number. The digits within each number cannot be changed.

    ...

  • Ans. 

    Rearrange the array elements to form the largest possible number by concatenating them.

    • Sort the array elements in a custom comparator function to get the largest number.

    • Convert the sorted array elements to strings and concatenate them to form the final number.

    • Handle cases where the numbers have the same prefix by comparing the concatenated forms.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as SDE - 1 in DelhiEligibility criteriaCriteria not revealed to candidateAmazon interview preparation:Topics to prepare for the interview - Array, Linkedlist, Tree, Graph, Stack, OOPS, Geeksforgeeks archives, coding ninjas interview experience blogsTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Be clear about whatever you have mentioned in resume, don't mention buzz words, because interviewer can go in depth
Tip 2 : Along with DS and Algo, if you have 3-4 months experience or internship experience, then be ready to answer scenario based technical questions like scaling the application that you developed and design concepts that can be used for improving
Tip 3 : Last but most important tip is to be calm through out the whole process ,don't loose hope if any round didn't go well ,if you have explained your thought process there is still chance to procees to next round so keep preparating for next rounds.

Application resume tips for other job seekers

Tip 1 : Keep it one page resume and mention keywords which align with your technical and personal competencies.
Tip 2 : Mention 3-4 projects in the order that , project which you can explain best should be at top,then the next, and so on.

Final outcome of the interviewRejected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 

Round 1 is quit easy , only verbal ability is little bit difficult. So anyone can easy to qualify round.

Round 2 - Technical 

(1 Question)

  • Q1. Round 2 is also easy. They will about your self, 2-3 basic technical questions and about project that you have done previously.
Round 3 - HR 

(1 Question)

  • Q1. Round 3 is basically non- eliminating round.They will ask basic questions just like your job preferance, ambitions etc.

Interview Preparation Tips

Topics to prepare for Capgemini Analyst interview:
  • Programing language
  • DBMS
  • OOPS
Interview preparation tips for other job seekers - Prepared with basic of programming questions. Have a clear understanding of your that you worked.

Interview Questionnaire 

1 Question

  • Q1. A-Z in MySQL, programming languages(only concepts)

I applied via Referral and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic concept question.

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics should be clear. Some scenario based questions based on business rules and FDMEE data load

I applied via Recruitment Consultant and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Java based questions
  • Q2. Tool based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it simple and straightforward

Thehive.ai Interview FAQs

How many rounds are there in Thehive.ai interview?
Thehive.ai interview process usually has 4 rounds. The most common rounds in the Thehive.ai interview process are Behavioral, HR and Technical.
What are the top questions asked in Thehive.ai interview?

Some of the top questions asked at the Thehive.ai interview -

  1. What is a Database management syst...read more
  2. What is the trigger function in S...read more
  3. Write a SQL query for the given table's "XYZ" scenar...read more

Tell us how to improve this page.

Thehive.ai Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 230 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 205 Interviews
Axtria Interview Questions
3.1
 • 116 Interviews
Gramener Interview Questions
4.2
 • 12 Interviews
AbsolutData Interview Questions
3.7
 • 9 Interviews
Crayon Data Interview Questions
3.7
 • 4 Interviews
View all

Thehive.ai Reviews and Ratings

based on 7 reviews

3.3/5

Rating in categories

2.5

Skill development

3.2

Work-life balance

3.2

Salary

2.8

Job security

2.9

Company culture

2.5

Promotions

2.5

Work satisfaction

Explore 7 Reviews and Ratings
Data Analyst
12 salaries
unlock blur

₹3.5 L/yr - ₹7 L/yr

Market Research Manager
4 salaries
unlock blur

₹15 L/yr - ₹31.5 L/yr

Senior Data Analyst
3 salaries
unlock blur

₹5 L/yr - ₹9 L/yr

Senior Quality Analyst
3 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Devops Engineer
3 salaries
unlock blur

₹44 L/yr - ₹55 L/yr

Explore more salaries
Compare Thehive.ai 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