Software Developer interview questions – page 2

You have to write a function for dice which will return number from 1-6 with equal probability. constraints : you can not use random function, you can use only toss function

Write a query to fetch duplicate email from table?

Implement queue with the help of two stacks

How can you improve the performance of a site.(Only frontend)

Difference between .on('click',function() and .click(function())

Write a function to check if two strings are anagram or not

Given an array of integers which can be in one of four order – i.Increasing 2.Decreasing 3.decreasing then increasing 4.increasing then decreasing .Write a function to find the type of array

Write sql to retrieve all unread messages when user sign in

How is the Employee hierarchy in your current organization.Whom do you report to

How much is the web traffic on your site etc

Array of first n numbers.One number is missing.Find missing number?

What is memcache. Some discussion around it

Design a database schema for a chat application where user can send message to an individual or in group

Difference between include_once and require_once?

Constructor and destrutor?

sessions vs cookie. Detailed discussion

Can constructor be declared as private?

Indexing in mysql?

Overriding and Overloading?

Static class and static variable?

Singleton pattern and factory pattern?

Memcache?

Myisam and Innnodb?

Triggers in mysql?

Cookie in php? Size of the cookie, expiry etc?

Design a traffic light system?

What is the difference between get and post?

What is session in php?

What is lazy loading? Advantages and disadvantages of the same?

How ajax works? Difference between angular js and jquery?