Kiya.ai Associate Consultant Interview Questions, Process, and Tips

Q1. Difference between procedure and function
Ans. 
A procedure is a set of instructions that performs a specific task, while a function returns a value after performing a specific task.
• Procedures do not return a value, while functions do.

• Functions can be called within expressions, while procedures cannot.

• Functions are used to calculate and return a value, while procedures are used to perform an action.

• Example: Procedure - a set of instructions to display a message on t...read more
Answered by AI
Add your answer
Q2. How many triggers can we create on a table
Ans. 
In SQL Server, you can create up to 32 triggers on a table.
• SQL Server allows up to 32 triggers per table

• Triggers can be of different types like DML triggers, DDL triggers, and logon triggers

• Each trigger can be defined for INSERT, UPDATE, or DELETE operations
Answered by AI
Add your answer

Q1. Delete trunc drop
Add your answer

Q1. About Java basic, hibernate,spring
Add your answer
Q2. What is abstraction, design pattern,spring validation
Ans. 
Abstraction is a technique to hide implementation details. Design patterns are reusable solutions to common software problems. Spring validation is a framework for validating input data.
• Abstraction allows for easier maintenance and modification of code

• Design patterns provide a standard solution to recurring problems

• Spring validation ensures that input data meets certain criteria before processing

• Examples of design patt...read more
Answered by AI
Add your answer

Moderate questions, basic level questions

Tough questions for solving

Q1. Oops concept, SQL queries
Add your answer