Filter interviews by
User defined exceptions can be defined by creating a new class that extends the Exception class.
Create a new class that extends the Exception class
Add constructors to the class to initialize the exception
Throw the exception using the 'throw' keyword
Query to delete duplicate records from a table
Use GROUP BY to group the records by the columns that define duplicates
Use HAVING to filter out groups with count greater than 1
Use DELETE to remove the duplicate records
Procedure is a set of instructions that performs a specific task, while function returns a value after performing a specific task.
Procedure does not return a value, while function returns a value
Procedure can modify the values of input parameters, while function cannot
Functions can be called from within a procedure, but procedures cannot be called from within a function
Rownum is a pseudocolumn in Oracle that assigns a unique number to each row returned by a query.
Rownum starts with 1 and increments by 1 for each row returned by the query.
The expression Rownum > 4 is correct and will return all rows with a Rownum greater than 4.
Rownum can be used to limit the number of rows returned by a query, for example, 'SELECT * FROM table WHERE Rownum <= 10'.
Defining and using a parameterized cursor in PL/SQL
Declare a cursor variable with parameters
Open the cursor using the OPEN statement and pass in the parameter values
Fetch rows from the cursor using the FETCH statement
Close the cursor using the CLOSE statement
Triggers are database objects that execute automatically in response to certain events. Mutating trigger problem occurs when a trigger tries to read or modify a table that is already being modified by the same transaction.
Triggers can be used to enforce business rules, audit changes, and maintain referential integrity.
They can be used to automatically update a table when a related table is updated.
Mutating trigger...
I applied via Naukri.com and was interviewed before Aug 2020. There were 5 interview rounds.
Defining and using a parameterized cursor in PL/SQL
Declare a cursor variable with parameters
Open the cursor using the OPEN statement and pass in the parameter values
Fetch rows from the cursor using the FETCH statement
Close the cursor using the CLOSE statement
Rownum is a pseudocolumn in Oracle that assigns a unique number to each row returned by a query.
Rownum starts with 1 and increments by 1 for each row returned by the query.
The expression Rownum > 4 is correct and will return all rows with a Rownum greater than 4.
Rownum can be used to limit the number of rows returned by a query, for example, 'SELECT * FROM table WHERE Rownum <= 10'.
Triggers are database objects that execute automatically in response to certain events. Mutating trigger problem occurs when a trigger tries to read or modify a table that is already being modified by the same transaction.
Triggers can be used to enforce business rules, audit changes, and maintain referential integrity.
They can be used to automatically update a table when a related table is updated.
Mutating trigger prob...
User defined exceptions can be defined by creating a new class that extends the Exception class.
Create a new class that extends the Exception class
Add constructors to the class to initialize the exception
Throw the exception using the 'throw' keyword
Top trending discussions
I applied via Campus Placement and was interviewed before Jun 2020. There was 1 interview round.
JCube is a Java library for creating and manipulating Rubik's Cube puzzles.
JCube provides classes for representing Rubik's Cube puzzles and algorithms for solving them.
It supports various cube sizes and can generate random scrambles.
JCube can be used in Java applications or as a standalone command-line tool.
It is open source and available on GitHub.
Software engineering principles are the best practices and guidelines for developing high-quality software.
Software should be designed with modularity and scalability in mind.
Code should be well-documented and easy to read.
Testing and debugging should be an integral part of the development process.
Version control should be used to manage code changes.
Security and privacy should be considered throughout the development ...
Testing principles ensure software quality, while design principles guide software development.
Testing principles include unit testing, integration testing, and acceptance testing.
Design principles include SOLID, DRY, and KISS.
Testing principles ensure that software meets requirements and is free of defects.
Design principles guide software development to be modular, maintainable, and scalable.
I have the necessary skills, experience, and passion to contribute to VISA's success.
I have a strong background in software development and have worked on projects similar to those at VISA.
I am a quick learner and can adapt to new technologies and programming languages easily.
I am passionate about creating high-quality software that meets the needs of users and exceeds their expectations.
I am a team player and can work...
A profile that challenges me to learn and grow while allowing me to contribute to a team.
A position that encourages continuous learning and development
A role that allows me to collaborate with a team and contribute to projects
A company culture that aligns with my values and work ethic
Design an MVC controller system to route URLs to the appropriate controllers based on the URL structure.
Define a routing mechanism that maps URLs to controller actions.
Use a hierarchical structure where each segment of the URL corresponds to a controller.
Example: For 'xyz.com/a/b/c', 'a' routes to 'AController', 'b' to 'BController', and 'c' to 'CController'.
Implement a method to parse the URL and invoke the correspond...
Autocomplete in IDEs helps developers write code faster by suggesting code snippets and completing code as they type.
Autocomplete should suggest code snippets based on the context of the code being written
Autocomplete should prioritize suggestions based on frequency of use
Autocomplete should also suggest variable and function names
Autocomplete should be customizable to allow for user-defined snippets and suggestions
Exa...
My weakness is public speaking.
I tend to get nervous when speaking in front of large groups.
I am working on improving my public speaking skills by practicing and seeking feedback.
I have taken courses and attended workshops to help me overcome my fear of public speaking.
Comparing 2 basketball game scenarios with different number of trials and baskets required to win
Calculate the probability of winning in each game scenario using binomial distribution formula
Compare the probabilities to determine which game scenario is preferable
In game1, the probability of winning is p. In game2, the probability of winning is the sum of probabilities of making 2 or 3 baskets
If p is high, game1 is pref...
I want to join Visa to contribute to innovative payment solutions and be part of a global leader in financial technology.
Visa is at the forefront of digital payment innovation, allowing me to work on cutting-edge technologies.
The company's commitment to security aligns with my passion for developing secure software solutions.
Visa's global presence offers opportunities to collaborate with diverse teams and learn from di...
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Print the given Binary search tree in ascending order
Traverse the left subtree recursively
Print the root node
Traverse the right subtree recursively
Chennai faces problems related to water scarcity, traffic congestion, and pollution.
Water scarcity due to inadequate rainfall and poor management of water resources.
Traffic congestion due to the increasing number of vehicles and poor road infrastructure.
Pollution caused by industries, vehicular emissions, and improper waste disposal.
Need more context on the question to provide an answer.
Please provide more information on the problem to be solved.
Without context, it is difficult to provide a solution.
Can you please provide more details on the problem statement?
Developed a web application using Python and Django framework for managing inventory and sales.
Used Python programming language for backend development
Implemented Django framework for building web application
Designed database schema for inventory and sales data
Integrated frontend using HTML, CSS, and JavaScript
Implemented user authentication and authorization features
I applied via Campus Placement and was interviewed in Sep 2016. There were 4 interview rounds.
My resume highlights my experience in software development and showcases my skills in various programming languages and technologies.
Worked on multiple projects using Java, Python, and C++
Developed web applications using HTML, CSS, and JavaScript
Experience with databases such as MySQL and MongoDB
Familiarity with Agile methodology and version control systems like Git
Participated in hackathons and coding competitions
Code a basic linked list
Create a Node class with data and next pointer
Create a LinkedList class with head pointer
Implement methods to add, delete, and search nodes in the linked list
A circular linked list is a data structure where the last node points back to the first node, forming a loop.
Create a Node class with data and next pointer
Initialize the head node and set its next pointer to itself
To add a node, create a new node and set its next pointer to the head node's next pointer, then update the head node's next pointer to the new node
To traverse the circular linked list, start from the head nod...
I appeared for an interview before Apr 2021.
Round duration - 45 minutes
Round difficulty - Easy
This was a technical interview round.
Round duration - 40 minutes
Round difficulty - Easy
This was the second technical interview round.
Immutability in Java refers to the property of objects whose state cannot be changed once they are created.
Immutability ensures that once an object is created, its state cannot be modified.
Immutable objects are thread-safe and can be shared without the risk of data corruption.
String class in Java is an example of an immutable class.
To create an immutable class, make the class final, all fields private, and provide only...
Round duration - 30 minutes
Round difficulty - Easy
HR round with typical behavioral problems.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Some of the top questions asked at the Fiserv Software Development Engineer 3 interview -
Technical Lead
1.5k
salaries
| ₹20.5 L/yr - ₹36 L/yr |
Specialist
537
salaries
| ₹14.3 L/yr - ₹25.9 L/yr |
Senior Associate
534
salaries
| ₹5.4 L/yr - ₹12.9 L/yr |
Senior Software Engineer
427
salaries
| ₹12.3 L/yr - ₹26.1 L/yr |
Software Developer
385
salaries
| ₹8.9 L/yr - ₹18.8 L/yr |
Global Payments
Paytm
FIS
PhonePe