Coffeebeans Consulting Business Analyst Interview Questions and Answers

Mcqs on javascript,. 1 coding question

There will be 3 coding questions. They are of medium and hard level.

Q1. Sort array consisting 0's 1's and 2's without inbuilt functions
Ans. 
Sort an array of 0's, 1's, and 2's without using inbuilt functions.
• Use three pointers to keep track of the last index of 0's, 1's, and 2's

• Iterate through the array and swap elements based on their value

• Continue until all elements are sorted
Answered by AI
View 1 more answer

Q1. Os cn related questions
Add your answer

Q1. Java questions and general hr questions
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Q1. Rate yourself in js, node js, react, MongoDB (separately)
Add your answer
Q2. Typeof null, typeof undefined, typeof {}, typeof NaN
Add your answer
Q3. What changes came in es6
Ans. 
ES6 introduced several new features and improvements to JavaScript, making it more powerful and efficient.
• Arrow functions for more concise syntax

• Let and const for block-scoped variables

• Classes for easier object-oriented programming

• Template literals for easier string interpolation

• Default parameters and rest parameters for function arguments

• Destructuring assignment for easier data extraction

• Promises for asynchronous prog
Answered by AI
Add your answer
Q4. This keyword, closures, hoisting
Add your answer
Q5. Are let and cont variables hoisted?
Ans. 
Yes, let and const variables are hoisted but not initialized.
• let and const variables are hoisted to the top of their block scope, but they are not initialized until the actual line of code is executed.

• This means that you cannot access a let or const variable before it is declared in the code.

• For example, trying to access a let variable before it is declared will result in a ReferenceError.
Answered by AI
Add your answer
Q6. What is global context
Ans. 
Global context refers to the overall environment or setting in which something exists or operates.
• Global context encompasses all variables, functions, and objects that are accessible throughout an entire program.

• It can be thought of as the 'big picture' view of a program's execution.

• In web development, global context includes the window object in JavaScript.
Answered by AI
Add your answer
Q7. What is temporal deadzone
Ans. 
Temporal dead zone is a period during the variable creation process where accessing the variable results in a ReferenceError.
• Occurs when trying to access a variable before it has been declared with let or const

• Happens due to the variable being in the temporal dead zone until it is declared

• Example: accessing a variable before its declaration will result in a ReferenceError
Answered by AI
Add your answer
Q8. What is modules? types of modules in nodejs
Ans. 
Modules in Node.js are reusable blocks of code that encapsulate related functionality.
• Modules in Node.js can be built-in modules like fs (file system) or third-party modules like express.

• Modules help in organizing code into separate files for better maintainability and reusability.

• Modules can be imported using the require() function in Node.js.
Answered by AI
Add your answer
Q9. Index in mongodb, why we need index, is index good or bad?
Ans. 
Indexes in MongoDB improve query performance by allowing the database to quickly locate and retrieve specific documents.
• Indexes help to speed up query performance by allowing the database to quickly locate specific documents based on the indexed fields.

• Without indexes, MongoDB would have to perform a collection scan, which can be slow and resource-intensive.

• Indexes can be created on single fields or compound fields to ...read more
Answered by AI
Add your answer
Q10. What are hooks , use of useRef
Ans. 
Hooks are a feature in React that allow you to use state and other React features in functional components. useRef is a hook that allows you to create a mutable object that persists for the lifetime of the component.
• Hooks are used to add state and lifecycle methods to functional components in React

• useRef is used to create a mutable reference that persists between renders

• useRef can be used to access DOM elements directl
Answered by AI
Add your answer
Q11. Fs module, http module, worker thread?
Add your answer
Q12. Why we use mongoose not mongodb driver?
Ans. 
Mongoose is an Object Data Modeling (ODM) library for MongoDB that provides a higher level of abstraction and simplifies interactions with the database.
• Mongoose provides schema validation which helps maintain data integrity.

• Mongoose simplifies querying and data manipulation with built-in functions.

• Mongoose supports middleware functions for pre and post processing of data operations.
Answered by AI
Add your answer

Q1. Introduction and technical questions.
Add your answer
Q2. What is the use of JAVA API?
Ans. 
The JAVA API is a collection of pre-written classes and interfaces that provide ready-to-use functionality for Java developers.
• The JAVA API allows developers to save time and effort by using pre-built code for common tasks.

• It provides a wide range of classes and interfaces for various purposes such as file handling, networking, database connectivity, GUI development, etc.

• Developers can leverage the API to access system...read more
Answered by AI
Add your answer
Q3. Questions are picked from Leetcode.
Add your answer

The duration of the test is one hour and four coding questions are asked.