MSC Technology India Interview Questions, Process, and Tips

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 ex...read more

SDLC stands for Software Development Life Cycle, a process used to design, develop, and maintain software.

• It involves several phases such as planning, analysis, design, implementation, testing, and maintenance.

• Each phase has its own set of activities and deliverables.

• It helps to ensure that the software is developed efficiently, on time, and within budget.

• Examples of SDLC models include Waterfall, Agile, and DevOps.