Skip to main content

Raw Material for Interview

//Companies Product base
Wifi-Soft Solutions - Performance tounning queries (ram, database tunning)
Ansh system - frameworks, zend certified
Etouches - Event management products
Contnet Sphere (InBetween) - Database level
CDK Global
UB Soft
Info Vision
Invanto

Infobean
Xento
Zensar


//book
PHP performance

Full stack developer - UI + Js + css + NodeJs, angularJs, PHP

Q1.What is SQl Injection?
Q2.How SQL injection can be prevented?
Q3.What is DOM?
Q4.What is cross site scripting and how it can be prevented?
Q5.What is Restful Webservice?
Q6.How delete operation can be performed using Restful webservice?
Q7.What is ajax?
Q8.How ajax functions?
What is session fixation attack?

PHP::
What is clustering?
What is session?
What is Type Hinting?
Magic Methods?
Final Keyword?
Static Keyword?
Scope resolution operator?

MySQL::
What is difference between InnoDb & MyIsam?
What is indexing?
How many indexes we can apply on a table? -- > individual max 64, composit max 16.
What is store procedure?



What is PRIMARY/MASTER db and SLAVE db?
Which DB size will be large if we use 2 DBs, one with MyISAM and another InnoDB?
Difference between using char and varchar?
What are transactions in MySQL?
What is DB normalization?
What are MySQL database engines?
Explain WHERE & HAVING clause?

Other::
Explain MVC architecture.
How can we improve site perfomance from all perspective? (PHP, MySQL, Caching, HTML, CSS, JS)
Tell me about the release process that you follow.
How do you do code review?
How do you do Unit testing?
What is difference between GIT merge & rebase?


What are data types in PHP?
List Query selectors in Jquery?

//MySQL Tutorials - Understanding SQL CREATE, ALTER and DROP Statements


Get salary for 3rd highest employee.
Get top 50 records from table.


//Ansh tech, Vadgaon sheri
Dependecy injection.
Type hinting.
Goto in PHP.
Programe of calculator 8 steps submit/use parameters from commandline (php sum.php sum 1,2).
programe on gd library.


///Main points Questions for preparaion


>> Oops concenpts, inheritance, interfance, traits.

Nginx and Apache

>> REST, APIs, XML, JSON, CURL

>> Optimization(database, source code(css. js, image, html), caching), mysql master and slave working, caching, load balancing, types of caching techniques(Memcached, Redis), what is DDL, DML, DCL in mysql?

>> SQL database trigger, store procedures, views, indexing, storage engines supports and use,

//How To Share PHP Sessions on Multiple Memcached Servers on Ubuntu 14.04

>> What are triggers and working and storing/calling process of triggers.

>> What is session and cookie and working on same?

//difference between compilar and interpreter.
//REST and SOAP.

//Laravel project link
https://github.com/iprogrammers/iplaravel
https://www.mithiskyconnect.com
//need to add bellow in Oops concept
https://docs.google.com/document/d/1ld3Y7CtGr3d6VAEJ1uOGvKIL8tAABdpfJU3NbvhNIQc/edit?ts=59f0a041


//Interview questions from CJ

https://stackoverflow.com/questions/3344816/when-and-why-to-use-abstract-classes-methods
https://beginnersbook.com/2013/03/oops-in-java-encapsulation-inheritance-polymorphism-abstraction/

//Team Leader Interview Questions
http://web-tech-experts-notes.blogspot.in/2017/04/symfony2-interview-questions-and.html

//Object oriented javascript and how to create class and prototype in javascript?

//object oriented programming?
abstract class and interface difference?
what is traits and how to use?

AngularJs and elaborate in coding.example. angular js filters.
HTML 5 and use of same.
PSD slice and create HTML.

//symfony 3 crud operations
https://github.com/vitthalaa/symfony3-crud
https://symfony.com/doc/master/bundles/SensioGeneratorBundle/commands/generate_doctrine_crud.html
https://www.youtube.com/watch?v=-xTmQ_iv5NI



