TVS Motor Interview Questions and Answers

To find errors from a service, analyze logs, monitor system metrics, and use debugging tools.

• Analyze logs generated by the service to identify any error messages or exceptions.

• Monitor system metrics such as CPU usage, memory usage, and network traffic for any anomalies that may indicate errors.

• Use debugging tools like breakpoints, stack traces, and error logs to pinpoint the source of errors.

• Perform thorough testing and quality assurance to catch and fix errors before they re...read more

Different data definition language queries in SQL

• DDL queries are used to create, modify, and delete database objects

• Some common DDL queries include CREATE, ALTER, and DROP

• CREATE TABLE is used to create a new table

• ALTER TABLE is used to modify an existing table

• DROP TABLE is used to delete a table

Approximately 18 million vadapavs are consumed in Mumbai every day.

• Consider the population of Mumbai and the popularity of vadapav as a snack.

• Estimate the number of street vendors selling vadapav in Mumbai.

• Assume an average number of vadapavs sold per vendor per day.

• Factor in the demand for vadapav during peak hours and festivals.

• Consider the price of vadapav and its affordability for the common people.

• Compare the consumption of vadapav with other popular snacks in Mumbai.

SQL is preferred for structured data, transactions, complex queries, and ACID compliance.

• SQL is better for structured data and relationships between data.

• SQL is preferred for transactions and ensuring data integrity.

• SQL is more suitable for complex queries involving multiple tables.

• SQL databases provide ACID compliance for data consistency and reliability.

Use a subquery to remove the second-highest salary in SQL

• Use a subquery to select the highest salary

• Use the NOT IN operator to exclude the second-highest salary from the results