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

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

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

The question is asking about SQL commands: DELETE, TRUNCATE, and DROP.

• DELETE is used to remove specific rows from a table based on a condition.

• TRUNCATE is used to remove all rows from a table, but the table structure remains.

• DROP is used to remove an entire table from the database.

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