Enterprise level Distributed Object Oriented Application?
Good knowledge of Agile Methodology (Scrum and Extreme Programming and Unified Process).
Difference between symfony 3 and symfony 2.
Difference between laravel 5 and 5.5?
video uploading functionality using AWS S3, AWS Elastic Transcoder and ffmpeg?
Worked on creating the theming structure in git like "Flavour in Andriod" and "Target in IOS" to setup the different themes ?
MongoDB
NodeJs
Laravel
CodeIgniter
Wordpress
Joomla



Print Reverse String
Print Palindrome String
Print Reverse Number
Print Factorial
Print Prime Number or check prime number
Print Max & Min value from an array

Javascript

What is Scope?
What is Closure?
What is Hoisting?
What is Promise?
What is Prototype?
What is Inheritance?
What is Muttable & Immutable Object?
What is Synchronous & Asynchronous?

AngularJS

Custom Filter
Custom Directive
Dependency Injection
AngularJS Life Cycle
What is & difference between Service, Factory & Provider?

How many Data types
How we can achive Multiple inheritance
What are Traits
Differece between Class and Traits
What is Polymorphism
Give scenario/Real time example used in project for Polymorphism
Difference between Interface and Abstract Class
What is Abstraction
What are Comparison Oprators
Difference between memcache and memcached
How many cookie types



What are php caching
What security used in frameworks

Give any 5 statements about session
How we can expire the cookies


https://www.tutorialspoint.com/codeigniter/codeigniter_overview.htm
https://www.sitepoint.com/how-php-executes-from-source-code-to-render/


//blogs for new features and learning
Facebook
Microsoft
Linkedin
Stumbleupon
Apache Jenkin
netflix
kafina


//Resume docs
https://docs.google.com/document/d/14ZFi0LlauFc0VQE10MRUY6RVJz4V9cvRAiF5S6dzSBQ/edit#
https://docs.google.com/document/d/1wuDHD0DamJGlw3uN0EZ4B7FFOnddihCu7d_Ua-d3snw/edit



//what will be the out put
$age = array("Harry" => "21", "Ron" => "23","Malfoy" => "21");
array_change_key_case($age, CASE_UPPER);
array_pop($age);
print_r($age);

//output
Array ( [Harry] => 21 [Ron] => 23 )


//FTP connection -
fget_contents
fget_size

//file operations command
fget_file_contents
feof()

//


//Nice Quote for Resume
It is with considerable interest towards searching right position.

I am presently the Senior Web Developer at iProgrammer Solutions Pvt Ltd and have been in this role for more than 9 years. My experience and skills are PHP, Symfony, Angular JS, Laravel, JavaScript, HTML, CSS and jQuery.

Let me know if any matching position for my profile.

//Nice description for linkedined
9 years of working experience in developing business facing solutions for fortune 100 companies like CitiGroup and JohnDeere using Microsoft Technology stack and open source javascript frameworks also having experience of working globally in the US in two different stints.
Sound knowledge of code optimization,software development life cycle .
5 years of working experience in Agile development model and scrum.
Experience with investment banking,manufacturing,precision farming and geospatial tool development.
Good expertise in leveraging open source technologies for the project.
Expertise in use of open source js frameworks like JsLinq,Backbone,jquery,jquery-ui.

Specialties: . ASP.NET MVC,NET, ASP.NET, ASP.NET AJAX ,C# ,LINQ,Jquery, Sql Server, VB.NET ,Agile Scrum, Entity Framework ,REST ,RESTful WebServices ,ESRI,Javascript,Jquery.

Extensive experience in using open source charting frameworks like D3.js,syncfusion,highcharts alongwith the Json data.

Database:SQL Server,Oracle

//imp points to be need to clear
First Optimization
PHP/Mysql Internal
PWA/AMP
pull/push protocol


