1) What is MySQL?
Answer: MySQL is an open-source relational database management system (RDBMS) that is widely used for managing and storing data.
2) What is the difference between SQL and MySQL?
Answer: SQL (Structured Query Language) is a language used for managing and querying databases, while MySQL is a specific RDBMS that uses SQL as its query language.
3) Explain the difference between CHAR and VARCHAR data types in MySQL.
Answer: CHAR is a fixed-length character data type, while VARCHAR is a variable-length character data type. CHAR always reserves the specified length, while VARCHAR only uses as much storage as needed.
4) What is a primary key in MySQL?
Answer: A primary key is a column or a set of columns that uniquely identify each row in a table. It enforces the uniqueness of values and ensures fast data retrieval.
5) Explain the purpose of the AUTO_INCREMENT attribute in MySQL.
Answer: The AUTO_INCREMENT attribute is used to automatically generate a unique value for a column, typically used for primary keys. It ensures that each new row gets a unique identifier.
6) What is a foreign key in MySQL, and how is it used?
Answer: A foreign key is a column or a set of columns that establishes a link between two tables. It enforces referential integrity by ensuring that values in the foreign key column(s) match values in the primary key of another table.
7) What is normalization in the context of a database?
Answer: Normalization is the process of organizing data in a database to reduce data redundancy and improve data integrity. It involves breaking down tables into smaller, related tables.
8) Explain the difference between INNER JOIN and LEFT JOIN in MySQL.
Answer:
INNER JOINreturns only the rows that have matching values in both tables, whileLEFT JOINreturns all rows from the left table and the matched rows from the right table. In aLEFT JOIN, if there are no matches, NULL values are returned for columns from the right table.9) What is the purpose of the 'GROUP BY' clause in SQL?
Answer: The
GROUP BYclause is used to group rows with the same values into summary rows. It is often used with aggregate functions like SUM, COUNT, AVG, etc.10) What is an index in MySQL?
Answer: An index is a database structure that improves the speed of data retrieval operations on a table. It allows for faster searching and sorting of data.
11) What is the difference between MyISAM and InnoDB storage engines in MySQL?
Answer: MyISAM is a simple storage engine with no support for transactions and foreign keys, while InnoDB is a more feature-rich engine that supports transactions and enforces referential integrity.
12) What is a stored procedure in MySQL?
Answer: A stored procedure is a precompiled set of one or more SQL statements that can be executed by calling the procedure's name. It is stored in the database and can be reused.
13) How can you import a SQL dump file into a MySQL database?
Answer: You can use the
mysqlcommand-line tool or a graphical interface like phpMyAdmin to import a SQL dump file into a MySQL database.14) Explain the difference between a unique key and a primary key.
Answer: A unique key enforces the uniqueness of values in a column or a set of columns but does not necessarily serve as a primary identifier. A primary key is a unique key that serves as the primary identifier for a table.
15) What is the purpose of the 'HAVING' clause in SQL?
Answer: The
HAVINGclause is used in conjunction with theGROUP BYclause to filter grouped rows based on a condition. It allows you to filter aggregated data.16) What is ACID in the context of database transactions?
Answer: ACID stands for Atomicity, Consistency, Isolation, and Durability. It is a set of properties that guarantee the reliability of database transactions.
17) How can you back up a MySQL database?
Answer: You can back up a MySQL database using the
mysqldumpcommand-line tool or through a database management tool like phpMyAdmin. This creates a SQL dump file containing the database structure and data.18) What is a view in MySQL?
Answer: A view is a virtual table that is based on the result of a SELECT query. It allows you to simplify complex queries, restrict data access, and present data in a more meaningful way.
19) Explain the purpose of the 'TRIGGER' statement in MySQL.
Answer: A trigger in MySQL is a set of actions that are automatically performed when a specified event (such as an INSERT, UPDATE, or DELETE operation) occurs on a table. Triggers are used to enforce data integrity and automate tasks.
20) What is the default port number for MySQL?
Answer: The default port number for MySQL is 3306.