Post Details

Some php and MySQL interview Questions

04:20 PM | | 449
Some php and MySQL interview Questions

Most PHP systems which require a database rely on MySQL. These questions are focused on MySQL and databases.

  1.      How would you fix a corrupt table in a database?
  2.       What is a primary key?
  3.      What is an inner join? Left join? Right join? How are they different?
  4.       Write a simple query for me to query all of the columns in a particular table.
  5.      You have two tables which are connected via a unique ID. Write a query which will query both tables based on that unique ID.
  6.     You have a table with an unknown number of records. You want to delete half of the records. You don’t care which records are            deleted. What’s the most efficient way to do it?
  7. How would you create a new table in MySQL?
  8. What is a stored procedure? When would you use a stored procedure? Have you ever written a stored procedure?
  9. What is the difference between GROUP BY and ORDER BY?
  10. What is UNIQUE used for?
  11. What is DISTINCT used for?
  12. What is a temporary table?
  13. How would you select data into a temporary table?
  14. How do you delete records in MySQL?
  15. What is an alias? What would you use it for?
  16. How do you encrypt data in MySQL?
  17. What is a table index? Why would you use it?



Top Post

Top Backlinks Blog Commenting site for Seo

598 2016-11-23

Configuration of php.ini file

579 2016-10-30

Some Interview Questions and Answers for php developer

579 2016-10-30

Some Impotent PHP Interview Questions And Answers-part 2

535 2016-11-09

Page Optimization For seo

489 2016-12-04

Registering With Directories

468 2016-12-04

Free web 2.0 Blog websites list for backinks

457 2016-12-11

High PR Link Building

451 2016-12-04

Features of Codeigniter web Application Framework

450 2017-02-25

Some php and MySQL interview Questions

449 2016-12-05