Telangana State Road Transport Corporation Mechanical Maintenance Foreman Interview Questions and Answers

SDLC stands for Software Development Life Cycle, which is a process used by software development teams to design, develop, and test high-quality software.

• SDLC consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

• Each phase has its own set of activities and deliverables to ensure the software meets the requirements and quality standards.

• Examples of SDLC models include...read more

CAN protocol is a communication standard used in automotive and industrial applications.

• CAN protocol stands for Controller Area Network

• It is a message-based protocol used for communication between electronic control units (ECUs)

• CAN protocol allows for high-speed communication and real-time data transmission

• It is commonly used in automotive applications for functions such as engine control, transmission control, and bod...read more

Dcount function counts the number of unique values in a dataset. ABS function returns the absolute value of a number. To remove minus sign from an integer in Excel, use a formula like =ABS(A1).

• Dcount function counts unique values in a dataset

• ABS function returns absolute value of a number

• To remove minus sign from an integer in Excel, use formula like =ABS(A1)

Answering questions related to data filtering, transferring, joining, and SQL functions for a Data Analyst role.

• To transfer data from one sheet to another, you can use functions like VLOOKUP or INDEX/MATCH in Excel.

• Different types of joins in SQL include INNER JOIN, OUTER JOIN, LEFT JOIN, RIGHT JOIN, and SELF JOIN.

• Syntax for INNER JOIN: SELECT columns FROM table1 INNER JOIN table2 ON table1.column = table2.column;

• Synta...read more