CarDekho Group Interview Questions, Process, and Tips

Unique key allows null values, primary key does not.

• Primary key is a unique identifier for a record in a table

• Unique key allows null values, primary key does not

• A table can have only one primary key, but multiple unique keys

• Primary key is automatically indexed, unique key is not necessarily indexed

HAVING clause is used in SQL to filter data based on aggregate functions.

• It is used with GROUP BY clause to filter data based on aggregate functions

• It is used to filter data after grouping has been done

• It is similar to WHERE clause but operates on grouped data

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 50000;

The number of quarter panels, cross members, and pillars in a car varies depending on the make and model.

• The number of quarter panels depends on the number of doors the car has.

• Cross members are structural components that connect the left and right sides of the car.

• Pillars are vertical supports that help to hold up the roof of the car.

• Some cars have additional structural components such as rocker panels and floor pans.

Hatchbacks are compact cars with a rear door that opens upwards. Sedans have a separate trunk compartment. SUVs are larger vehicles with high ground clearance.

• Hatchbacks are smaller and more fuel-efficient than sedans and SUVs.

• Sedans have a separate trunk compartment and are more spacious than hatchbacks.

• SUVs are larger vehicles with high ground clearance and are suitable for off-road driving.

• SUVs are more expensive th...read more

Engine back compression can cause damage to turbocharger and fuel pump.

• Increased back pressure can damage the turbocharger's turbine wheel and bearings.

• Fuel pump may struggle to deliver enough fuel to the engine due to increased resistance from back compression.

• Regular maintenance and monitoring can help prevent damage to these components.

• Upgraded components may be necessary for high-performance engines with increased

Basic rules for evaluating a vehicle

• Check the vehicle's registration and ownership documents

• Inspect the exterior and interior of the vehicle for any damages or wear and tear

• Test drive the vehicle to check for any mechanical issues

• Check the vehicle's service history and maintenance records

• Verify the vehicle's mileage and fuel efficiency

• Check the safety features of the vehicle

• Evaluate the vehicle's resale value

RTO/DTO and old car purchasing documents are related to vehicle registration and transfer of ownership.

• RTO (Regional Transport Office) and DTO (District Transport Office) are government bodies responsible for vehicle registration and issuing driving licenses.

• Old car purchasing documents include the sale deed, transfer certificate, and registration certificate.

• The transfer of ownership process involves submitting the ne...read more

Hypothecation is the process of pledging an asset as collateral for a loan without giving up possession of the asset.

• Hypothecation is commonly used in the finance industry for secured loans.

• The borrower retains possession of the asset but the lender has a right to seize it if the borrower defaults on the loan.

• Examples of hypothecation include using a car as collateral for a car loan or using stocks as collateral for a ...read more

Rules of customer handling involve active listening, empathy, problem-solving, and effective communication.

• Listen actively to the customer's concerns

• Show empathy and understanding towards their situation

• Offer solutions to their problems

• Communicate effectively and clearly

• Be patient and respectful

• Follow up to ensure satisfaction

Customers can be delighted by providing exceptional service and personalized experiences.

• Offer personalized recommendations based on their preferences

• Respond promptly and empathetically to their concerns

• Provide unexpected perks or rewards

• Create a welcoming and comfortable environment

• Go above and beyond to exceed their expectations

I will inspect the vehicle's frame, body panels, and suspension for signs of damage.

• Check for any visible signs of damage such as dents, cracks, or creases in the frame or body panels.

• Inspect the suspension for any misalignment or damage to the components.

• Use specialized tools such as a frame measuring system to check for any structural damage that may not be visible to the naked eye.

• Perform a test drive to check for a...read more