Shriram Value Services interview question
SQL - Trigger, Stored Procedure, SQL Basics, truncate & delete
HR - Joins, Multirow functions
Interview Answers
Trigger is a kind of special stored procedure which will execute automatically when a when an event occures in database server.
Stored procedure is a prepared SQL code which is saved for reusing.
Truncate is similar to the delete command but it removes entire table. Delete is the command Which is used to remove some data by using where clause.
Singlerow functions are the one who work on single row and return one output per row. Multirow functions are the one who work on multiple rows and return one output for multiple rows.