Zinnia interview questions

Practice 24+ real Zinnia interview questions covering coding, technical, project, and HR rounds. Prepare smarter for Zinnia placement interviews.

Preview Questions

  1. Difference between call by value and call by reference.

    In Call by Value, a copy of the actual value is passed to the function. Changes made inside the function do not affect the original variable. In contrast, in Call by Reference, the address (reference) of the variable is...

  2. Write a query to find the Nth highest salary in a table.

    WITH RankedSalaries AS ( SELECT Salary, DENSE_RANK() OVER (ORDER BY Salary DESC) AS SalaryRank FROM Employees ) SELECT Salary FROM RankedSalaries WHERE SalaryRank = N; Explanation: - The DENSE_RANK() window function...

  3. Print the duplicate rows in a table

    To print duplicate rows in a table, we use the GROUP BY and HAVING clauses in SQL. For example, if the table name is Students and we want to find duplicate name entries: SELECT name, COUNT(*) FROM Students GROUP BY name...

  4. Difference between DELETE, TRUNCATE, and DROP

    DELETE: - It removes specified rows from a table based on a condition. - It is a DML command and logs individual row deletions. - Supports WHERE clause to delete selective data. - Can be rolled back (if in a...

  5. What are the Java 8 features ?

    Java 8 introduced several important features that greatly enhanced the language, especially enabling functional programming and streamlined data processing. Here are the main features: 1. Lambda Expressions : Enable you...

  6. Why do you want to join Zinnia?

    I want to join Zinnia because I am inspired by the company’s commitment to transforming the life insurance industry with innovative technology solutions. Zinnia’s focus on digital transformation and creating seamless,...