i
Academian
Inc
Filter interviews by
SQL query to retrieve the second highest marks from a student table using various methods.
Use the 'DISTINCT' keyword to eliminate duplicate marks: SELECT DISTINCT marks FROM student;
Use 'ORDER BY' and 'LIMIT' to get the second highest: SELECT DISTINCT marks FROM student ORDER BY marks DESC LIMIT 1 OFFSET 1;
Alternatively, use a subquery: SELECT MAX(marks) FROM student WHERE marks < (SELECT MAX(marks) FROM studen...
Rotating an array involves shifting its elements to the left or right by a specified number of positions.
To rotate an array to the right by k positions, use: `arr = arr[-k:] + arr[:-k]`.
For left rotation, use: `arr = arr[k:] + arr[:k]`.
Example: For arr = ['a', 'b', 'c', 'd'] and k = 2, right rotation gives ['c', 'd', 'a', 'b'].
In Python, you can also use `collections.deque` for efficient rotations.
Reversing an array involves swapping elements from both ends towards the center.
Use a loop to iterate from the start to the middle of the array.
Swap the elements at the current index and its corresponding index from the end.
Example: For array ['a', 'b', 'c'], after reversing it becomes ['c', 'b', 'a'].
FRD (Functional Requirements Document) outlines system functionalities; BRD (Business Requirements Document) details business needs.
FRD specifies how the system should behave, e.g., user login features.
BRD focuses on the business objectives, e.g., increasing user engagement.
FRD is often technical, while BRD is more high-level and strategic.
Both documents are crucial for project success and stakeholder alignment.
Redux is a state management library commonly used with React.js to manage application state in a predictable way.
Redux helps to manage the state of the application in a single immutable state tree.
Actions are dispatched to update the state, and reducers specify how the state changes in response to actions.
Redux can be used with React.js to create more scalable and maintainable applications.
Example: const store = c...
useState is a hook in React that allows functional components to have state.
useState is used to declare a state variable in a functional component.
It returns an array with the current state value and a function to update that value.
Example: const [count, setCount] = useState(0);
Find elements in a string that occur more than once
Iterate through the string and count occurrences of each element
Store elements with occurrences greater than one in a separate list
To find palindrome for a given number, reverse the number and compare with the original number.
Convert the number to a string to easily reverse it
Reverse the string and compare with the original string to check for palindrome
If the reversed string is equal to the original string, then the number is a palindrome
Overriding is when a subclass provides a specific implementation of a method that is already provided by its parent class. Overloading is when multiple methods have the same name but different parameters.
Overriding occurs in inheritance when a subclass provides a specific implementation of a method that is already provided by its parent class.
Overloading is when multiple methods have the same name but different pa...
Agile metrics are used to measure the progress and performance of Agile projects.
Velocity: Measures the amount of work completed in a sprint.
Burndown charts: Tracks the remaining work in a sprint.
Lead time: Measures the time taken from a task being started to completed.
Cycle time: Measures the time taken to complete a task once it's actively being worked on.
Cumulative flow diagrams: Shows the flow of work items th...
I appeared for an interview in Jun 2025, where I was asked the following questions.
Yes, I am proficient in SQL, which is essential for managing and querying relational databases effectively.
SQL stands for Structured Query Language, used for managing relational databases.
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE.
Example: SELECT * FROM users WHERE age > 30; retrieves all users older than 30.
I can create and modify database schemas using CREATE and ALTER statements.
I am familiar ...
Developed a web-based application for managing project tasks and team collaboration, enhancing productivity and communication.
Utilized React for the front-end, providing a responsive user interface.
Implemented Node.js and Express for the back-end, ensuring efficient API handling.
Integrated MongoDB for data storage, allowing for scalable and flexible data management.
Incorporated user authentication with JWT for secure a...
I appeared for an interview in Jan 2025, where I was asked the following questions.
SQL query to retrieve the second highest marks from a student table using various methods.
Use the 'DISTINCT' keyword to eliminate duplicate marks: SELECT DISTINCT marks FROM student;
Use 'ORDER BY' and 'LIMIT' to get the second highest: SELECT DISTINCT marks FROM student ORDER BY marks DESC LIMIT 1 OFFSET 1;
Alternatively, use a subquery: SELECT MAX(marks) FROM student WHERE marks < (SELECT MAX(marks) FROM student);
Co...
I appeared for an interview in Jan 2025, where I was asked the following questions.
Reversing an array involves swapping elements from both ends towards the center.
Use a loop to iterate from the start to the middle of the array.
Swap the elements at the current index and its corresponding index from the end.
Example: For array ['a', 'b', 'c'], after reversing it becomes ['c', 'b', 'a'].
Rotating an array involves shifting its elements to the left or right by a specified number of positions.
To rotate an array to the right by k positions, use: `arr = arr[-k:] + arr[:-k]`.
For left rotation, use: `arr = arr[k:] + arr[:k]`.
Example: For arr = ['a', 'b', 'c', 'd'] and k = 2, right rotation gives ['c', 'd', 'a', 'b'].
In Python, you can also use `collections.deque` for efficient rotations.
I appeared for an interview before Jul 2024, where I was asked the following questions.
FRD (Functional Requirements Document) outlines system functionalities; BRD (Business Requirements Document) details business needs.
FRD specifies how the system should behave, e.g., user login features.
BRD focuses on the business objectives, e.g., increasing user engagement.
FRD is often technical, while BRD is more high-level and strategic.
Both documents are crucial for project success and stakeholder alignment.
A Business Analyst (BA) bridges the gap between stakeholders and IT, ensuring project requirements align with business goals.
Requirements Gathering: Conduct interviews and workshops to collect business requirements. Example: Meeting with stakeholders to define project scope.
Documentation: Create detailed documentation such as Business Requirement Documents (BRD) and Functional Requirement Documents (FRD). Example: Draf...
Agile is a project management methodology focused on iterative development, while Jira is a tool for managing Agile projects.
Agile emphasizes flexibility and customer collaboration over rigid planning.
It uses iterative cycles called sprints, typically lasting 1-4 weeks.
Jira helps teams plan, track, and manage Agile projects with features like backlogs and sprint boards.
For example, a software team might use Jira to pri...
I appeared for an interview in Oct 2024, where I was asked the following questions.
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
To build a resume builder in react js
Redux is a state management library commonly used with React.js to manage application state in a predictable way.
Redux helps to manage the state of the application in a single immutable state tree.
Actions are dispatched to update the state, and reducers specify how the state changes in response to actions.
Redux can be used with React.js to create more scalable and maintainable applications.
Example: const store = create...
Overriding is when a subclass provides a specific implementation of a method that is already provided by its parent class. Overloading is when multiple methods have the same name but different parameters.
Overriding occurs in inheritance when a subclass provides a specific implementation of a method that is already provided by its parent class.
Overloading is when multiple methods have the same name but different paramet...
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Agile metrics are used to measure the progress and performance of Agile projects.
Velocity: Measures the amount of work completed in a sprint.
Burndown charts: Tracks the remaining work in a sprint.
Lead time: Measures the time taken from a task being started to completed.
Cycle time: Measures the time taken to complete a task once it's actively being worked on.
Cumulative flow diagrams: Shows the flow of work items through...
Yes, I am open to relocating to Pune for the Associate Director position.
I am open to exploring new opportunities in different locations
I have previously relocated for career advancement
I am excited about the prospect of working in Pune
I applied via Approached by Company and was interviewed in Jun 2024. There were 2 interview rounds.
Compile time errors occur during compilation while run time errors occur during execution of the program in Java.
Compile time errors are syntax errors detected by the compiler, such as missing semicolons or typos.
Run time errors occur during program execution, such as null pointer exceptions or array index out of bounds.
Compile time errors prevent the program from being compiled successfully, while run time errors can ...
Find elements in a string that occur more than once
Iterate through the string and count occurrences of each element
Store elements with occurrences greater than one in a separate list
useState is a hook in React that allows functional components to have state.
useState is used to declare a state variable in a functional component.
It returns an array with the current state value and a function to update that value.
Example: const [count, setCount] = useState(0);
Redux is a state management library for React.js applications.
Redux helps manage the state of a React application in a predictable way
It stores the entire state of the application in a single immutable object
Actions are dispatched to update the state using reducers
Components can subscribe to the Redux store to access the state
Junit is a popular testing framework in Java used for unit testing.
Testing individual units of code
Automating test cases
Ensuring code quality and reliability
Integration testing with other frameworks like Mockito
Slicing in JavaScript allows you to extract a portion of an array or string without modifying the original.
Slicing is done using the `slice()` method.
Syntax: `array.slice(start, end)` where 'start' is inclusive and 'end' is exclusive.
Example: `let arr = [1, 2, 3, 4]; arr.slice(1, 3); // returns [2, 3]`
Negative indices can be used to slice from the end: `arr.slice(-2); // returns [3, 4]`
Slicing does not modify the origi...
I have worked on diverse projects, enhancing my skills in software development, teamwork, and problem-solving.
Developed a web application for e-commerce, improving user experience and increasing sales by 20%.
Collaborated with cross-functional teams to implement Agile methodologies, resulting in a 30% reduction in project delivery time.
Led a team of 5 in creating a mobile app for healthcare, which streamlined patient ap...
I applied via Recruitment Consulltant and was interviewed before Dec 2022. There were 4 interview rounds.
Top trending discussions
The duration of Academian Inc interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 10 interview experiences
Difficulty level
Duration
based on 49 reviews
Rating in categories
Software Engineer
22
salaries
| ₹5 L/yr - ₹8.4 L/yr |
Senior Software Engineer
11
salaries
| ₹11 L/yr - ₹16 L/yr |
Product Manager
11
salaries
| ₹15 L/yr - ₹28.6 L/yr |
Business Analyst
8
salaries
| ₹12 L/yr - ₹16.5 L/yr |
Scrum Master
7
salaries
| ₹17.5 L/yr - ₹24 L/yr |
BYJU'S
Whitehat jr
Unacademy
Extramarks Education