PHP Interview Questions

Laravel Interview Questions

MySQL Interview Questions

Which of the following statements is used to create a stored procedure in MySQL?

  • A) CREATE PROCEDURE procedure_name AS ...
  • B) CREATE FUNCTION procedure_name() RETURNS ...
  • C) CREATE TRIGGER procedure_name BEFORE ...
  • D) CREATE ROUTINE procedure_name AS ...
Show Answer 
Correct Answer: A - CREATE PROCEDURE procedure_name AS ...

What is the purpose of a stored procedure in MySQL?

  • A) To store data permanently.
  • B) To execute a set of SQL statements as a single unit.
  • C) To create a new database.
  • D) To optimize database performance.
Show Answer 
Correct Answer: B - To execute a set of SQL statements as a single unit.

Which of the following is a valid SQL statement to retrieve all records from a table named 'employees'?

  • A) SELECT * FROM employees;
  • B) GET ALL FROM employees;
  • C) RETRIEVE ALL FROM employees;
  • D) SELECT ALL FROM employees;
Show Answer 
Correct Answer: A - SELECT * FROM employees;

Which SQL statement is used to retrieve data from a database?

  • A) GET
  • B) SELECT
  • C) FETCH
  • D) RETRIEVE
Show Answer 
Correct Answer: B - SELECT

What does the term 'normalization' refer to in database design?

  • A) The process of organizing data to reduce redundancy.
  • B) The method of increasing query performance.
  • C) The technique of securing data.
  • D) The process of backing up data.
Show Answer 
Correct Answer: A - The process of organizing data to reduce redundancy.

How can you improve the performance of a MySQL query?

  • A) By using indexes and optimizing the query structure.
  • B) By increasing the size of the database.
  • C) By using more complex joins.
  • D) By reducing the number of tables in the database.
Show Answer 
Correct Answer: A - By using indexes and optimizing the query structure.

What is the purpose of the MySQL 'JOIN' clause?

  • A) To combine rows from two or more tables based on a related column.
  • B) To delete rows from a table.
  • C) To create a new table.
  • D) To update existing records in a table.
Show Answer 
Correct Answer: A - To combine rows from two or more tables based on a related column.

Which SQL statement is used to update data in a MySQL table?

  • A) UPDATE table_name SET column1 = value1 WHERE condition;
  • B) MODIFY table_name SET column1 = value1 WHERE condition;
  • C) CHANGE table_name SET column1 = value1 WHERE condition;
  • D) ALTER table_name SET column1 = value1 WHERE condition;
Show Answer 
Correct Answer: A - UPDATE table_name SET column1 = value1 WHERE condition;

What is the purpose of the 'GROUP BY' clause in SQL?

  • A) To filter records based on a condition.
  • B) To aggregate data across multiple records.
  • C) To sort records in ascending order.
  • D) To join multiple tables.
Show Answer 
Correct Answer: B - To aggregate data across multiple records.

What is the difference between 'INNER JOIN' and 'LEFT JOIN'?

  • A) INNER JOIN returns all records from both tables.
  • B) LEFT JOIN returns all records from the left table and matched records from the right table.
  • C) INNER JOIN returns all records from the left table only.
  • D) LEFT JOIN returns records only when there is a match in both tables.
Show Answer 
Correct Answer: B - LEFT JOIN returns all records from the left table and matched records from the right table.

What is the purpose of the 'JOIN' clause in MySQL?

  • A) To combine rows from two or more tables based on a related column.
  • B) To delete records from a table.
  • C) To create a new table in the database.
  • D) To update existing records in a table.
Show Answer 
Correct Answer: A - To combine rows from two or more tables based on a related column.

What is indexing in MySQL?

  • A) A method to increase the speed of data retrieval operations.
  • B) A way to store data in a more compact format.
  • C) A process of backing up the database.
  • D) A technique to encrypt sensitive data.
Show Answer 
Correct Answer: A - A method to increase the speed of data retrieval operations.

Which command is used to delete a table in MySQL?

  • A) DROP TABLE table_name;
  • B) REMOVE TABLE table_name;
  • C) DELETE TABLE table_name;
  • D) CLEAR TABLE table_name;
Show Answer 
Correct Answer: A - DROP TABLE table_name;

Which of the following is a valid way to create a new table in MySQL?

  • A) CREATE TABLE table_name;
  • B) NEW TABLE table_name;
  • C) MAKE TABLE table_name;
  • D) ADD TABLE table_name;
Show Answer 
Correct Answer: A - CREATE TABLE table_name;

What is normalization in database design?

  • A) The process of organizing data to reduce redundancy.
  • B) The process of increasing data redundancy.
  • C) The process of backing up data.
  • D) The process of encrypting data.
Show Answer 
Correct Answer: A - The process of organizing data to reduce redundancy.

Which of the following is a valid way to retrieve unique values from a column in MySQL?

  • A) SELECT DISTINCT column_name FROM table_name;
  • B) SELECT UNIQUE column_name FROM table_name;
  • C) SELECT DIFFERENT column_name FROM table_name;
  • D) SELECT column_name FROM table_name WHERE UNIQUE;
Show Answer 
Correct Answer: A - SELECT DISTINCT column_name FROM table_name;

What does CRUD stand for in the context of databases?

  • A) Create, Read, Update, Delete
  • B) Create, Remove, Update, Delete
  • C) Create, Read, Upload, Download
  • D) Create, Read, Update, Design
Show Answer 
Correct Answer: A - Create, Read, Update, Delete

What is the purpose of the 'GROUP BY' clause in MySQL?

  • A) To group rows that have the same values in specified columns.
  • B) To sort the result set in ascending order.
  • C) To filter records based on a condition.
  • D) To join multiple tables together.
Show Answer 
Correct Answer: A - To group rows that have the same values in specified columns.

What is a foreign key in MySQL?

  • A) A key used to uniquely identify a record in a table.
  • B) A key that links two tables together.
  • C) A key that is automatically generated by MySQL.
  • D) A key that is used to encrypt data.
Show Answer 
Correct Answer: B - A key that links two tables together.

What does the acronym CRUD stand for in database operations?

  • A) Create, Read, Update, Delete
  • B) Create, Retrieve, Update, Delete
  • C) Create, Read, Upload, Delete
  • D) Create, Read, Update, Deploy
Show Answer 
Correct Answer: A - Create, Read, Update, Delete