Antraweb Technologies Implementation Lead Interview Questions and Answers

MySQL is a relational database management system based on SQL.

• MySQL is an open-source RDBMS while SQL is a language used to manage RDBMS.

• MySQL supports multiple storage engines while SQL does not.

• MySQL has better performance and scalability than SQL.

• MySQL has better security features than SQL.

• MySQL has a larger community and more resources available than SQL.

Clustered index determines the physical order of data in a table while non-clustered index creates a separate structure.

• Clustered index sorts and stores the data rows in the table based on their key values.

• Non-clustered index creates a separate structure that contains the key values and a pointer to the data row.

• A table can have only one clustered index while multiple non-clustered indexes can be created.

• Clustered inde...read more

Constraints in SQL are rules that limit the type of data that can be inserted, updated or deleted from a table.

• Primary Key Constraint

• Foreign Key Constraint

• Unique Constraint

• Check Constraint

• Not Null Constraint