IVP (India) Interview Questions, Process, and Tips

MCQ round on OOPS (java) , JS, C#, SQL(dbms)

Q1. Two DSA questions , Happy Number (leetcode Q.202) , First Unique character in String (leetcode Q.387)
Add your answer
Q2. Polymorphism, Function Overloading & Overriding (code), Constructor, Access Specifier
Add your answer
Q3. Project (about nextjs, diff. b/w next & react, advantage of nextjs, SPA, some discussion about tailwind, miui (library), js)
Add your answer
Q4. DBMS query of second highest employee , find employeeid of manager whose employee name is 'something' (based on self join & only one table)
Ans. 
Use self join in a DBMS query to find the employeeid of the manager whose employee name is 'something'.
• Use a self join on the table to compare employee and manager names

• Order the results by employeeid in descending order to get the second highest employee

• Select the manager's employeeid where the employee name is 'something'
Answered by AI
Add your answer

It was easy with no negative marking

Q1. Journal entries and finance questions
Add your answer

Q1. What is dirty price
Ans. 
Dirty price is the price of a bond including accrued interest.
• Dirty price includes both the current market price of the bond and the accrued interest since the last coupon payment.

• It is also known as the full price or invoice price of a bond.

• Dirty price is used to calculate the total cost of purchasing a bond.

• For example, if a bond has a face value of $1,000 and the accrued interest is $20, the dirty price would be $1,
Answered by AI
Add your answer

Q1. What is arrow function in JS
Ans. 
Arrow functions are a concise way to write functions in JavaScript.
• Arrow functions have a shorter syntax compared to regular functions.

• They do not have their own 'this' keyword, and instead inherit 'this' from the parent scope.

• Arrow functions are best suited for non-method functions, and cannot be used as constructors.

• Example: const add = (a, b) => a + b;
Answered by AI
View 1 more answer
Q2. What is runtime polymerphism
Ans. 
Runtime polymorphism is the ability of a subclass to override a method from its superclass during runtime.
• Runtime polymorphism is achieved through method overriding in object-oriented programming.

• It allows a subclass to provide a specific implementation of a method that is already defined in its superclass.

• The actual method called is determined by the type of object at runtime.

• Example: Animal class has a method 'makeSo...read more
Answered by AI
Add your answer
Q3. What is abstraction in oops
Ans. 
Abstraction in OOP is the concept of hiding complex implementation details and showing only the necessary features to the outside world.
• Abstraction allows us to focus on what an object does rather than how it does it

• It helps in reducing complexity and improving maintainability of code

• Example: A car is an abstraction of various components like engine, wheels, etc. Users interact with the car without needing to know the
Answered by AI
Add your answer

DSA questions Reverse the linkedlist

Q1. Explain your project
Add your answer
Q2. He asked two SQL queries
Add your answer

Tricky questions from js, sql, c#

Q1. Uses of B Tree
Ans. 
B Trees are used for indexing in databases and file systems.
• Used for efficient searching, insertion, and deletion operations in databases.

• Helps in maintaining sorted data for quick retrieval.

• Commonly used in file systems to store large amounts of data efficiently.

• Each node in a B Tree can have multiple children, reducing the height of the tree.
Answered by AI
Add your answer
Q2. What is CTE in sql
Ans. 
CTE stands for Common Table Expression in SQL, used to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTEs improve readability and maintainability of complex queries

• CTEs can be recursive, allowing for hierarchical data querying

• CTEs are defined using the WITH keyword followed by the CTE name and query
Answered by AI
Add your answer

Q1. Program to reverse a linked list
Ans. 
Reverse a linked list by changing the next pointers of each node to point to the previous node.
• Start with three pointers: current, prev, and next.

• Iterate through the linked list, updating the next pointers to point to the previous node.

• Update prev, current, and next pointers in each iteration until the end of the list is reached.
Answered by AI
Add your answer
Q2. Puzzles from geeksforgeeks
Add your answer

Q1. General HR questions like difficulties, strength weakness etc.
Add your answer