Fiserv Technology Analyst Interview Questions, Process, and Tips

Q1. Difference between Order By and Group By
Ans. 
Order By is used to sort the result set in ascending or descending order, while Group By is used to group the result set by one or more columns.
• Order By is used with SELECT statement to sort the result set based on specified column(s)

• Group By is used with SELECT statement to group the result set based on specified column(s)

• Order By can be used with or without Group By, but Group By requires an aggregate function like C...read more
Answered by AI
Add your answer
Q2. Explain Normalisation concepts in detail
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It reduces data redundancy by eliminating duplicate data

• Normalization helps maintain data integrity by ensuring data is stored in a consistent manner

• There are different levels of normalization, such as First Normal Form (1NF), Second ...read more
Answered by AI
Add your answer
Q3. Difference between Primary and Unique
Ans. 
Primary key uniquely identifies a record in a database table, while a unique key ensures that all values in a column are different.
• Primary key is used to uniquely identify each record in a table

• Primary key does not allow NULL values

• Unique key ensures that all values in a column are different

• Unique key can have NULL values, but only one NULL per column
Answered by AI
Add your answer
Q4. Types of inheritance
Ans. 
Types of inheritance include single, multiple, multilevel, hierarchical, hybrid, and so on.
• Single inheritance: a class inherits from only one base class.

• Multiple inheritance: a class inherits from more than one base class.

• Multilevel inheritance: a class inherits from a class which in turn inherits from another class.

• Hierarchical inheritance: multiple classes inherit from a single base class.

• Hybrid inheritance: a combin...read more
Answered by AI
Add your answer

2 easy to moderate questions in hackerank

Q1. DSA, SQL, OOPs and other basics
Add your answer
Q2. DSA, SQL, OOPs and other basics. Emphasis on Resume
Add your answer

Basic coding questions based on array, strings were asked.

Q1. Explain doubly linked list. And one coding question was asked about doubly linked list and I had to explain the solution.
Add your answer
Q2. HR round was covered in this round only so interviewer asked me some HR round questions.
Add your answer

Don’t remember the questions

Q1. Acid properties.
Add your answer
Q2. Write the test cases for the given scenarios.
Add your answer

3 questions of easy to medium difficulty.

Q1. Explain your resume project.
Add your answer
Q2. Do you consider yourself a team player.. if so how.
Add your answer

Q1. More project related question like why I chose a specific technology for the project.
Add your answer