Monthly Archives: August 2014

Programming Interviews Sites

1) http://www.hiredintech.com/ 2) http://www.withoutbook.com/ 3) http://www.programmerinterview.com/ 4) http://leetcode.com/ 5) http://www.careercup.com/ 6) http://glassdoor.com

Posted in General | Leave a comment

MySQL 10 Interview Questions : Set-1

1) What is the difference between primary key and unique key ? both primary and unique key uniquely identifies each row in table but there are some subtle difference between them. here are some of them : 1) Unique key … Continue reading

Posted in Database | Leave a comment

mysqli (MySQL Improved)

The mysqli extension, or as it is sometimes known, the MySQL improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer The mysqli extension has a number of benefits, the key enhancements … Continue reading

Posted in PHP | Leave a comment

PHP Data Objects & Prepared Statements

PDO provides a data-access abstraction layer, which means that, regardless of which database you’re using, you use the same functions to issue queries and fetch data. try { $dbh = new PDO(‘mysql:host=localhost;dbname=test’, $user, $pass); foreach($dbh->query(‘SELECT * from FOO’) as $row) … Continue reading

Posted in PHP | Leave a comment

Linked List Algorithms

1) reverse a linked list karumanchi, pg 64 2)

Posted in General | Leave a comment

System Design Question Resources

http://www.lecloud.net/post/7295452622/scalability-for-dummies-part-1-clones http://www.quora.com/Job-Interviews/How-should-I-prepare-system-design-questions-for-Google-Facebook-Interview

Posted in General | Leave a comment

System Design

1) “Design and code a system that can accept millions of events in real time and report the number of events for the last 10 minutes (sliding window). The system has to account for performance and concurrency.” http://www.glassdoor.com/Interview/Design-and-code-a-system-that-can-accept-millions-of-events-in-real-time-and-report-the-number-of-events-for-the-last-10-mi-QTN_187032.htm 2) Design … Continue reading

Posted in Algorithms | Leave a comment

Binary Tree Algorithms

1) Find deepest node of a binary tree (Karumanchi, pg 120) 2) Find height of a binary tree (recursion method) (Karumanchi, pg 119 , with small correction) 3) Find height of binary tree (non recursion) (Karumanchi, pg 120, with small … Continue reading

Posted in Algorithms | Leave a comment

What is ob_start in php ?

The PHP output buffering will save all the server outputs ( html and php prints) to a string variable. So to start buffering, use ob_start(); this will keep saved any output. Then you use $variable = ob_get_clean(); to stop buffering, … Continue reading

Posted in PHP | Leave a comment

Explain PHP namespaces

http://daylerees.com/php-namespaces-explained Previously in PHP you can’t have two classes that share the same name. They have to be unique. The issue with this restriction is that if you are using a third party library which has a class named User, … Continue reading

Posted in PHP | Leave a comment