Tsql Developer Interview Questions and Answers

Answering questions on Check constraint, Recursive CTE, Commit and RollBack

• Check constraint is used to limit the values that can be inserted into a column

• Recursive CTE is used to perform recursive operations on a table

• Commit is used to save changes made to the database, RollBack is used to undo changes

• Check constraint example: ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK (column_name > 0)

• Recursive CTE example: WITH recursive_cte AS (SELECT * FROM table_name WHE...read more