i
Birlasoft
Filter interviews by
OVRDBF command is used to override the file being processed in a program with a different file.
Used to temporarily change the file being processed in a program
Helps in testing programs with different files without changing the program logic
Can be used to redirect output to a different file
Top trending discussions
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
Use proper indexing on columns used in WHERE clauses to improve query performance
Avoid using cursors and loops whenever possible, as they can be inefficient
Minimize the number of database calls by combining multiple queries into a single query or using temporary tables
Consider using bulk processing tec...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate join types and conditions
Returning clause is used to return a value from a function or procedure in PL/SQL.
Used to return a single value from a function or procedure
Can be used to return multiple values using OUT parameters
Helps in passing values back to the calling program
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
Triggers can make code harder to debug and maintain
They can lead to cascading effects if not carefully implemented
Performance can be impacted if triggers are not optimized
Triggers can introduce dependencies between different parts of the codebase
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Closure is a function that has access to its own scope, as well as the scope in which it was defined.
Closure allows a function to access variables from its outer function even after the outer function has finished executing.
It helps in maintaining state in asynchronous operations.
Example: function outerFunction() { let outerVar = 'I am outer'; return function innerFunction() { console.log(outerVar); }; }
Hooks in React are functions that let you use state and other React features without writing a class.
Hooks were introduced in React 16.8 to allow functional components to have state and lifecycle methods.
useState() is a hook that allows you to add state to functional components.
useEffect() is a hook that allows you to perform side effects in functional components.
Custom hooks are reusable functions that can contain log...
posted on 16 Oct 2024
Writing code in eggplant for Senior Developer interview
Use 'click' to simulate a mouse click on an element
Use 'typeText' to enter text into a field
Use 'verify' to check if an element is present on the screen
Good test process keep trying you will get the job
posted on 8 Oct 2024
I applied via LinkedIn and was interviewed in Apr 2024. There were 2 interview rounds.
Find the longest common substring in an array of strings.
Iterate through each string in the array and compare with all other strings to find common substrings.
Keep track of the longest common substring found so far.
Return the longest common substring at the end.
Virtual DOM in React is a lightweight copy of the actual DOM, used for efficient updates and rendering.
Virtual DOM is a concept where a lightweight copy of the actual DOM is created in memory.
When changes are made to the UI, React compares the Virtual DOM with the actual DOM to identify the differences.
React then updates only the necessary parts of the actual DOM, minimizing the number of DOM manipulations for better p...
Optimising a React application involves code splitting, lazy loading, using memoization, reducing unnecessary re-renders, and optimizing network requests.
Implement code splitting to load only necessary code for each route or component.
Use lazy loading to load components only when they are needed, reducing initial load time.
Utilize memoization techniques like useMemo and useCallback to prevent unnecessary re-renders.
Avo...
Create a function based on shared logic
Identify common logic that can be reused in multiple functions
Create a separate function to encapsulate the shared logic
Call the shared function from other functions where the logic is needed
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
CSS Box-model defines how elements are rendered in a webpage, including padding, border, and margin.
Box-model consists of content, padding, border, and margin
Content area is where text or images are displayed
Padding is the space between content and border
Border is the line around the content and padding
Margin is the space outside the border
Flexbox is for one-dimensional layouts, grid is for two-dimensional layouts.
Flexbox is best for arranging items in a single row or column.
Grid is best for creating complex layouts with rows and columns.
Flexbox is more suitable for smaller scale layouts, while grid is better for larger scale layouts.
Flexbox is more flexible in terms of item order and sizing, while grid provides more control over the overall layout.
Both
I applied via Naukri.com and was interviewed in Apr 2024. There were 3 interview rounds.
based on 1 review
Rating in categories
Software Developer
1.5k
salaries
| ₹2.5 L/yr - ₹11 L/yr |
Senior Software Engineer
1.3k
salaries
| ₹5.5 L/yr - ₹20.4 L/yr |
Software Engineer
1.1k
salaries
| ₹2.5 L/yr - ₹10.5 L/yr |
Technical Lead
1.1k
salaries
| ₹10 L/yr - ₹33.8 L/yr |
Technical Specialist
1.1k
salaries
| ₹7.9 L/yr - ₹28.5 L/yr |
Accenture
Cognizant
Capgemini
Wipro