Q.What is index,Trigger,Stored procedure

Question

Accepted Answer

Index, trigger, and stored procedure are database objects used to improve performance and automate tasks.

An index is a data structure that improves the speed of data retrieval operations on a database table.
A trigger is a set of instructions that automatically executes in response to certain events, such as an insert, update, or delete operation on a table.
A stored procedure is a precompiled set of SQL statements that can be called by other programs or scripts to perform a specific task.
Indexes can be clustered or non-clustered, and can be created on one or more columns of a table.
Triggers can be used to enforce business rules, audit changes to data, or replicate data to other tables.
Stored procedures can be used to encapsulate complex logic, improve security, or simplify database maintenance.

Top TSYS|Total System Services Senior Software Engineer interview questions & answers