Fiserv Software Development Engineer 3 Interview Questions, Process, and Tips

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

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

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'.

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

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...read more

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