TCS Interview Questions and Answers

TestNG and Maven provide options to run failed/specific test cases and suites.

• To run failed test cases in TestNG, use the 'rerun-failed' option in the testng.xml file.

• To run specific set of test cases, use the 'include' or 'exclude' tags in the testng.xml file.

• To run specific suite in Maven, use the '-Dtest' option followed by the name of the suite.

• To run failed test cases in Maven, use the '-rf' option followed by the path to the testng-failed.xml file.

Physical join refers to the actual combination of data from two or more tables, while logical join refers to the method used to combine the data.

• Physical join involves the actual merging of tables, while logical join involves the use of operators such as AND, OR, and NOT to combine data.

• Physical join can be performed using different techniques such as nested loop join, hash join, and merge join, while logical join can be performed using different types such as inner join, out...read more

Blocking transformations halt the pipeline until all data is processed, while non-blocking transformations allow data to flow through immediately.

• Blocking transformations wait for all input data before processing

• Non-blocking transformations allow data to pass through immediately

• Blocking transformations include Aggregator, Joiner, and Sorter

• Non-blocking transformations include Expression, Filter, and Router

Indexes are used to improve database performance. There are different types of indexes.

• Clustered index

• Non-clustered index

• Unique index

• Covering index

• Bitmap index

Nested join and merge join are two types of join operations in database management systems.

• Nested join is a join operation where one join condition is nested inside another join condition.

• Merge join is a join operation where two sorted datasets are merged together based on a common attribute.

• Nested join is slower than merge join due to the nested loop required to perform the join.

• Merge join is faster than nested join as it requires less I/O operations.

• Nested join is used when...read more

Optimization can be added to the existing solution by identifying inefficiencies and implementing changes to improve performance.

• Analyze the current solution to identify areas for improvement

• Determine the key performance indicators (KPIs) to measure success

• Implement changes to improve efficiency and performance

• Continuously monitor and adjust the solution to maintain optimal performance

MIM (Medical Information Management) process involves organizing and managing medical data for analysis and decision-making.

• MIM process includes collecting, storing, and analyzing medical data

• It helps in improving patient care, optimizing healthcare operations, and supporting research

• Examples of MIM tools include electronic health records (EHR) systems and data analytics software