Interviews
There are some useful interview questions for LAMP……… 😉
Ajax
> form attributes
> Ajax -> Sajax
> ajax states
> ajax object
> server code 200,404,500,300 etc.
> readyState
> Synchronous/Asynchronous flow
> prototype/json/jquery/mootool – frameworks
> empty tags
> get/post in ajax
> ajax errors
PHP
> php4/php5 difference
> mysql vs other DBs
> LAMP version
> php variables
> session management
> manage heavy database
> MVC Arch.
> Zend – config file, class arch.
> upload file content check
> Frameworks
> caching mechanism
> xml parser
> smarty – templates, caching
> server/client side validations
> array_merge()/array_combine()
> array_sort/multisort
> upload file by streaming
> php on IIS
> mysql_connect/mysql_pconnect
> connection pooling
> include/include_once/require/require_once
> implode/explode
> split
> substr/ereg/preg/eregi
> output buffering
> php execution
> encryption/decryption
> date function
> array function
> image function
> ftp function
> URL function
> link/unlink/unset
> curl process
> php errors/warnings/notices
> video streaming
Database
> views
> triggers
> serializability
> query optimization
> queries join
> mysql storage
> indexes
> cursors
> stored procedures
> candidate, foreign key
> transactions
> events on queries
> unique/primary key
> normalization
> top third in table
> type of sql commands
OOP
> Inheritance
> multiple/multi-level inheritance
> polymorphism
> abstract class – use
> extend/implement
> public/private/protected/private-static
> base class
> derived class
> friend class
> interface
> overloading
> overriding
> virtual function
> static class/variables
Dileep
September 7, 2009 at 4:02 pm
Here are some more points
sql injection
php safe mode
advantage/disadvantage of AJAX
what is need of framework or MVC architecture.
var_dump
mysql_asort
MySql is DBMS or RDBMS and why
final & finally difference
svn
wget
htaccess
types of loop in php
Dileep
September 14, 2009 at 8:46 am
Some more
Why we use interfaces?
recursion
abstract function
Database indexes
How Indexes works
Difference b/w MySql & MySqli
lalit
October 21, 2009 at 4:45 pm
How we can kill more process in linux using terminal window?
How we can schedule process that run in a specified time in linux?
How we can differentiate between passbyvalue and passby reference?
How you can use interface? How it is useful over abstract class?
lalit
October 21, 2009 at 5:08 pm
Difference Between Primary key and unique key?(Any 2)
lalit
October 21, 2009 at 5:10 pm
Type of Mysql Storage. Difference Between MYIASM and innobdb
lalit
October 21, 2009 at 5:14 pm
What is advantage Mysql5 over Mysql4. Which version you are using and why?
IDM
March 4, 2011 at 6:29 am
great work sandeep