TCS Software Engineering Senior Analyst Interview Questions and Answers for Experienced

Web wrapping is the process of displaying a website within another website or application.

• It involves embedding a website within an iframe or a div element.

• Web wrapping is commonly used in mobile apps to display web content without leaving the app.

• It can also be used to display content from a different domain on a website.

• Web wrapping can be done using JavaScript or server-side scripting languages.

• Examples of web wrapp...read more

VBA effects on software development

• VBA can automate repetitive tasks in software development

• VBA can be used to create custom functions and add-ins in Excel

• VBA can interact with other Microsoft Office applications

• VBA can be used to create user interfaces for data entry and analysis

• VBA can be used to manipulate data in databases

• VBA can be used to create macros in software applications

There are two types of SQL authentication: Windows authentication and SQL Server authentication.

• Windows authentication uses the user's Windows login credentials to access the database.

• SQL Server authentication requires a separate username and password to access the database.

• SQL Server authentication is less secure than Windows authentication.

• SQL Server authentication is commonly used for web applications.

• Windows authen...read more

Defect life cycle is the process of identifying, reporting, prioritizing, fixing, and verifying defects in software.

• Defect is identified by testing or user feedback

• Defect is reported to development team

• Defect is prioritized based on severity and impact

• Defect is fixed by development team

• Defect fix is verified by testing team

• Defect is closed if verified or reopened if not fixed properly

Answering types of JOINS for two given tables.

• INNER JOIN: returns only matching rows from both tables

• LEFT JOIN: returns all rows from left table and matching rows from right table

• RIGHT JOIN: returns all rows from right table and matching rows from left table

• FULL OUTER JOIN: returns all rows from both tables and NULL values where there is no match

• CROSS JOIN: returns all possible combinations of rows from both tables

Java with DB is better than PL/SQL as it offers more flexibility and scalability.

• Java with DB allows for easier integration with other technologies

• Java offers more advanced programming features than PL/SQL

• Java with DB can handle larger and more complex data sets

• PL/SQL is limited to Oracle databases only

• Java with DB is more widely used and has a larger community for support

Dynamic SQL is a technique to generate SQL statements at runtime based on user input or other conditions.

• Dynamic SQL is used to create flexible and customizable queries.

• It allows for the creation of complex queries with multiple conditions.

• Dynamic SQL can be executed using prepared statements or by concatenating strings.

• It is important to properly sanitize user input to prevent SQL injection attacks.

Overriding in PL/SQL is the ability to define a subprogram in a child package that has the same name and signature as a subprogram in a parent package.

• Overriding allows a child package to provide its own implementation of a subprogram that is already defined in a parent package.

• The child subprogram must have the same name and signature as the parent subprogram.

• The child subprogram can have a different implementation th...read more

Triggers are database objects that are used to automatically execute a response when a certain event occurs.

• DML Triggers

• DDL Triggers

• Logon Triggers

• CLR Triggers

• INSTEAD OF Triggers

Identifying type of join for given outputs of two tables.

• Inner join: returns only the matching rows from both tables.

• Left join: returns all rows from left table and matching rows from right table.

• Right join: returns all rows from right table and matching rows from left table.

• Full outer join: returns all rows from both tables and matching rows from both tables.