Maruti Suzuki Internship Trainee Interview Questions and Answers

An index is a data structure that improves the speed of data retrieval operations on a database table.

• Indexes are created on one or more columns of a table.

• They allow for faster searching, sorting, and filtering of data.

• Examples include B-tree, hash, and bitmap indexes.

• Indexes can also have unique constraints to enforce data integrity.

• However, they can also slow down data modification operations like insert, update, an

There are different types of indexes in databases, including clustered, non-clustered, unique, and full-text indexes.

• Clustered index determines the physical order of data in a table based on the indexed column.

• Non-clustered index creates a separate structure that includes the indexed column and a pointer to the actual data.

• Unique index ensures that the indexed column has unique values.

• Full-text index enables searching ...read more

Index is used to improve the performance of database queries by allowing faster data retrieval.

• Index is a data structure that stores a small portion of the table data in an easily searchable format.

• It helps in reducing the number of disk I/O operations required to retrieve data from a table.

• Indexes can be created on one or more columns of a table.

• Examples of indexes include primary key, unique key, clustered index, and

Joins are used to combine data from two or more tables based on a related column between them.

• Inner join returns only the matching rows from both tables

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

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

• Full outer join returns all rows from both tables

• Cross join returns the Cartesian product of both t

Diesel engine works by compressing air in the cylinder and injecting fuel at the right time to ignite the mixture.

• Air is compressed in the cylinder by the piston

• Fuel is injected into the cylinder at the right time

• The heat generated by the compressed air ignites the fuel

• The expanding gases push the piston down, creating power

• Diesel engines are more efficient than gasoline engines

CC stands for carbon copy, a term used in email communication to indicate additional recipients of a message.

• CC is used to send a copy of an email to someone other than the primary recipient

• CC recipients are visible to all other recipients of the email

• CC is often used for informational purposes or to keep others in the loop

• CC can also be used to show transparency in communication

Compression ratio is the ratio of the volume of gas in a cylinder when the piston is at the bottom of its stroke to the volume of gas when the piston is at the top of its stroke.

• It is a measure of how much the engine compresses the air/fuel mixture before ignition.

• Higher compression ratios can lead to better fuel efficiency and more power.

• Compression ratio is calculated by dividing the volume of the cylinder at bottom

Swept volume is the volume of space swept by a piston in an engine cylinder during one stroke.

• It is the volume of the combustion chamber when the piston is at the bottom of its stroke subtracted from the volume of the combustion chamber when the piston is at the top of its stroke.

• It is used to calculate the engine displacement.

• For example, a four-cylinder engine with a 500cc swept volume has a total displacement of 2,0...read more

CFMEA stands for Control Failure Mode and Effects Analysis.

• CFMEA is a systematic approach used to identify and mitigate potential failures in a process or system.

• It involves analyzing failure modes, their causes, and the potential effects on the process or system.

• CFMEA helps in prioritizing and implementing control measures to prevent or minimize failures.

• It is commonly used in industries such as manufacturing, automot...read more

System level DFMEA is given main preference.

• System level DFMEA considers the entire system and its interactions.

• Component level DFMEA focuses on individual components.

• System level DFMEA is more comprehensive and effective in identifying potential failures.

• Example: In automotive industry, system level DFMEA would consider the entire vehicle and its subsystems.

• Example: In medical devices, system level DFMEA would conside...read more