RBHU Analytics Interview Questions and Answers

Excel Sheet was provided with aptitude questions. Questions were easy.

Q1. What is server?
Ans. 
A server is a computer or software program that provides functionality for other programs or devices, often over a network.
• A server stores and manages data, files, or applications that can be accessed by clients over a network.

• Servers can provide services such as email, web hosting, file storage, and database management.

• Examples of servers include web servers like Apache, email servers like Microsoft Exchange, and file...read more
Answered by AI
Add your answer
Q2. What is client?
Ans. 
A client is an individual or organization that receives services or advice from a consultant.
• Clients can be individuals, businesses, or other entities seeking assistance with a specific problem or project.

• Consultants work closely with clients to understand their needs and provide tailored solutions.

• Building strong relationships with clients is essential for successful consulting engagements.
Answered by AI
Add your answer
Q3. What is difference between exists and in operartor?
Ans. 
The 'exists' operator is used to check for the existence of a field in a document, while the 'in' operator is used to match a field against a list of values.
• The 'exists' operator is used in MongoDB to check if a field exists in a document.

• The 'in' operator is used in SQL to match a field against a list of values.

• Example: 'exists' operator - db.collection.find({ field: { $exists: true } })

• Example: 'in' operator - SELECT...read more
Answered by AI
Add your answer
Q4. What is index and its type?
Ans. 
An index is a data structure that improves the speed of data retrieval operations in a database.
• Indexes are used to quickly locate data without having to search every row in a database table.

• Types of indexes include clustered indexes, non-clustered indexes, unique indexes, and composite indexes.

• For example, a clustered index physically reorders the data in the table based on the index key, while a non-clustered index c...read more
Answered by AI
Add your answer
Q5. SQL queries ro find 6 th highest salary?
Ans. 
Use SQL query with ORDER BY and LIMIT to find 6th highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 1 OFFSET 5 to get the 6th highest salary
Answered by AI
Add your answer

Q1. Introduce yourself. What are your projects and achievements?
Add your answer
Q2. I don't want data analyst as of now. I will be adding you to developing team. What tech stacks are you familiar with?
Ans. 
I am familiar with various tech stacks including Python, SQL, and JavaScript for data analysis and development tasks.
• Python: Proficient in using libraries like Pandas and NumPy for data manipulation and analysis.

• SQL: Experienced in writing complex queries for data extraction and reporting in databases like MySQL and PostgreSQL.

• JavaScript: Familiar with frameworks like React for building interactive web applications.

• Dat...read more
Answered by AI
Add your answer

Basic apti questions

Q1. Background and general
Add your answer

Q1. SQL database based mostly
Add your answer
Q2. Scenario based on common table expression
Add your answer
Q3. Triggers and functions
Add your answer

Q1. Client based one to one
Add your answer

Math reasoning basic question's are there

Q1. Scenerio based questions on sql and python
Add your answer