Round Two (Technical)
- How to improve the performance of the site?
- What is having clause usage in Mysql?
- How to find the execution time of a Query using Mysql / PHP?
- What are all JOINS available in Mysql?
- Differences between Left Outer Join and Right Outer Join?
- What is Self Join?
- What does EQUI - JOIN Represents?
- How to create an Index in Mysql for a table?
- What are the advantages and disadvantages of creating an Index?
- What is a Trigger in Mysql?
- What are all the storage Engines available in Mysql?
- Differences between Mysql and Innodb?
- What are the ways to Redirect a page in PHP / Javascript?
- Difference between array_count_values() and count() functions in PHP?
- What are CSS Sprites?
- What is MEMCACHE Mechanism?