AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Thehive.ai Interview Questions and Answers
7 Interview questions
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
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 tabl...
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 a...
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
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...
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
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.
Thehive.ai Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed before Jan 2023. There were 4 interview rounds.
(3 Questions)
- Q1. Tell me about yourself.
- Q2. Why do you want to join this organization?
- Q3. What do you know about Hive?
(6 Questions)
- Q1. What is a Database management system?
- Q2. What is a primary key?
- Q3. What are joins in SQL?
- Q4. What is a temporary table?
- Q5. What is the trigger function in SQL?
- 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
(3 Questions)
- Q1. Few behavioural questions
- Q2. Questions about the projects mentioned in the resume
- Q3. Situation based questions based real-life examples
(2 Questions)
- Q1. A normal discussion about why you want to join.
- Q2. In how many days you can join?
Interview Preparation Tips
- Excel
- google sheets
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. Do you know java
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
6 Questions
- Q1. What is fan trap? How to solve it? Give one example.
- Q2. Two tables are joined. But joined type are not mentioned, then how much records will retrieve using select statement.
- Ans.
The number of records retrieved depends on the default join type, which is usually INNER JOIN, returning matching records only.
If INNER JOIN is assumed, only records with matching keys in both tables are returned.
For example, if Table A has 5 records and Table B has 3 matching records, the result will be 3.
If LEFT JOIN is assumed, all records from the left table and matching records from the right table are returned.
Fo...
- Q3. How to use dynamic break in report?
- Ans.
Dynamic break in report allows for automatic page breaks based on data.
Define a break field in the report design
Set the break field to trigger a page break when its value changes
Use dynamic break to automatically adjust page breaks based on data
Example: A report on sales by region can use dynamic break to create a new page for each region
- Q4. Use of foreach function in report.
- Ans.
Foreach function is used to iterate through an array of strings in a report.
Foreach function is used to loop through each element in an array of strings.
It can be used to display each element in a report.
Example: foreach(string item in stringArray){ Console.WriteLine(item); }
- Q5. What is Aggregate awareness? When we use it? Syntax of it.
- Ans.
Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.
Aggregate awareness is used when creating reports in Business Objects
It allows the report to use aggregate tables instead of detailed tables for improved performance
Syntax: AGGR_AWARE(
, , )
Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table)
Answered by AIAdd your answer- Q6. @prompt function syntax and it's use.
- Ans.
The @prompt function syntax is used to display a prompt message to the user and receive input.
The syntax is @prompt('message', 'default value')
The message is the prompt message to be displayed to the user
The default value is optional and will be displayed in the input field
The function returns the value entered by the user
Answered by AIAdd your answerSkills evaluated in this interview
I applied via Referral and was interviewed in Sep 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Why you want to change job.
- Q2. Is it wrong to say that I want to change job for betterment in every aspect.
Add your answerAdd your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Afterall I also have family and expenses are raising so definitely I need more salary and I will switch if I have opportunities. I applied via Campus Placement and was interviewed before Mar 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. I was placed through campus . Did not have to give the appitude / online exam as I was among top 10 students from the college . In the interview panel ,we had 3 people .one manager and two technical / staf...
View 1 more answerInterview Preparation Tips
Interview preparation tips for other job seekers - Be confident and try to answer all. If something is out of your scope and you don't know ,politely tell them you don't know . Keep yourself engaged with the panel . In between talk to them , just do not give long pause and stares . It make things akward . Hope it helps I applied via Campus Placement and was interviewed in Oct 2020. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. C++ basic
- Q2. Hh
- Q3. Yy
Add your answerAdd your answerAdd your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Hh 
Interview Questionnaire
3 Questions
- Q1. Process builder. 2.types of relationships. 3.difference in user ,profile and role. 4.workflow. 5.Admin questions
- Ans.
Answering questions related to software development and Salesforce administration.
Process Builder is a visual tool in Salesforce used to automate business processes.
Types of relationships in Salesforce include lookup, master-detail, and many-to-many relationships.
User represents an individual who can log in and access Salesforce, Profile defines the permissions and settings for a user, and Role determines the hierarchy...
- Q2. What configuration i have done.
- Ans.
I have configured various software systems and tools for development purposes.
Configured IDEs such as Eclipse and Visual Studio for development
Set up version control systems like Git and SVN
Installed and configured build tools like Maven and Gradle
Configured application servers like Tomcat and JBoss
Set up databases like MySQL and Oracle for development and testing
- Q3. Salary negotiations
Answered by AIAdd your answerAnswered by AIAdd your answerAdd your answerInterview Preparation Tips
Round: Manager round
Experience: Configuration and what work ee have done in your previous company.Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Sep 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions were related to MS Exchange and O365.
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Be confident and Technically sound. 
I applied via Job Portal and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Basic questions regarding Informatica, Data Warehousing concepts and Unix
Add your answerInterview Preparation Tips
Interview preparation tips for other job seekers - Interview was easy. If one knows the basics of Informatica and Unix, Informatica can be cleared easily. 
I appeared for an interview before Sep 2020.
Round 1 - Coding TestRound duration - 90 minutes
Round difficulty - EasyThis round consist of two questions and we have to solve both the questions to qualify for the next round.
Round 2 - Face to FaceRound duration - 40 minutes
Round difficulty - EasyA single coding question was asked that had a lot of corner cases.
Round 3 - Face to Face(1 Question)
Round duration - 45 minutes
Round difficulty - EasyIt had 3 coding questions followed by basic concepts of DP.
- Q1. How do you find the maximum difference between a node and its descendant in the same path in a binary tree?
- Ans.
To find the maximum difference between a node and its descendant in the same path in a binary tree, we can perform a depth-first search while keeping track of the minimum value encountered so far.
Perform a depth-first search on the binary tree, keeping track of the minimum value encountered so far in the path.
At each node, calculate the difference between the current node value and the minimum value encountered so far ...
Answered by AIAdd your answerRound 4 - Face to Face(1 Question)
Round duration - 30 minutes
Round difficulty - EasyIt had 2 coding questions which were of good level.
- Q1. How can you find a Minimum Spanning Tree (MST) from a given graph using Kruskal’s algorithm?
- Ans.
Kruskal's algorithm finds MST by sorting edges, adding smallest edge that doesn't create a cycle, repeat until all vertices are connected.
Sort all edges in non-decreasing order of their weights.
Initialize an empty graph to store the MST.
Iterate through sorted edges and add the smallest edge that doesn't create a cycle in the MST.
Repeat until all vertices are connected in the MST.
Answered by AIAdd your answerRound 5 - Face to FaceRound duration - 30 minutes
Round difficulty - EasyThis was the last round.
Interview Preparation Tips
Professional and academic backgroundI completed Computer Science Engineering from Delhi Technological University. I applied for the job as SDE - 1 in HyderabadAmazon interview preparation:Topics to prepare for the interview - Data structures and Algorithms, Computer fundamentals subjects. Basics of every skill that you have written in your resume and also knowledge of concepts related to your projects. You should know whatever you have written in your resume.Time required to prepare for the interview - 4 monthsInterview preparation tips for other job seekersDon’t create panic in any case in the interview , as even if you are not selected you will learn a lot from your interview experience and perform well in the future. Also I would recommend you Coding Ninjas as according to me it is a good platform to learn basic coding concepts and to practice coding.
Application resume tips for other job seekersWrite whatever you are sure about and have actually done that. CGPA plays a good role but not a complete role as it is just eligibility criteria for some companies. Have at least 1 or 2 good projects from which you know everything involved in the project.
Final outcome of the interviewSelectedSkills evaluated in this interview
Thehive.ai Interview FAQsHow 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.Tell us how to improve this page.
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Easy 50%Moderate 50%Duration
Less than 2 weeks 100%View moreView allInterview Questions from Trending Companies on AmbitionBox
Thehive.ai Reviews and Ratings
based on 8 reviews
Rating in categories
Explore 8 Reviews and Ratings
Explore more salariesData Analyst 12 salaries
₹3.5 L/yr - ₹7 L/yr
Market Research Manager 5 salaries ₹15 L/yr - ₹36.4 L/yr
Senior Data Analyst 3 salaries ₹5 L/yr - ₹9 L/yr
Senior Quality Analyst 3 salaries ₹6 L/yr - ₹16 L/yr
- Home >
- Interviews >
- Thehive.ai Interview Questions
Share an Interview
D Behera
