RSS

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

 

7 responses to “Interviews

  1. 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

     
  2. 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

     
  3. 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?

     
  4. lalit

    October 21, 2009 at 5:08 pm

    Difference Between Primary key and unique key?(Any 2)

     
  5. lalit

    October 21, 2009 at 5:10 pm

    Type of Mysql Storage. Difference Between MYIASM and innobdb

     
  6. lalit

    October 21, 2009 at 5:14 pm

    What is advantage Mysql5 over Mysql4. Which version you are using and why?

     
  7. IDM

    March 4, 2011 at 6:29 am

    great work sandeep

     

Leave a reply to lalit Cancel reply