Zoho Technical Associate Interview Questions and Answers

Around 600 flights are handled by Bangalore airport on a daily basis.

• Bangalore airport is one of the busiest airports in India

• It handles both domestic and international flights

• On average, there are around 25-30 flights per hour

• The number of flights may vary depending on the day of the week and time of the year

A unique not null column can be used as a primary key, but not vice versa.

• Primary key must be unique and not null, but not all unique not null columns need to be primary keys.

• Primary key is used to identify each row uniquely, while unique not null column is used to ensure data integrity.

• A table can have multiple unique not null columns, but only one primary key.

Null cannot be equated as it represents absence of a value.

• Null is not equal to any value, including itself.

• Attempting to equate null can result in unexpected behavior.

• Null is often used to represent the absence of a value or unknown value.

Procedure overloading allows calling the correct procedure based on the number of parameters provided.

• Procedure overloading is based on the number of parameters.

• If calling with 2 arguments, the 2-parameter procedure is invoked.

• If calling with 3 arguments, the 3-parameter procedure is invoked.

• Passing a null as one of the parameters will still invoke the 3-parameter procedure if 3 arguments are provided.