RBHU Analytics Interview Questions, Process, and Tips

Q1. What is big data
Ans. 
Big data refers to large volumes of structured and unstructured data that is generated at a high velocity and variety.
• Big data is characterized by the 3 Vs - volume, velocity, and variety.

• Volume refers to the sheer amount of data being generated, often in terabytes or petabytes.

• Velocity refers to the speed at which data is being generated and processed, often in real-time.

• Variety refers to the different types of data s...read more
Answered by AI
Add your answer
Q2. What is server , sql
Ans. 
A server is a computer or software that provides functionality for other programs or devices. SQL is a programming language used for managing data in relational databases.
• A server is a computer or software that provides services or resources to other computers or devices on a network.

• SQL (Structured Query Language) is a programming language used for managing and manipulating data in relational databases.

• Servers can hos...read more
Answered by AI
Add your answer

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
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?
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