Fiserv Software Engineer Interview Questions, Process, and Tips

DSA questions were asked.

Topic was blockchain

Q1. Oops questions - inheritance, polymorphism
Add your answer
Q2. SQL questions - queries on joins and basic ones
Add your answer

Q1. Sql query to join 3 table with condition
Ans. 
Use SQL JOIN to combine 3 tables with a specific condition.
• Use INNER JOIN to combine the tables based on a common column

• Specify the condition in the ON clause of the JOIN statement

• You can also use LEFT JOIN or RIGHT JOIN depending on your requirement
Answered by AI
Add your answer
Q2. About ITIL, Agile
Add your answer

Data structures, 4 questions

Technology in Banking

Q1. Self intro and questions on project
Add your answer
Q2. OOps concepts, Inheritance, Polymorphism
Add your answer
Q3. Different types of Sql queries
Ans. 
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
• SELECT: Retrieves data from a database

• INSERT: Adds new records to a table

• UPDATE: Modifies existing records in a table

• DELETE: Removes records from a table

• JOIN: Combines rows from two or more tables based on a related column
Answered by AI
Add your answer

There were three easy to medium question

Q1. How to print two columns of different tables
Ans. 
To print two columns of different tables, use a SQL JOIN statement.
• Use a SQL JOIN statement to combine data from two tables based on a related column.

• Specify the columns you want to display from each table in the SELECT statement.

• Use the ON keyword to specify the columns that should be used to join the tables.

• Example: SELECT table1.column1, table2.column2 FROM table1 JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Structure of html
Ans. 
HTML is a markup language used for creating web pages.
• HTML stands for HyperText Markup Language

• HTML uses tags to define the structure of a web page

• Common HTML tags include , ,
Answered by AI
Add your answer