Infosys SQL Developer Interview Questions and Answers

SQL is a programming language used for managing and manipulating relational databases.

• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE

Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.

• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Procedure is a set of SQL statements stored in the database and executed when called

• Procedures can accept input parameters

SSIS Architecture is a platform for data integration and workflow applications.

• SSIS stands for SQL Server Integration Services

• It includes a data flow engine, control flow engine, and event handling

• SSIS packages can be created using SQL Server Data Tools (SSDT)

• SSIS packages can be scheduled and executed using SQL Server Agent

Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.

• Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.

• Use the TransactionOption property to specify the level of transaction support needed for each task.

• Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.