PHP Interview Questions

Laravel Interview Questions

MySQL Interview Questions

What is a stored procedure in MySQL?

  • A) A command to create a new table
  • B) A set of SQL statements that can be stored and reused
  • C) A method to delete records
  • D) A type of index
Show Answer 
Correct Answer: B - A set of SQL statements that can be stored and reused

What does CRUD stand for in database management?

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

What is a primary key in a database?

  • A) A unique identifier for a record in a table
  • B) A key used to encrypt data
  • C) A foreign key that references another table
  • D) A key that allows multiple null values
Show Answer 
Correct Answer: A - A unique identifier for a record in a table

What is an index in a database?

  • A) A way to store data in a database
  • B) A structure that improves the speed of data retrieval
  • C) A method to encrypt data
  • D) A type of database backup
Show Answer 
Correct Answer: B - A structure that improves the speed of data retrieval

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

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

What is an index in MySQL?

  • A) A way to store data
  • B) A data structure that improves the speed of data retrieval
  • C) A command to delete data
  • D) A type of database
Show Answer 
Correct Answer: B - A data structure that improves the speed of data retrieval

Which of the following is used to retrieve data from a MySQL database?

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

Which SQL function is used to count the number of rows in a result set?

  • A) COUNT()
  • B) SUM()
  • C) TOTAL()
  • D) NUM()
Show Answer 
Correct Answer: A - COUNT()

Which SQL statement is used to update existing records in a table?

  • A) MODIFY
  • B) CHANGE
  • C) UPDATE
  • D) ALTER
Show Answer 
Correct Answer: C - UPDATE

What is a JOIN in SQL?

  • A) A command to combine rows from two or more tables
  • B) A type of index
  • C) A method to delete records
  • D) A way to create a new table
Show Answer 
Correct Answer: A - A command to combine rows from two or more tables

What does the term 'foreign key' refer to?

  • A) A key that is used to encrypt data
  • B) A field in one table that uniquely identifies a row of another table
  • C) A command to delete records
  • D) A type of index
Show Answer 
Correct Answer: B - A field in one table that uniquely identifies a row of another table

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

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

What does the acronym CRUD stand for in database management?

  • A) Create, Read, Update, Delete
  • B) Create, Retrieve, Update, Drop
  • C) Create, Read, Undo, Delete
  • D) Create, Replace, Update, Delete
Show Answer 
Correct Answer: A - Create, Read, Update, Delete

What is the purpose of the 'WHERE' clause in SQL?

  • A) To specify the database to use
  • B) To filter records based on a condition
  • C) To sort the results of a query
  • D) To join two tables
Show Answer 
Correct Answer: B - To filter records based on a condition

What does SQL stand for?

  • A) Structured Query Language
  • B) Simple Query Language
  • C) Sequential Query Language
  • D) Standard Query Language
Show Answer 
Correct Answer: A - Structured Query Language

Which SQL statement is used to create a new table in MySQL?

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

What is MySQL?

  • A) A programming language
  • B) A relational database management system
  • C) A web server software
  • D) A content management system
Show Answer 
Correct Answer: B - A relational database management system

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

  • A) INSERT
  • B) SELECT
  • C) UPDATE
  • D) DELETE
Show Answer 
Correct Answer: B - SELECT

What is a primary key in MySQL?

  • A) A unique identifier for a record in a table
  • B) A foreign key that links to another table
  • C) A type of index used for performance
  • D) A command to delete records
Show Answer 
Correct Answer: A - A unique identifier for a record in a table

What is the purpose of indexing in MySQL?

  • A) To increase the size of the database
  • B) To improve the speed of data retrieval
  • C) To store data in a more complex format
  • D) To delete unnecessary data
Show Answer 
Correct Answer: B - To improve the speed of data retrieval

What is performance tuning in MySQL?

  • A) The process of optimizing database performance
  • B) The process of deleting unnecessary data
  • C) The process of creating new tables
  • D) The process of backing up data
Show Answer 
Correct Answer: A - The process of optimizing database performance

What does the term 'foreign key' refer to in MySQL?

  • A) A unique identifier for a table
  • B) A field that links two tables together
  • C) A method to encrypt data
  • D) A command to create a new database
Show Answer 
Correct Answer: B - A field that links two tables together