//New technologies to learn
Angular Js (2, 4)
ReactJS(Java Script)
Ember
d3.js, HighCharts.js
Apache ActiveMQ
Laravel 5
Symfony 3
knockout.js
RESTful services
web services using SOAP & Rest
Salesforce
Magento
Python
Go
Bootstrap
Lync Administration
relational database design
OO programming language
version-control systems like SVN or GIT (release processes)
write Stored Procedures, complex queries
latest development trends
Agile Development Methodologies
Senior Talend Developer
Apigee Developer
HP OO Implementatio
Sharepoint basics WSS and SPS features
programming languages (Python, Go, Java, JVM Hotspot, HTTP, HTTPS).
Windows Driver Development
Object Oriented Design and development
Strong foothold on OOPs concepts, TDD/BDD, design patterns, data structures
Agile Project Management in JIRA
Understanding the fundamentals of the HTTP protocol
Droplets with the Ubuntu 14.04 image
Pusher
propel and Doctrine
XDebug profiler
profiling tool like xhprof
Clouser function
Scala
Clustering in PHP
Clustering in Mysql
Agile methadology
what is Scrum and how you follow it?


//New applications for DevOps
Eclipse
Jira
Git
Puppet
Chef
Ansible
Saltstack
Sensu
Splunk
Nagios
JUnit
Selenium
Lisa
Load runner
Gradle
Maven
Jenkin
Ansible
DynamoDb
Tire architecture 3/4
phpstorm-git //editor



//Idiomatic JavaScript (https://github.com/necolas/idiomatic-js)


//Skills
Must be a team player. Must be able to collaborate with other team members to solve issues.
Good problem solving skills
Ability to write clean, coherent design documents
Great self-management skills and be able to work completely independent on projects
Idiomatic, and documented JavaScript
Frontend web development programming (Angular, React or Ember)

Comments

Popular posts from this blog

Learn phpfox

PHPFox  is a social network script, it is an internet application and when you install it, it is a website. The  phpfox  script comes in 3 packages, each with a different set of modules. it has two products: 1. Nebula (upto phpfox 3.8) 2. Neutron (Newer) You can check the demo on :  http://www.phpfox.com =================================================== To clear cache in phpfox follow the following steps, admincp >> Tools >> Maintenance >> Cache Manager >> Click on Clear All button =================================================== To work facebook app on local Following settings need to done in facebook app   1) go => setting => Advance 2) see "OAuth Settings" area and set "Valid OAuth redirect URIs" =  http:// projectdomain /index.php?do=/user/login/, http:// projectdomain .com/index.php?do=/user/register/, http:// projectdomain .com, http:// projectdomain .com/index.php 3) en...

Interview PHP

>> Why do you want to work at our company? Sir, It is a great privilege for anyone to work in a reputed company like yours. When I read about your company I found that my skills are matching your requirements.  Where I can showcase my technical skills to contribute to the company growth. >> What are your strengths? I am very much hard working and optimistic. Hard Working: Work with dedication and determination. Optimistic: work with positive attitude. I am a team player. I am also very hardworking, and will do what it takes to get the job done. >> What are your weaknesses? Gets nervous when talk to strangers I am a bit lazy about which I am not interested I tend to trust people too easily. I am working on it. >> Why should I hire you? With reference to my work experience, I satisfy all the requirement for this job. I am sincere with my work and would never let you down in anyway. I promise you will never regret for the decision to a...

How to Make Your Own PHP Captcha Generator

In this article we will create file based simple yet successful captcha generator. 3 Major Anti-spamming techniques used? Mathematical Operation like Random number + Random Number = -> The user must specify the answer Random word -> User must type the word Random question -> Obvious one which the user should answer correctly [ex: Are you human?] How Captcha works? The captcha generator generates an IMAGE with the question and then put up a session variable storing the value. User input though an input box. Using php POST, we compare the session variable data with the user input and tell whether its a bot or human. Its coding time The Code First let's write the php script which generates the captcha image. We use the simple header-content change technique, from which we can easily bring up an image from a given text. captcha.php PHP Code: array("Num" => "Num"), 1 => array("Are y...