TCS Test Analyst Interview Questions, Process, and Tips

2 question on String

Q1. Define Opps concept you have implemented in your framework
Ans. 
Implemented Opps concept in framework for efficient test automation
• Used Object-Oriented Programming principles to create reusable test components

• Utilized Page Object Model design pattern to separate test logic from page elements

• Implemented Inheritance and Polymorphism for code reusability and maintainability
Answered by AI
Add your answer
Q2. Method overload and method overriding
Add your answer

Q1. Starting with our experience and contributions in project
Add your answer
Q2. Data quality checks like duplicate, length , truncation
Add your answer
Q3. Database data warehouse difference
Ans. 
Database stores data for applications, data warehouse stores data for analysis.
• Database is used for transactional processing, data warehouse is used for analytical processing.

• Database stores current data, data warehouse stores historical data.

• Database is optimized for read and write operations, data warehouse is optimized for read operations.

• Examples of databases include MySQL, Oracle, and SQL Server. Examples of data ...read more
Answered by AI
Add your answer
Q4. Views tables difference
Ans. 
Views tables difference
• Views are virtual tables that display data from one or more tables

• Views do not store data, whereas tables do

• Views can be used to restrict access to certain columns or rows

• Tables can be modified directly, whereas views cannot
Answered by AI
Add your answer
Q5. Cast function - to change datatype
Ans. 
Cast function is used to change the datatype of a value or expression in SQL.
• Syntax: CAST(expression AS datatype)

• Example: CAST('123' AS INT) will convert the string '123' to integer datatype

• Supported datatypes: INT, FLOAT, DECIMAL, CHAR, VARCHAR, DATE, TIME, etc.
Answered by AI
Add your answer
Q6. Datatype of selected columns should remain same or not for minus query?
Ans. 
Datatype consistency in minus query
• Datatype of selected columns should remain same for minus query

• Mismatch can cause errors or unexpected results
Answered by AI
Add your answer
Q7. Fact dimension difference, snowflake star schema difference
Add your answer
Q8. Which is better ? Star schema or snowflake schema
Ans. 
Both have their own advantages and disadvantages depending on the use case.
• Star schema is simpler and easier to understand, but may not be suitable for complex data relationships.

• Snowflake schema is more normalized and can handle complex data relationships, but can be more difficult to understand and maintain.

• The choice between the two depends on the specific requirements of the project and the data being analyzed.

• For ...read more
Answered by AI
Add your answer

Q1. Package negotiation and location preference
Add your answer

Q1. Salary expected
Add your answer

Q1. Basics OOPs, Java, Selenium questions, simple string programs, talked about resume, current project.
Add your answer