PHP

All Things PHP

Q1. Draw star pattern like. n=1. * n=2. ** * n=3. *** ** * n=4 **** *** ** * n=5. ***** **** *** ** *
Given an array of numbers [1,3,3,5,9,4,1,10,9,7,2,7], Write a php function that will print numbers that are not duplicated in array. [5,4,10,2]
First round is pattern based question like.. n=1 n=2 n=3 * * * *** *** *** * * * * ***** ***** * * * *******
Whats the angle between the minute pointer and hour pointer at 3:15
Draw a reversed T pattern which would generate on dynamic series by giving odd input * * * * * @ @ @ @ Second Question is : * * * * * *
Get the last thee max salaried person from table via sql.
I was having 8 Yrs of experience but they asked me how to access array elements
12: one ring bells at 20 sec, second will 40 sec and third will 60.at what time these three will ring together?
Tell me about yourself. What technologies you learnd?
1.hr interview-they check your verbal and written communication ability 2.written test consists of 10 questions with mix of javascript and php 3.technical test - here they ask you to install LAMP ,Wordpress, Virtualization and/or FTP
Web Services (how have you used them).
About the learning curve - are you ready to lean & deliver
It was an assessment, so basic questions on PHP/MySQL.
How much did you make at each of your previous roles?
What is PHP
What's your favorite text editor?
Where we put the business logic in the MVC Design Pattern ?
1. Tell me about yourself?? 2) write a note on a topic which is not related to technology??
Only Time Pass. Not Required the PHP developer. How to load the website quickly in mysql.
what is mvc?
how do you swap two variables without using temporary variable
Convert str to array in php
Convert array to str in php
What is difference between echo and print
Write the code of upload a file in php.
Code in php a Checkerboard 5x5 and output it into html
What is Php?
cut round cake in 8 pieces using 3 straight lines, draw on paper
Tell me about static variables
create a web page and connecting it to database
1. Display sum of 1 to N numbers 2. Display 1-100 numbers in each line where if it is divisible by 3 then '' if by 5 then '' 3. Write code to display a square with ' * '
If you are in the race and you crossed the 2nd person in the race then what is your position?
Sample streamed data Please write a program stream-sampler that receives and processes an input stream consisting of single characters.
Consider generating a monthly mobile bill for data usage. A basic charge of Rs. 200 allows for 20GB of data per month, with a daily cap of 2GB. The user has to pay Rs. 200 per month irrespective of the amount of data used. For each additional MB used above 2GB per day, the user is to pay an additional Rs. 0.025. Also, for each additional MB above 20GB for the whole month, the user needs to pay an additional Rs. 0.05. Assumption: 1GB = 1024MB Write a function that does the following: - Accepts an array containing daily usages in MB for a month - Calculate the total monthly bill for the input, including the additional charge for exceeding daily and monthly limits, if any. Sample Input/Output Input Data usage: date of month => data used in MB Array ( [2] => 3000 [5] => 1250 [10] => 2000 [12] => 300 [14] => 900 [16] => 4250 [18] => 2560 [19] => 1500 [22] => 190 [26] => 2020 [28] => 5050 ) Output Array ( [baseCharge] => Rs. 200 [dailyAdditional] => Rs. 166.7 [monthlyAdditional] => Rs. 127 [totalBill] => Rs. 493.7 )
SQL: you have a table with customers, with gender m and f. Write a query to update m with f, f with m in a single query, without temporary tables
how can you display 3rd highest salary from database?
how can you handle errors in php?
how to send a http request in php?
In depth concepts of OOPS.
How will I increase security in a Contact form using PHP
difference between sleep and wakeup?
difference between include and require
Fibonacci series
How to get the data from more than 3 table without use join ?
How does PHP work?
What are the common uses of PHP?
What is the use of "echo" in php?
How to include a file to a php page?
Differnce between two dates
Php error handling questions
Difference between CURL and ajax
Group by VS order by main Difference ?
What is pear?
What's the difference between an interface and an abstract class?
Differences of abstract and interface?
abstract class?
How to fetch last two records from the table
i could do OOP
Phalcon framework
Transform an integer to a string using only arithmetic operations. Known in C as 'itoa'.
accessing a class via :: means
do u know anything about php
Traits in php
who is the father of php?
They ask me to write an API to retrieve messages, retrieve a single message and to update a message.
Difference between GET and POST?
How to call Curl
Did you worked on payment gateway ?
PHP Array and Mysql Engines?
What is the difference between an abstract class and an Interface ?
sql statements
Did you use any frameworks in the development process ?
Given a sum and an array, print out pair of elements that contribute to that sum?
What does SOLID mean in programming terms
Responsive design
What is I in mysqli?
Do you have any experience with PHP frameworks?
I was given a task on machine to design/create a data base in MySQL for around 7 categories, and the key was to do task with PHP OOP's concept.
Multithreading questions
Caching
Send a mail with attachment using phpmailer
Calculate the salary of all employees and print them basic, HRA, allowance, tax and education cress in pay-slip.
Calculate the education cress of all employees in the company and print them
Display the 2nd highest net salary (salary after all deductions) among all employees
Rank the employees from highest to lowest. Please add a rank field in display grid. If 2 employees are drawing the same salary, their rank will be same. Following are the employees and their salary details: 1) Rajiv -- Basic - Rs. 5500 -- HR - Rs. 2500 -- Allowance - Rs. 1000 2) Meghan -- Basic - Rs. 5500 -- HR - Rs. 2500 -- Allowance - Rs. 1000 3) John -- Basic - Rs. 15500 -- HR - Rs. 7500 -- Allowance - Rs. 4000 4) Brian -- Basic - Rs. 10500 -- HR - Rs. 5500 -- Allowance - Rs. 3000 5) Rajiv -- Basic - Rs. 35500 -- HR - Rs. 13500 -- Allowance - Rs. 10000 Create the code in MVC model. Keep the model, view and controller layers separate.
Was asked to make a small Laravel project that backups all the databases(yes there can be multiple) on a click
What are the new trends in PHP
There are 8 stones, each has the same weight, except of one, which is heaviest. How would you discover which one?
Difference between new and old versions of PHP
New functionality in Laravel
My practical PHP achievements
My Projects, Challenges
My R & D track record
How will you load the model in codeigniter?
sessions
algorithm to find bishop movement in chess
Git, frameworks, linux
asked about dissertation for my masters degree
what additional value you will bring us to the company?
What is OOP and what are its advantages ?
How many years do you have experience with PHP?
how long do you want to work for ATL foundation if you get selected.
can you work under pressure
What do you know about DHCP?
Ask basic questions like OOp concept Php basic Sql Query
There is a programming exercise that you will code a car parking management.
http://www.geekinterview.com/question_details/83626
what is php,ajax,javascript,jquery,html?
Tell me about your self?
What is MVC architecture?
Type of Framework?
Latest version for PHP and Bootstrap?
Q.What are you Qualification?
When did you graduate?
Name at least 3 different PHP frameworks, and pros and cons of each one.
If I emailed you to offer you this position how quickly could you respond to me?
Tell us how you handled a very challenging technical problem
What is class and objects? And all about mysql and php?
How do you teach yourself new things?
how to set csrf token in codeigniter?
Create one simple admin panel. Where admin can add/update/delete product details like name, quantity, price, active. (Done) - Now the user can add product into cart after login (cart will be local, no need to save into DB) - When user checkout all cart related details are added into database. - Now the admin can see all the order details. - Admin can see the top 10 selling products. Other Info ------------------------------ - Use Laravel 7+. - Add proper comments into code. - Add 100k products using seeders. - Try to optimize DB query and relations.
Why do you want join this company?
Do you have experience with FileMaker?
Can you build a dashboard with a PHP backend?
Show how to traverse a tree.
What is my previous experience
design patterns
object oriented programming
What is PSR-2?
question about mysql joins, etc
How does SSL work?
Why do we need 3rd party SSL providers while we are able to create our own certificate?
PHP Frameworks
create a project with CRUD, one algorithm logic and insert data in db for testing.
Query to get the 31st highest salary.
What is usermeta function in Wordpress
Are you willing to sign a bond ?
I was asked to submit a practical project/test in PHP Laravel framework
What does "final" mean in a PHP class?
Technical questions related to PHP concepts like namespace, MVC architecture, sql, API integrations
wap to give output 00000011111 input is 01001011
Form validation using jquery .
System Test: Add, Edit, Delete, View user in PHP
Agile concepts
how you would create a user login system from scratch (PHP/ Mysql)?
Difference between == and === ?
what's the purpose of vendor folder
What is SQl Injection?
How SQL injection can be prevented?
What is DOM?
What is cross site scripting and how it can be prevented?
What is Restful Webservice?
How delete operation can be performed using Restful webservice?
What is ajax?
At last he asked me to write a program for all the number from 1 to 100 ,all the number that are divisble by 3 print 'FIZZ' ,all those number divisible by 5 print 'BUZZ' for thoose number divisible by both 3 and 5 print 'FIZZBUZZ' for other print the number itself (just find the mod and use if loop)
What do you think you can bring to CV-Library?
Bubble Sort PHP program by example, to find 2nd maximum number of the given array
SOLID principle, xss attack, cross site scripting prevention, REST vs SOAP, GET, POST, PUT, and other bookish definitions
They asked to rate yourself in the technology
Some questions about Coding standards like OOP, design pattern, clean code,etc.
What is difference between method overloading and overriding
Is login works when cookies disabled on browser ?
What happens when you use visit a website
What is POO
Do you work in NoSql also?
Second highest salary. * ** *** **** program
What programming languages do you know
What do relations in DB do and how do you use them?
opps question polymorphism, object access mode
What is the difference between unit and functional tests
What different in work beetwen Apache and Nginx
sorting of array in ascending order
Sort a array of objects based on one of the properties of the array.
Why did you use a custom API solution instead of an Open Source one?
How do you protect from a XSRF attack?
First she asked me asic concepts of php then she asked about mysql join queries.
What is MVC Framework, What are the most prominent features of CodeIgniter? Explain controller in CodeIgniter.
Who founded php
How to add aws plugin in PHP?
Sample streamed data Please write a program stream-sampler that receives and processes an input stream consisting of single characters.
SQL: you have a table with customers, with gender m and f. Write a query to update m with f, f with m in a single query, without temporary tables
how can you display 3rd highest salary from database?
how can you handle errors in php?
how to send a http request in php?
In depth concepts of OOPS.
1. Group by VS order by main Difference ?
print 1 to 100 no divide by 3 and 5.
Debugging the PhP codes.
How would you implement PHP/MySQL pagination?
What is the full form of PHP
They also asked about web services and major focus of interview is MVC and CAKE PHP
What is session and cookies.
have you work wth mvc like laravel, ci, zend , cake & yii ?
Mysql join and grouping
inheritance, classes etc.
Technology related questions on PHP, WordPress, Shopify, Magento
What do you know about PHP artisan? Mention some artisan command.
Can you work independntly
How can we access the data sent through the URL with the GET method?
Tell me about your roll in the current company.
constraints and triggers
How will you develop database
What are SQL Injections, how do you prevent them and what are the best practices?
var_dump(0123 == 123); var_dump('0123' == 123); var_dump('0123' === 123);
What is the need of interface?
What are the best method for optimizing php or mysql code
How to reduce http request on page loading?
What is SOLID principles?
What is my experience with Laravel?
I was given to create a small module using Any framework or core PHP.
Praktische Erfahrung mit Symfony, REST, Docker ?
Part 1. They asked about basics of object oriented programing. what is inheritance, give me an example of a sql command Part 2. They sent a php file with about 400 lines of code and wanted me to implement a design pattern to that code. You have 2 hrs to complete the task.
8 balls puzzle to solve
improve the code from the talent test according to modern software development practices. include unit tests
HTTP methods in PHP
php array functions,string functions ,laravel questions
1. How can a Cookie Value be retrieved?
1. Name the types of loops existing in PHP.
core php,js
Describe the request lifecycle in Laravel?
Write a recursive function that reverses a string
[1,6,5,4,2] -> write an algorithm to return second larger number in the array, in this case number 5
class Test{ protected $var; public function __construct(){ $this->var=1; } public static someFunction(){ return $this->var *= 5; } } What is wrong with the code ?
if(!(strpos($haystack,$needle)){ } What is wrong with the code ?
PHP and mysql questions as in other companies, OOPS concept, MySQL db concept like joins, group by, having
Write a PHP function to list out files on the html page that correspond to the filenames and extensions present in a directory, which of course relates directly to the type of work iDrive does, working with files, backups, and interacting with them
Write array element count without using count variable.
Difference between mysiam and innodb storage engine
maximum size of post request in php
maximum size of get request in php
maximum cookies which can be stored in browser
$x = true and false; var_dump($x);
$text = 'John '; $text[10] = 'Doe';
why to use hooks in ci
13 : how to find datatype of $i ?
Make an app for Event Exhibition, which different events, and each event has stands, provide feauture to book stand with details and documents, show details of booked stands, email visitors etc
Design an app that handles a parking lot, and has 3 sizes of parking slots.
(Reverse a string, Ascending sort an array
Binary Search
Will tell you to optimize your code and handle different test cases
types of mysql engines?
How to create object of Interface
How can protect my site from world class hackers ?
fibonacci, factorial, max, sort etc.
triggers and types
basic joomla questions
PHP basic questions, OOPS, Server configuration, MySQL Index, Joins, Optimization. MVC, JQuery... Zend Framework
How to declare an array in php?
It was about Symfony framework, multiple questions.
oops concept and basic of ci
0128 vs 128, are they the same?
Do you have any experience with Database Architecture?
How to achieve multiple DB Hosts in PHP Laravel application?
What is autoloading classes in php?
1. Simple questions like differences on implode, explode, required, include, and string functions
mysql self join
Variable name of max execution time constant in php?
Explain different types of arrays in php
laravel and crud opration
what is HTML DOM?
What is inheritance
array functions
How to extract and store, Referrer link from the Contact us form of any wordpress landing page using PHP?
Find a pair with matching sum equal to matching number
Write a PHP programme to print all 0 to 1000 numbers which are even and odd.
Are you familiar with agile practices?
What do you understand by Eloquent ORM?
Sql
How would you uppercase a string, if you didn't have access to a stringToUpper method?
Sessions and cookies
Intermediate PHP and MYSql Questions, Project design and details.
how to reverse the position of words in the string.->use explode() or split()
Some basic OOPs concepts
Find the last entry of the table
All types of joins
Write code to insert data in database
Find the count of status(even,odd) for even status.
Write code to design a HTML page of any shape he provides. I was given 5 boxes to be fixed in entire page.
How to create an array of a group of items inside an HTML form ?
What are the encryption techniques in PHP
A ladder of 10 feet is hanging from the side of a boat. 2 feet of the ladder is underwater. If a tide of 5m height comes, how much of the ladder will be submerged?
PHP desiging patterns, best way to right program for Fibonacci serise.
Laravel 5 concepts, PHP design concepts
Describe the architecture of one of your projects?
What are your future plans? How soon can you learn new technology upto working level?
what is default port number of MySQL?
what is the default SSL port?
what are joins explain briefly?
what is the difference between inner join and left and right joins?
There is an array with some elements and find out second max element of an array without using any built in function?
Write a PHP for-loop showing odd numbers from 0 - 100.
He asked me to create 2 PHP classes
Plain sql question
Describe DDD
HR: Do you know link development? Why do you want to move to Link development? Tell me more about your self and old company? Why do you want to leave your current company? What do you expect from Link dev? Expected salary? When you are ready to move to link dev? Whats the obstacles do you face with your team? Tecnical: Do you know OOP? Difference between calss and abstract class What is the interface? Why should i use interface? Do you know Unit testng? Did you used unit testing before? Whats dependency injection And some exercise
What is the "t()" function in your code?
OOP in PHP: - Inheritance - Interface - Abstraction - Magic Methods
How many years of work commitment we expect from you!
Code for finding two numbers in an array in which the sum of them will be equal to some static variable value which was already defined.
Ways to print an array
Based on tcs ninja
What is MVC, PHP , SQL
How to create a session? How to set a value in session ? How to Remove data from a session?
What is recursion? WAP for Fibonacci.
$sql = "SELECT * FROM table as a WHERE a.id ={ $id }"; What is wrong with the code ?
Have you ever handle one million user inputs in a second ?. Write down syntax for ajax call ?
Find the second largest of a table value?
Find a string character count without using string functions ?
Relationship between Inheritance & Access Modifiers
What is Multiple Inheritance?
What is indexing in DBMS?
How many engines are available in SQL?
Run time and compile time polymorphism
What are indexes ?
What is Constructor & Ho w We Implement It
6 Remove Duplicates rows from table
var_dump('0123' === 123);
Qual as vantagens do clean code?
what is the view composer?
Could you create a web application as a test exam?
difference between innodb and mysiam
string reverce without using php functions
Ben je bekend met SOLID en DRY?
class Helper{ public function getFormattedUser($a){ $user = new User($a); return $user->name.' '.$user->surname; } } Where is the problem on this code?
Reverse of String
Tell me some other software patterns, apart of MVC
Which tool do you use to manage external dependencies?
Do you use namespaces?
What framework you use/ how many SQL experience do you have? How long you use it ? How many experience do you have on that?
What does SOLID stand for?
"Have you ever handle one million user inputs in a second ?. Write down syntax for ajax call ? Find the second largest of a table value? find a string character count without using string functions ?"
What is XSLT?
Which was your biggest failure?
All the questions are related to PHP, Bootstrap, and Database. Ex: types of loops in PHP? What is the difference in col-sm and c0-md in Bootstrap and why we use this?
Q2: What logic will you follow while creating simple Login form?
What is PHP session?
How To submit data of one page to another Page Without using GET and POST?
What are the websites you've built in your previous years?
There is no difficult questions just core php and system test about add, edit and delete.
1.Object-oriented concepts. 2.Mysql Joins and Normalization and constraints. 3.Jquery basic questions. 4.Machin test to create API in Codeigniter.
Do you have exprience in laravel, megento or wordpress.
find minimum and maximum from 1 million numbers
There is array of 1 million integers (numbers can be repeatative). find smallest and largest number.
How to build a multi-user application in Laravel.
How to get last date of month of given date?
write a program add array value with function and without function.
Solve the rubiks cube...how long will it take for you?
What is Sql injection?
Ask general question on php regading function nad string
Give five array functions name in php
How do you define a helper in Laravel?
How can we get data between two dates using Query in Laravel?
Tell me about Collection Framework.
Q: How to delete a specific element in an array?
Write a php program in a textbox. You need to make the program success with getting no warning and displaying the right output within the given timeframe.
what are the successful thing in your career?
Given a link to online app. How can you split this app for microservices
Basic Questio of php and oops, array, array,variables that all.
Some logic where user selects from a drop down, so that it should display records which is related to 4 tables. Submit through ajax & display the result.
If I client wanted an app in addition to their website what would you tell them?
Mysql Joins?
Create a Fizzbuzz
Name 3 of the 5 principles of object oriented development.
Besides the question about interfaces vs classes, perhaps the most exposing question to me was, "Do you consider yourself more of a procedural developer, or object oriented?" In today's fast-moving technology skill set where advanced techniques and frameworks are touted, to admit I have been primarily procedural was a bit humbling; however, I understand I was in the #1 running for the position until they finally decided to simply not fill the position. Needless to say, of course, I did not get the job.
What is Laravel and what is dependency manager in Laravel?
What is Php ini?
write a program to print palindrome from specified range
Find the square numbers in the given range (x,y).
Q. Write a console PHP code using Standard Input / Output for the following problem: Given N numbers, [N<=10^5] we need to count the total pairs of numbers that have a difference of K. [K>0 and K<1e9]. Input Format: 1st line contains N & K (integers). 2nd line contains N numbers of the set. All the N numbers are assured to be distinct. Output Format: One integer saying the no of pairs of numbers that have a diff K. Sample Input #00: 5 2 1 5 3 4 2 Sample Output #00: 3 Sample Input #01: 10 1 363374326 364147530 61825163 1073065718 1281246024 1399469912 428047635 491595254 879792181 1069262793 Sample Output #01: 0
What are different types of errors in PHP
Three light switches in one room, three lightbulbs in another, you can only have on light switch on when you walk into the room with lightbulbs, how can you tell which light switch corresponds to what lightbulb? (Hint: The lightbulbs are incandescent)
The coding challenge asked me to calculate students percentile rank using a group of data. It required me to provide testing, scalability, reusability, etc. with PHP.
How would I optimize a db query
Are Multiple inheritances supported in PHP?
Your biggest failure and what you did after it happened.
All the core concepts in PHP
You tried your 100% to solve an issue but you didn't get succeed and your TL is not available/busy at that time. Then, what will you do?
preg_split()
Programming Component: How do you tell if a string is a palindrome
Do you know SOLID principles?
How do you extend two classes in PHP?
how to solve the problem when the situation that over 100000 people use the system at the same time
Which is best website according to you?
What are OOP concepts ?
Core PHP and OOPs Questions OOPs Programs Mysql Queries and Optimization concepts Zend Framework Questions Teams and Leadership Questions
If I was familiar with ERP and Magento
Create a CRUD API, and interface for it, add it to Github, create test cases
They had me design a database and during the design they continually changed how they wanted the data to act or be stored while disallowing changes to the schema.
Array Functions in PHP. Exception Handling.
1. They have asked some questions in object oriented programming. 2) They have asked to write oops technique like inheritance, Polymorphism in php language. 3) They have asked about final year project .
They asked to do PHP code for creating database and CRUD operation. And SQL queries like joins.
1.Third parameter of explode 2.Question based on group by query 3. PHP logical questions
Api Integration on machine
what is default session time
How familiar are you with different php frameworks?
They asked me to import a 30 million row CSV file in MySQL. And show a view, with charts and filters.
Are you comfortable working in more than one language?
He asked about sql connectivity in php
How to register a middleware in laravel
Given an array of words, how can you reduce the lookup of all words that contain a given set of characters in O(1) instead of O(n).
Draw for us how an ATM machine works.
How do I handle situations where there is a conflict?
Do you apply principles, patterns and proposals to your code, which one do you use?
I have a bucket of 5 litres and a bucket of 4 litres of water. How can I make 4 litres? and then generic OOP questions
They asked me how to create API ?
Describe how Laravel containers are used
Why do you prefer to use linux ?
Tell us your experience in PHP
Diff between datatype and datastructures
SQL Queries , array functions, MVC Pattern, SQL transaction, Rollback
1. Why do you want to leave your previous job? 2. Why is Java Platform Independent? 3. What do you know about Quick Sort? 4. A pattern question, program to draw a specific pattern.
8: find names of students whose age is greater than 21?
Programming Component: How do you prevent XSS/SQL injection on a simple example
How should you go about finding a bottleneck at some page at your site? (e.g. one taking too long to load). Then, if it's the database, how to solve that.
var_dump('0123' == 123);
$array = array( "1" => "a", "1" => "b", "1.5" => "c", true => "d", ); print_r($array);
var_dump(0123 == 123);
An SQL to display the count of duplicate entries.
What is magic function in php
Recursive function
To code a basic form using HTML, PHP and database
Just asked to write a program to display the table data
Why CI not Joomla ? It was really difficult to explain.
Q) take input a number N. if N is even display some error else display a matrix N*N all border elements and both diagonals elements are * and remaining elements as _ .
What would be another efficient way to divide a integer by 2 ?
How would you write a palindrome function?
what is recursive functions?
Explain preg_Match and preg_replace
What is Interface ? What is Abstract class ? Difference between them ? Database design of online shopping cart. Different questions on design and various modifications. Types of error in PHP ? How to optimize websites ? How to swap 2 number w/o 3rd variable ? Mysql Engines Mysql Index. Disadvantages of it. Various queries (finding duplicate entry, finding 2nd highest entry, etc) Finding 5th child in jQuery
Have you contributed to open source?
Then I asked cakephp Questions.
They mainly focused you are able to work with JSON data and AJAX
write a code for database connection
Program to validate emai id using javascript Define multidimensional array
associate array
update and insert in sql
What are the different types of JOINS ?
About API Integration, Working with security
array merge and array combine
What is Inner Join?
Write a php program to produce this : Input: we are hiring Output : ew era gnirih
There are 3 light bulbs in a room. The switches are outside for each bulb. You are allowed to go inside the room only once. How do you determine the connections to the bulb and switches?
What are a few personal web projects you've got going on?
To write a php code to print star pattern.
Life Cycle of laravel, Why are migrations important?
Eloquent Query Question, 1) One To One 2) One To Many 3) Many To Many
What are datatypes in mysql?
How to destroy sessions?
what are access specifiers?
Can you write me a PHP form with validation?
SQL Injection, XSS Attack, etc.
1. Write a program to print prime number between 499 and 699
what is file handling in PHP and which functions used?
How is php and mysql connect?
Q. Use of "final" keyword.
They gave me an array starting with 0's then 1's need to find the first index of the number 1
what is POD
groupby query and joins
What is array function,string funcction,basic php questions, Laravel default structure,
How to make Laravel package?
hastable
Which difference between Constructor and Abstract Сlass and why?
How many database indexes can you have in a single table?
Difference between sort by and order by.
how would you go around solving the N + 1 select problem?
anagram
What is Middleware in Laravel?
what is index in mysql
What is faster $i++; or ++$i;
distribute system design
Database design was challenging.
database schema design
Where do you see yourself in N years?
Laravel middleware, Eloquent, migrations, seeder, artisan , MySQL joins
Explain what the composition is?
OOP, OOD, ACID, DB indexes, PHP traits, micro-services, docker, testing, TDD, DDD, Architectural patterns, NO SQL, SQL Joins, group by
Describe one of the anti-pattern in OOP
What other design patterns except for SOLID do you know
What is a service container and how it works
1. Basic PHP knowledge. Types, Arrays? and etc 2. Writing MySQL query (3 different query). 3. OOP questions 4. Js questions (types, closure, execution context) 6. Css questions 7. HTTP methods, Status codes 8. Dessign patterns only about singleton
questions about SQL joins and different type of joins. in a left join, what will be returned from right table if don't find any matching rows from the right table?
sort a array of objects based on one of the properties of the array.
Basic PHP, SQL, Object Oriented programming questions. Like what is expansion for PHP. What is abstract class. What is a class and what is a object. Difference between PHP Version 3,4 and 5. Singleton?Different Joins in SQL.
Can you name most of the common HTTP status codes?
How do you scope vars in PHP?
Have you worked with MVC?
Tell me about MVC in PHP
1. Difference between array combine and array merge 2) Preg_replace 3) PEAR in php 4) REST VS AJAX 5) REST VS SOAP 6) Second highest salary 7) sort a array with predefined function 8) Create a class and call add and subtract function 9) Mime type 10) Markup language used in rest web API 11) why this error occur header already sent. 12) difference between put and post 13) HTTP method supported by REST 14) Mysam VS Inno Db 15) INNER JOIN VS LEFT JOIN 16) TRAITS 17) FINAL CLASS 18) MAGIC METHOD 19) complex mysql query 20) PUT VS POST 2nd Round 1) how to implement Security in app 2) MYSQL DB question what is layers in mysql , myisam VS innodb , master slave, optomise datbase , datalayers 3) Server commands TOP , one , c
What is Stack, Linked List & Queue?
Write pyramid structure without using PHP function ?
Are objects passed by value or by reference?
How do you call the constructor of a parent class from a child class?
What is meant by urlencode and urldecode?
How do you get the headers of a request?
What is multi-tenancy?
What is searialization
what is use of traits
singleton Class
use of Trait by Creating Singleton Class
best PHP framework to develop ecommerce website?
How do you work under pressure?
How / why would you use a composite key (in MySQL)?
What is PHP, Define Client side validation and server side validation. Define GET, POST, PUT METHODS. Define Ajax., Smarty, framework. Most Important OOPS concepts.
How do you setup CI pipeline ?
What are joins?
What you know about micro-services and why we need it? (answer as much you know)
1 What's the difference between __sleep and __wakeup? 2 what is the definition of a session? 3 What does $GLOBALS mean?
explain what is die() function
Find min and max from array of 1 million
Data abstraction vs polymorphism
Do you have experience working with rabbitmq?
Variable name of max execution time constant in php?
WordPress i18n Translations - Where yoiu will have to translate string with php variables using .mo files.
what are the version of web browser
What is this and super keyword? What is an Interface? Factorial using recurssion Inner join and left outer join Number pattern
As per experience Like about Rest API's ,auth, code security,3rd party integrations
What is REST API (never entertained a discussion on it or asked me how do I design a set of endpoints).
The value of the variable input is a string 1,2,3,4,5,6,7. How would you get the sum of the integers contained inside input?
Q: What is inheritance in java,singleton class,Exception handling,and a lot of sql query they will give you table and ask relevant sql query based on the table.
JWT
Api security
Q: Difference between $var and $$var?
How do you create a new branch with git?
Have you ever used an SVN for source control? Which ones?
Questions about multithreads and some java basic questions.
What is AJAX?
About HTTP and Database Queries
What does var_dump() function does in PHP?
Difference between REST and Web Service there Types, Web Scrapping , AWS Services,Machine Test
All basic question related to Laravel & PHP. session cookies routing middleware etc
What is 2 tier and 3 tier architecture?
Why should we use RDBMS or whaat was challanges with traditional file systems?
what is advantage & disadvantage of MongoDB?
Sql joins and types, sql engines, jquery basics, php oops
Use of CORS in api development
Create a web page of Pizza Delivery order and calculate the total of order and display
Do you like working on legacy code?
$str1 = 'yaboalkdfjal'; $str2 = 'yado'; if(strpos($str1,$str2)){ echo """ . $str1 . '"does contain' . $str2; }else{ echo """ . $str1 . '"does not contain' . $str2; }
What are abstract class?
Write a simple program to handle a file uploads on a given form.
Aptitude-You have 2 phones. You are on a 100 floor building. You drop the phone from a particular floor. It breaks or survives. If it survives you can throw the same phone from a higher floor. How many attempts do you need to identify the max floor at which the phone doesn't break when thrown down?
What are the main differences between const vs define ?
Implement a Priority Queue in PHP
Method overloading ,method overriding,JavaScript basics,java,SQL queries especially and about project.
Jobs and queue in Laravel
Psr standard
Hooks in codeigniter, precontrollers and postcontroller
How do you keep up to date with latest technologies and trends?
difference between string with single quote and double quote in php. "string" vs 'string'
Design a vending machine
What is PDO in PHP? What is the use of ini_set()?
what are Constraints in mysql
what types of selectors in PHP?
Types of join, inheritance supported by php, Access specifiers, triggers, database queries.
What is web clustering?
difference between primary key and unique key ? Difference between index and primary key
Do you know PHP and FuelPHP
relocate,salary,reading for api, reading from csv and merge data
What could be a downside to Laravel eloquent
What is unit testing, integration testing, specification testing
MySQL related questions and queries, joins, sql functions, triggers. How to copy data of one table in another with a query?
If we want you to give yourself a grade from 0 to 10 about PHP language and Laravel Framework, what would be the grades?
Difference among various php versions
Describe how a refresh token works?
insert update delete in PHP
Print Pattern, Databse optimisation, php string funtion
Recursive function in mysql
difference between die() and exit() function
associative array
Find number of lines, chars, words in a file.
CRUD Operation in codeigniter. Product table and category table. Add product edit product delete product etc
Relationships in Laravel
Which method is used to start the session?
What is ascii?
Do you know what PCI is?
What is reflection
What is normalisation What is polymorphism Sql Querys
How to scrape the data from website using CURL?
How can i execute PHP File using Command Line?
What are different type of sorting functions in PHP?
Find the defect in the SQL query and correct it so that the query executes : SELECT ID, YEAR(billing_date) AS billing_year FROM table WHERE billing_year <= 2015
what is inheritance? How many types?
What are ternary operators?
Expect behavioral and code structure / paradigm questions.
Lifecycle of code. From request to response.
Differences between JWT and OAuth tokens.
What is hooks in ci? What is traits in ci?
Please describe yourself using JSON.
are you aware about mongodb?
trigger & stored procedure
function overloading
Type casting & type juggling
What is the last version of PHP
Differentiate between delete() and softDeletes() 2. Define Laravel guard 3. what is facade
Difference between unset and unlink?
A Cipher text paragraph was given and the Standard distribution of letters in the Decrypted text was also given.Based on this we have to decrypt the text..
strstr() use in PHP?
The homework was to write a Drupal 7 module that displayed a list of posts updated on the current day inside a block. The module needed to have a test case included.
What do you save for product information in cookie? How to retrieve cookie information? Get max salary without WHERE condition in SQL query.
Is HTTP stateless or stateful
wap to find max prime number from an array
How can u calculate date difference in php What is dot operator Print array without loop
What size teams are you used to working with?
What is Cross Site Scripting in a nutshell?
What are the differences between versions 5 and 7 of PHP?
What are Events in Laravel?
what are cloud computing advantages, what is Caching, Docker
oops concept SQL queries CRUD operations set method why $ used
How do you make a file executable in bash.
5: Triggers ,Stored Procedures, Events
7 : Self join query
How to validate the password field with regex
abstract classes
What is ajax attributes ?
What is the difference between using PHP and the Zend framework?
find second max number from araay
How does MySQL create indexes
Did ever work with SPL functions
Create a middleware to authenticate against JWT in Laravel.
How to migrate a monolith project to microservices.
How much work have you done with database design or maintenance?
What's the best way to approach the open-closed principle using Symfony pre-built feature
Concurrent Access and Locking - how to handle it and what's the default state of MySQL database
I had to refactor a sample of code based on SOLID principles. On trial day I had a feature from backlog to refactore and propose a new architecture.
how does db indexing work
What is CSRF, what is sql injection, what is cross site scripting?
What would you like to see on your tombstone?
Do you know how SQL escape works? explain how it is works.
How do you protect from a SQL injection attack?
Interview questions will be easy: 1. Joins in mysql table. 2. Design a dynamic webpage whether its a login form or anything. 3. count() funtion mysql etc.
describe slim framework?
What is a web server?
What types of APIs? (answer with details)
How to write a clean code? (answer with details)
what is the difference between cookies and sessions system test- crud operations
Difference between constructor or distructor in php?
How can we convert the time zones using PHP?
Write syntax to create cookies? JOIN queries syntax ? Several real time problems
What is database engine role in Database, why they exist ?
What is abstraction.and What is the difference between abstraction and interface
Middleware
Questions related to recursion and join.
- Simple encapsulation, polymorphism - Some basics of the Framework - MVC, PHP, MySQL, Design integration - Some technical questions and use case based
what msqli_connect() function return answer is connection
what is implode explode
Polymorphism, PHP magic methods, reverse a string without string concatenation, swap two integers without using a temporary variable (they give you hints, if you need), why use private and protected key words
In PHP what is the difference between a Class and an Interface?
PHP and MySQL syntax 1. DML Statements 2. DDL Statements 3. DBMS/RDBMS 4. Subquery with example 5. Core PHP questions
What is oracle's latest version?
Difference between ksort() and usort() functions.
what ob_start ?
what is cURL , SOAP , File handling , have you used Session & Cookies , what is inter-relation b/w them ?
Any experience with Laravel/PHP work?
Q: What are the types of joining in the database are used?
how mongodb is better than relational databases?
Why you want to join Contorian.
Practical Test: >> Three Questions were there 1. Draw a pattern. 2. Ajax request. 3. CRUD application. F2F interview: 1. What is indexing in MySQL. 2. What is the difference between abstract classes and interfaces. 3. sessions and cookies.
Difference between HTTP and HTTPS
1. write a program to find the number is prime or not.
1. How to provide security to your website 2. what is crossscripting 3. Explain mysql and joins 4. what would be a change which you wish to make in society
Talk about PHP opcode caching.
Implementing a Priority Queue.
1. Write a program to print nth position from fibonacci series.
1 divisibility test
Folder structure of Cakephp Relationships Validation MVC
Q. Name of superglobals.
Q. Name of SQL Engine.
What features do you like in php7?
what are different design patterns
Pattern Programs
PHP associative array add and delete operations
Basic PHP questions , access modifiers, abstract classes, connecting to DB, where are they used? provide a good example?
PHP Arrays, MySQL , Rest API etc
REST API authentication
What is header, tcp/ip, ajax, http, json, response type, post, joins left join etc
htaccess file is used for?
What is GDPR, Hipaa security rule, Security laws in India, Europe and US
Print below pattern using PHP 2 2 4 2 4 6 2 4 6 8 2 4 6 8 10
Dipendancy injection
Difference between primary and unique key

SQL Injection CSRF Token Hooks in CMS How to avoid sql injection attack PHP most used functions

write MYSQL Query for selecting top 3 employees with maximum salaries

Q: You have a DB which contains 10 lakh SMS, How will you define your architecture to send 10 Lakh SMS in 1 Day..?

What is difference between an interface class and abstract class?

```
what is an ORM
```
```
MySQL joins
```

1 what is PHP 2 : codeigniter in helper 3 : helper used then remove Helper 4 : what is array in array print to echo 5 : what is api 6 : what is third party api 7 : what is domain 8 : SQL full form

Caching mechanisms - Redis, Memcached and their distributed nature.

Perform a mock pull request review, identifying areas of concern or improvements in terms of performance, security, maintainability etc

In 2nd and 3rd round they asked questions based on javascript and PHP 1. Use of const, var, let 2. What is callback function. difference between call back and promises. 3. What are hooks and how to use them. 4. Difference between class,library, helper. 5. List some basic helpers. 6. database setting questions 7. PHP mail function 8. What is API and what are uses. 9. What projects have worked on.

DDD and micro-services, life cycle of a single HTTP request, SQL engines insides, some data modelling...

How to scrape a website and find keyword density.

```
About PHP MVC ZEND MYSQL
```

PHP Login Register with database with session being carried on all pages.

1. Codeigniter hooks 2. Laravel middleware 3. Templating engine 4. Docker 5. A same old internet picked logical question.

```
Revert a linked list using recursion.
```

triggers in MySQL, Web services tokens, authentication and authorization.

Checked tech background and given homework to build a small API.

Array, superglobals, Functions, Coding like array sorting.

prototype and plugin development with jQuery or javascript

Session, db queries, opps, array, string

what is your favourite PHP extension :-)

What sized websites have you worked on in the past?

```
swapping dbms
```

Differrence between mysql_connect and mysql_pconnect?

```
What are magic methods?
```
```
Write some string functions?
```

What is the difference between restful API and SOAP?

What is the life cycle process of Laravel?

1. What is an artisan? 2. What is model? 3. What are the default route files in Laravel? 4. What are factories in Laravel?

Online test, Oops , php 7 , javascript ,let , trait

```
what is heredoc in php
```
```
Write a closure.
```
```
How do you balance a binary tree?
```

How would you describe a trait in your own words?

What is JSON? What are its common usages?

When writing a class, what are the three scope levels available in PHP? Give a short description of each.

PHP OOPS, PHP Array functions, MySQL index & Optimisation, Procedure, Trigger, PHP FIle handling (Read data from a file, Write data to a file), basic Linux commands, GIT commands

```
Q: Make a full-pyramid pattern?
```
```
cron job
```

N+1 problem in laravel, session hijacking

Difference Between $ and $$ and $$$ in PHP?

How would you fix lack of multiple inheritance in PHP

SOLID, Patterns (architectural and design), Testing, BDD, TDD, DDD, OAuth2

Describe the variable visibility scopes in PHP.

Questions on solid principle , optimise slow queries , process for epic stories in my project.

Describe building blocks in Domain-Driven Design

whats the angle between the minute pointer and hour pointer at 3:15

I was given a logic question where you have 5 balls. One of the balls is heavier than the others. What's the fewest number of times you have to compare weights to figure out which ball is heavier.

```
how to merge two tables in SQL?
```

1) Tell me about yourself?? 2) write a note on a topic which is not related to technology??

```
Tell me about static variables
```

1. Display sum of 1 to N numbers 2. Display 1-100 numbers in each line where if it is divisible by 3 then '***' if by 5 then '***' 3. Write code to display a square with ' * '

If you are in the race and you crossed the 2nd person in the race then what is your position?

Estimate how many people get married in the United States every week.

```
ACID
```

There are 8 stones, each has the same weight, except of one, which is heaviest. How would you discover which one?

1. what is call by reference in php? 2. difference between require and require_once 3. stack and queue, how this related to sorting function? 4. what's the difference between == and ===?

Write a loop that takes POST data and creates dynamic variables on the fly.

1.hr interview-they check your verbal and written communication ability 2.written test consists of 10 questions with mix of javascript and php 3.technical test - here they ask you to install LAMP ,Wordpress, Virtualization and/or FTP

Q: Please tell me the message brokers you've worked with.

```
What I know about Mphasis?
```

Island problem and some behavioral questions.

System design, class design for escalator

Explain Interrupt handling with example

Arrays Palindrome Sorting Searching Patterns

Explain Dependency injection with an example

```
Mutate a given input string
```
```
How to scale model on cloud
```
```
How to analyze the code
```
```
what is dao in room db
```

SQL based were asked, specially sub query

```
How to override a hashcode function.
```
```
Reverse a singly linked list
```
```
Find min of average data.
```

Questions for first two rounds. - Introduce about your self - strength and weakness - challenge faced and other general questions Questions 3rd round (technical) - Find the Errors for given snippet - question on bit shifting - arithmetic and assignment operators' execution preferences

extension of kadane algo . circular array given

What is the difference between DDL, DML, DCL?

Something about a binary tree traversal

How is your understanding about data communications and hardware? What is the difference between TCP and UDP?

Q: What are the different API architectures and how are they different from each other?

```
 Spark Question
```
```
 Design pipelines
```

 General database system design questions.

 Basic technical questions related to coding and especially for SQL (PostgreSQL).

 Bubble sort, SQL query to find second largest salary

```
 What is IoC (Inversion of Control)?
```
```
 Optimize the code given code.
```

 Core Java, microservices, Scenario based questions, Jenkins, database related question, data structures. Script to create, write into a file.

 What things you don’t like at work? Dependency injection Difference between BigDecimal and double

 1: Code assignment, took around 3 hours 2: Technical interview with the tech team, took 2 hours around 3: 2: Technical interview with other tech team, took 2 hours around

 What is your favorite language? Why java is platform independent? Write code on the thing specified by interviewer Questions on DSA & projects done

```
 Write a code for Reversing a String.
```
```
 Design the System just like carousel
```

 sql quries on join condition , aggregate function , keys and constrains.

```
 Heap Map Graph Linked List Queue
```

 Explain the different use cases for different hooks.

 1-Star Pattern 2-OPPS question 3-we need to find the count of the pair in a array whose sum is equal to the target value 4- we need to print the count of the even word int the given string

 1) Immutablity of a class(Show an example in IDE) 2) How will you sort a salary of an Employee? (Show in IDE) 3) Once Sort Remove the 4th Highest Salary of an Employee? (Show in IDE) 4) What are Generics? 5) Are you aware about the Design Pattern? (if yes then explain ) 6)What is Multithreading, How you used that in your project? 7) What are Concurrent HashMap? 8) What are HashMap?

 Structs Vs classes, what experience I had with what architectures and so on

 The process is as follows here :---- 1) Online Test 2) Three Technical rounds(major focus was on java + OOPS+ multithreading) 3) DBMS+Cloud+ Basics of Computer fundamentals 4) Rounds were easy if you know DSA NOTE:- I was give positive feedback and at the end of HR round, they said we can't give you more CTC as there range in only 10-11Lakh. The worst part is HR's are very inactive and they don't let candidates know the whole process they kept in dark room. Rounds are very easy and interviewer don't have much knowledge about DSA so they ask repeated OOPS question to judge you and pass the time. Such pathetic experience I had with them. I never recommend anyone to go for interview with this company if you have any other job in hand. They initiated my rounds by saying we can give you this much but at the end they put me on hold that we don't have enough budget now. Very Bad and first time I have seen such services, they wasted my whole month and even not replying to mails even after many follow-ups. DONT GO WITH NAVIS.

 Clone a singly linked list using two pointers.

```
 - Write a SQL query to join 2 tables
```

 - Given two classes written in C#, you should write constructors for them. - If you have any edits to the classes to achieve polymorphism. - Problem Solving: You have an array (not sorted) and you need to print the repeated number. - What is meant by that REST Methods are idempotent? - To build a sign-in API, what HTTP method is more applicable? - The rest of the interview was behavioral questions.

 Interviews themselves were more conversational, but with one technical problem to solve. • Python functions: parameters, *args, **kwargs • Lists vs Arrays • Class vs instance variables • Reading files • Exceptions • Sets • OOP 1. Deep copy vs shallow copy 2. Object serialization 3. Microservices a. Scaling up performance b. Horizontal vs vertical scaling 4. Pythonic way of checking palindromes 5. Reading files a. What if the file has a billion+ lines? b. Multiple ways to do this 6. Behavioral a. Time when you've mentored someone b. Time when you've presented to a large group c. Talk about a relationship you've built at your work place d. Time when you had to convince someone something e. Time when you had to foster collaboration between multiple teams f. How do you do approach research? Time when you turned a problem into an opportunity

 What is agile methodology? What is exploratory testing?

 What’s are the pros and cons of a garbage collector?

 How would you fetch a http resource in a browser, how would you implement it yourself? What OS calls would be needed?

 What’s the difference between memory management in c/cpp and say rust?

 Oops, APIs, teamwork behavioral, how you learn new languages/tools

 This was asked multiple times: describe a conflict situation you handled as a manager and how you dealt with it?

 Given a list of users and a list of groups of users, how many SQL tables would you need to create a schema for that relationship?

 The first coding problem is Count Family logins, which can be solved by using hashmap and the second one is Shipment Imbalances. Both problems can be found in Leetcode.

 Please create a web app for an online notebook.

 Q: Discuss a time that you disagreed with a colleague, and what you did.

```
 when and why would you use core data?
```
```
 What is data transformation in SSIS?
```
```
 Approach to reverse an array
```
```
 What do you know about Freetrade?
```

 A cognitive test and some questions about promises, settimeout, and the output of the code on some scenarios.

```
 How would you manage version control?
```
```
 Oops concept, PHP basic + advance.
```

 Why string is immutable concrete hashmap design pattern spring annotations

 Design a ticketing system with a way to store logs submitted with tickets as well

 On SDLC and coding based questions on palindrome, prime numbers

 Solve leetcode medium and hard problems

```
 regex apply
```

 disadvantages of ORM, app-level improvements

```
 System design design a tagging system
```

 Code 1 and 2 Write a ratelimiter, and calculate the size of the files on a system, basically do a calculation on a list of a list, and sort a list

 1. Initially the assessment was to display posts and individual post with pagination in Vue, vuex and vue router. 2. Pair programming with the team on JS and CSS flexbox. 3. Manager round. 4. HR round

 Initially interviwer start with introducting my self. asking about projects. after shifted to technical part which will be asking like 1. Explain the worker process ? 2. What is mean by web api? 3.what is mean by action filters? 4.what is mean bu normallization? 5.write a program using array list find the all the values in array?

 Ingesting, transformation of data in cloud storage platforms like ADF

```
 What is indexing in mysql
```

 Basic opps concept, Detail project discussion, SQL queries, coding question.

 Spring Accutator SOLID principles Kafka duplicate messages

```
 Scenario Faced , failure in life
```

 Coding questions: 1. A hard leetcode question 2. Network/IP address validation question

 Two technical rounds followed by hr Rouns. Prepare core java concepts, spring, spring Boot, Hinernate, JPA , weservices like SOAP Rest and some Basics Programing Questions and caching concepts in hibernate

 Tell me about your self and then coding question

 Entity Framework, Cache and how to develop it in the program, Session and which session will use under specific conditions, How to create User Control, Page Load / Unload which will call first (Master page, content page, user control) New keyword ref in class The disadvantage of the Factory method webservice vs WCF SOA State Management Pagination on DB Level How to encrypt DB data, which library you have used Solid principle Design Patter How to implement Thread-safe Singleton Abstraction VS Virtual

 - Make a LWC that receive the recordID and display inside a lightning input form the sobject account as well display inside the lightning input form a LWC lightning input text that get the object name based on first result

 - Write a SOQL query that get user data based on the last user who view account object

 Design a system that keeps time synchronized across processes on remote machines using network messaging.

 What kind of data structure to use for a problem.

 Sample: if password is passed through a request body in https, is it protected

 Have you ever had a conflict with your team member. How did you resolve?

 Design and talk through a basic messaging architecture in response to requirements given by the interviewer.

 First part is multiples choices questions about http, thread , object and class(oop)

```
 STAR Questions, easy AWS questions
```

 If you have two deliverables that need to be met at one time, what will you do to complete both requests.

 design a sql query and with a minimum of t00

 fibonacci related question. window functions in postgres. database engine related questions. DB design question.

 Build a sudoku solver in 50 mins without using Google.

 Javascript basics like promises, callbacks, and async-await. React questions like class components, functional components, hooks

 What did you when you were aware you will not be able to meet the deadline?

 What is the difference between TCP and UDP?

 Self Introduction Are you Relocate You have any offer in your hand Call by reference and Call by value

 Basic OOP questions and some stack/queue based exercises

 Q1. Tell us about yourself. Q2. What are your strengths? Q3. What are your weaknesses? Q4. What is programming? Q5. What do you know about our company?

 I remember only some of my questions, very few. "Tell me about yourself" "What is primary key in SQL?" "Tell me about RDBMS"

 Select count(*) from table1, table2; here table1 has 25 rows and table2 has 50 rows.

```
 How many water balloons fit on a bus?
```

 Describe an interesting project you are working on.

 #1: Tell us a bit about yourself. #2: Why have you applied for this internship? #3: Why have you applied for an internship at our company? #4: Why do you want to work in this industry? #5: What are your strengths? #6: How do you prioritize your work?

```
 Binary Search, System Structures
```

 difference between put and patch, http status code, bundling, partial view, view body, adding default route

 Technical questions were focused on my resume: SQL, API, Object oriented concepts, Selenium exercise

 Implement a system to manage a parking lot. In a pseucode way. Think of the object oriented principles, and databases.

 What do You do when You receive a pull request from someone?

 What are the different types of EC2 instances based on their costs?

 1. Sort the array 2. Stair case problem - Dynamic Programming

 Stacks and Queues and the differences.

 Can you find the no of nodes in a Linked-List without traversing it?

 Solve a code problem about a maze and finding a path using Java or any other languages you are confident with

```
 Binary search tree types of stuff.
```

 Can you tell me some books about design patterns, not just teaching how to code stuff directly?

```
 Do you think you are a go-getter?
```

 - API design - Websockets , Message bus and pros / cons - PR reviews

 Had to build a basic full stack app within 4 hours.

 Why do you want to work at Prolucid? Standard Behavioral questions.. Where do you see yourself in 5 years?

 Multhreading, LC easy and medium problems, OOPs concept, design patterns

 Threads and garbage collector in depths

 1)reverse of array 2)What was your project ? 3)Preferred programming language

 What is retaining cycle, and how can one prevent it?

 What is the difference between unowned and weak?

 Dependency Injection, API verbs, Event Loops, WebApis. 2PC transaction

```
 who is your role model?
```

 Sorting question, string palindrome problem

```
 Write code for Reverse linked list.
```
```
 how about SDLC method and debugging
```

 Design the classes for an organism Prime numbers

 Explain the OOPs concept? Why multiple inheritance cant be achieved in java? Why overriding is not possible in constructor?

 eventloop, trigger, singleton pattern, memoization, authorization, authentication,lazy loading, Streams, Buffers, SPA, overloading vs overriding, generics, http methods, interceptor, middleware

 - Why Cambridge Intelligence? - Favourite programming languages? Why? - Design decisions related to your programming task - Lots of talk about past projects - what was it? what was learnt from it? what would you do differently? - Discussion around university courses - favourites? least favourites? tasks? teamwork?

```
 What's a binary search tree?
```

 Remove duplicate elements from array. Difference between overloading and overriding.

 What is the difference between Table and View in SQL?

```
 Experience with TDD
```

 MANUAL AND AUTOMATION Regression and retesting Bug life cycle

 How would you investigate a production system that is currently taking too long to process requests? Which monitoring tools would you use? Could you point the main differences between RabbitMQ and Kafka ?

 What is event loop and how does it work in setTimeOut

 Arrays Bst Hashmap Oops Multithreading

 BST- Merge two BST DP-Matrix Multiplication

 What is Sql indexer? Routing in MVC, http status codes

 BFS and inorder, preorder, postorder traversal

```
 NDA but basically, some DFS problems
```

 SOLID Principles CI/CD Pipelines Part work experience

 A very in depth question about Data Structures that no leet code prep could prepare you for. I believe the question was given that way to see how you think through problems

 Software engineering concepts and architecture

 How would you search for a specific email address in a list so that each key pressed reduced the list?

```
 What is a rest api
```

 Creating a CRUD (client manager) in a period of 2 hours

 The Lottery question - given a number N, write a class that allows a user to call getK and receive K different balls (with different numbers), chosen randomly from the relevant balls that are still in the system (not previously returned to customer). All numbers are unique, and should be from 1 to N.

 What are deadlocks What is polymorphism? Different types of polymorphism? In function overloading, how compiler knows which function to run? (Internal working) What are virtual functions. What is NAT? How https works? Asymmetric and symmetric encryption. Security devices at different layers of the network. What is arp poisioning? Most specific route in overlapping subnets. Design a load balancer in C++. How memset works Stack and heap in memory layout New and delete Malloc calloc and free Seperate linked list odd and even Templates in c++ Security at different layers of network VLAN ACL Agile Some behaviour questions

 array storage classes logical questions c programming questions

 Theory questions on golang. Coding problems related to go routines, channels. Basic networking questions. Rest api and gRpc.

 A short paper full of technical SQL questions

 how to install php? feature of html language.

 What is the latest version of laravel?

```
 A top K variation problem
```
```
 Linked lists, DS and A, etc
```

 Dependency injections Polymorphism Entity framework

 Database: sql unite, group by, SQL Common Table Expressions (CTE), inner join, outer join, and example of sql select find duplicates in a table.

 Experience and interest in writing high quality open source software.

 Build a MCQ website and send the screen recording of it.

 ACID property, JWT, Password hashing, HTTP, HTTPS, difference between GraphQL and REST, SQL queries, JS, NodeJS, 1 DSA question of DP.

 What do you know about dependency injection?

 I don't remember some questions, but here are a few which I remember. 1.Lifecycles on activity/fragment/views 2. Difference between val, const , and const val 3.MVVM 4. How would you have your data retained after the new launch 5. Architecture a new app based on requirements 6. Coroutine context 7. What is a lazy column in jetpack compose? 8. Three DS and algo problems(I don't remember the problems) 9. Kotlin scope functions 10. About my previous projects. 11. Toughest challenge faced by me? and more...

 Q: Are you familiar with JIRA Q: What is your development experience like etc. (fairly standard questions)

```
 What is Test driven design
```
```
 Q . Remove duplicate from array
```

 Binary search through an array, hash map questions, basic Data Structure and Algorithm problems

```
 1) Number of turns in a binary tree
```
```
 What are the stages in SDLC
```

 OOPs Conecpt Method Overloading and Overriding Primary and Foreign Key Java programs like prime number and reverse a string Create a table in SQL Insert a column in SQL

 * What is check point in SSIS ? * What is Clustered index?

 Describe an scenario which was challenging for you and how you did overcome it?

```
 easy leet code. BFS and DFS
```
```
 Linked tree , binary tree
```
```
 What is abstraction? Was is OOP?
```

 Refactor a badly written code, here is 400+ lines of requirements for you to understand how it should work

 "If a day on Planet A is 29 hours and a day on Planet B is 30 hours, what are the chances I was born on Planet A?"

 "What are the chances you have the same birthday as me?"

 "Imagine you had a 6-sided dice, and for each dot you get $1, what is the average money you'd make after X rolls?"

 Describe how would you create an API route

 Design a stack class which will return the most occurring number in the stack. If 2 numbers have the same count of occurrence then return the number which is at the top of stack. For this I was required to write the class with 2 methods push() & pop().

 Jane is taller than John, who is shorter?

 When did you f*ck up production ? And how did you solve it. explain O and D of SOLID

 Design parking lot with support for multi level parking using any language you want.

```
 Reverse a Doubly- Linked List?
```

 Design a WhatsApp System from scratch.

 Singletons Design patterns Oops concepts

 They request to create a small application with Laravel and Angular for create, update, read and delete data from MySql or PHP MyAdmin.

```
 What is threading in programming?
```

 Q: Tell me about a time where you didn’t deliver on something, and what was your reaction?

```
 Do you have experience in Docker?
```

 Cerate a docker container and write the config file

 -> Time complexities of various sorting algorithms?

```
 -> Explain the working of Merge Sort?
```

 -> Explain how grid system works in Bootstrap?

```
 -> Define how 'JOIN' works in SQL?
```

 -Where do you see yourself in 5 years? -What is a relational database? -What are the 4 pillars of OOP?

```
 Do you have experience with UDP/TCP
```
```
 What is SSR (Server Side Rendering)?
```

 the difference between the stack and heap

 What is polymorphism? What is inheritance

```
 Define the four pillars in OOPS.
```
```
 Why REST ? Why do we need REST?
```
```
 Oops concept - Abstract and Interface
```

 System Design: SQL vs. No-SQL databases, how to scale a database, UUID's, interaction between backend components, database sharding, etc. Coding: recursion, data structures, complexity, basic code optimization, etc. Cultural fit and managerial: dealing with low performers, managing style, description of my background, reasons to be a manager, etc.

 Group by in SQL?, How to create joins in SQL?

```
 what is buffer? what is latch?
```

 Given a sudoku board, return if the sudoku board is solved correctly

```
string manipulation and dictionary.
```

In my case I had to build a CRUD API. Not difficult but it takes time as you have to imagine a PRD setting (so having tests, proper abstraction, proper documentation on how to build etc...).

Write a program that can reverse a list Do a code review - though this is very subjective as it was mainly about their personal likes/dislikes\

```
Basic DSA, SQL and OOP questions.
```

System related and opinions on current system.

Codility, basic array manipulation questions. Technical interview. Doing replace templating on a string, which recieve a dictionary of keywords and values to replace. It was simple and something they might already did in one of their products.

what is string? what is polymorphism? coding question of maximum sum array?

```
Are you familiar with TypeScript
```

Oops concept, database questions more related to joins

Explain oop concept, sql, er diagram Why you are using HTML5 in your projects. Your experience working with sql, excel? Write code for Reverse linked list. Fully on Java OOPs concepts only. Design the classes for an organism Prime numbers Explain the OOPs concept? Why multiple inheritance cant be achieved in java? Why overriding is not possible in constructor? Any trainings attended? What projects you have worked on? 2.Improve given code time complexity 3.SQL query eventloop, trigger, singleton pattern, memoization, authorization, authentication,lazy loading, Streams, Buffers, SPA, overloading vs overriding, generics, http methods, interceptor, middleware What is the MVC model what is java and why java is oop ? Write a code for a Given Roman numeral to convert it into an integer. Eg. Convert XXI or IX to it's equivalent integer number.

Why Cambridge Intelligence? - Favourite programming languages? Why? - Design decisions related to your programming task - Lots of talk about past projects - what was it? what was learnt from it? what would you do differently? - Discussion around university courses - favourites? least favourites? tasks? teamwork? What's a binary search tree? Remove duplicate elements from array. Difference between overloading and overriding. What is the difference between Table and View in SQL? Build a react native registration screen with form validation Core Java spring boot hibernate SQL joins & logical scenario based questions, PBI detailed interview MANUAL AND AUTOMATION Regression and retesting Bug life cycle

Find the Longest palindromic subsequence. Basic Data structures Basic algorithms and puzzles Reverse a string according to size of words string manipulation and dictionary. In my case I had to build a CRUD API. Not difficult but it takes time as you have to imagine a PRD setting (so having tests, proper abstraction, proper documentation on how to build etc...). Different types of data structures What prompted you to apply to Core specifically? Spring boot annotations and corejava 30 mins of behavioral questions using STAR method. Questions on Java, OOPs concept, design concepts (very theoritical), SQL questions,questions on previous experience. No coding questions. SQL questions -Joins,sub queries, etl and business.

Describe your experience. - Describe a person/product that inspires you. - What is your expected salary? Basic DSA, SQL and OOP questions. Print a matrix in spiral order? simple question on db design some short questions on Python leetcode-style questions on whatever language live-coding with React and Nodejs Codility, basic array manipulation questions. Doing replace templating on a string, recieve a dictionary of keywords and values to replace. call by reference struct polymorphism About AEM, questions about HTL, clientlibs project structure and authoring DSA OOP DBMS All standard easy level questions. Two coding questions to be solved in 10 minutes each. what is string? what is polymorphism? coding question of maximum sum array? Are you familiar with TypeScript Java, Scala, Modern Databases, Elastic Search, System Design Given a string of parentheses tell if each one of them is properly closed, you have 3 types of parentheses '(, [, {' Given two string tell if they contain the same characters and are of equal length (there was a word for this) All question about SQL and kettle(job, transformation) OOPS and basics and easy level coding questions Star Pattern program , Armstrong number, palindrome program write a program, given a range, x - y, and find the number of integers that is evenly divisible by 7 but not divisible by 3. Write a polyfill for promise Technical (domain based), questions from DS/DSA, programming languages, OOPS write a program to find zeros between Binary number All questions from profile and sharing rules, roles Lightning bundles Lightning aura events and difference between events. Lightning data services, what parameters to set controller Difference between controller and helper Soql and fields to display according to user permission Simple python programs on inheritance concepts and basic SQL queries searching, design stack,linked list,heaps,proj discussion Explain one of your past roles or project what are the technologies used in angular? OOPS concepts Describe your projects html elements how to implement the code in browser Test duration 90 mins No. of questions 4 questions "Questions Feel free to choose your preferred programming language from the list of languages supported for each question. There are 4 questions that are part of this test: Question Indexes Question Types Q1 - Q4 Coding Questions 21 languages allowed: c, clojure, cpp, cpp14, csharp, erlang, go, haskell, java, java8, javascript, julia, kotlin, lua, objectivec, perl, php, r, ruby, scala, swift" 1. Circular Printer 2. Balanced Array 3. Whole Minute Dilemma 4. Astronomy Board Game They asked me to stand in front of all developers and talk about myself What culture add can I bring? What is your professional experience? First, he asked me to brief about yourself and there was a long discussion about my projects and their applications. As I mentioned the github link for all the projects, he visited my profile and checked my repositories and asked about github and the tools I have used. Detect the loop in the linked list and then find the point from where the loop started. 1 string q, 1 dp, 1 array Many questions about my current position, mindset and culture
In depth python knowledge; mutability, immutability, syntax, lists/set/tuple difference, etc. - Flatten nested nested list. more about oops and .net What is difference between Interface and Abstract class Languages, programming languages, or programming tools learnt and using Data structures and System design interview. Java, react, development, API , and about yourself How will you handle the real time issues faced Something related to Binary Seach or Two Pointer Laravel basic question php basic question They asked questions based on resume. General hiring manager questions. System design question commonly asked. Non lc coding questions testing real coding experience, need to keep answering out loud and come up with test cases. One more on the caching side similar to redis and other question more api invocation/real time implementation. On List cars : Use LINQ, Find cheapest car, most expensive car, average price, group by brand name and return a dictionary. Reverse Linked list, binary tree traversal Just read basics on interview preparation kit Deep dive onto rails and databases How would you design a system that had lot's of transactions which needed to be reflected on many clients as realtime as possible? Hacker Rank, Provide how you relate and can obtain the Amazon Leadership Principles to your life and role here. Customer Obsession. Ownership. Invent and Simplify. Are Right, A Lot. Learn and Be Curious. Hire and Develop the Best. Insist on the Highest Standards. Think Big. Intuit Values (Typical Behavioral Questions) Graph traversing problem Shortest path from leaf node to another leaf node in a binary tree. -SQL query, join, grouping, aggragetion 2 algorithm questions Q: Sort a linked list Q: Return ranges between an input list of ranges How did you solve a hard problem in team collaboration? Give an example. What do you know about Service Oriented Architecture vs Microservices? What do you know about relational database? And NoSQL?

Design Interview: Design a game leaderboard with top K results. Assume there is an online game that's taking place, and you need to only build the dashboard that everyone is viewing. 2. Behavioral: They try to gauge your level here - so try to aim for an L5 - or explicitly state so. 3. Merge k sorted lists 4. Schedule matches between two sets of players where no two players have a re-match (play only once against each other) Develop a full stack app in node, react, cypress and ts, docker, ci/cd and database Tell me how you would design a food delivery app from start to finish. Write an app to produce a report Different question regarding job position What are Keys and types of Keys in SQL? Mostly based on what you had mentioned in your resume Question on REST operations PUT Vs POST How to pass params in path variable & also about query param How did you handle conflict of interest with your colleague Why REST? Typical leetcode medium/hard, ie. bfs/dfs graph searching to find maximums/minimums, and object oriented stuff. Doing blind top 75 questions prepared me for the difficulty of this interviewing process. Can you explain to me how to do matrix multiplication? Can you explain how you would implement matrix multiplication in a language of your choice? What's a volatile variable? What's a const? What's a const volatile? Given a number, find the number of set bits They asked me to code a card game. A reverse engineered Caesar Cipher with twists on hacker rank. they asked about alog, DS and industry best practices Tell me about a time when you took a big risk that did not work out Eg 1: Input: a1b10 Output: abbbbbbbbbb Eg: 2: Input: b3c6d15 Output: bbbccccccddddddddddddddd The number varies from 1 to 99. different between HTTP and HTTPS Java oops questions, polymorphism, different types of polymorphism OOPS concepts, SQL, One programming language, Projects you did (prepare your resume) 2nd round Full Profile based analysis and few technical questions she asked about program languages that i have experience with them. remove duplicates from am array and sort it. Importance of testing in the development cycle compared to analysis. OOP related questions, the general stuff that you would expect from a junior/medior position interview. Set up a linked list class and find if there are any duplicates Linux, SQL, OOP, Primary key. remove duplicates from array write a query joining two tables probability question bases on bayes therom traverse the array and list the duplicates OOPS concepts describe your project Linked-list question (aced it) Find all 2x2 sub-arrays inside a larger array (didn't get to that, but I'm sure it's on Leetcode somewhere). Post-word: I got approached by Amazon twice since then. No thanks! How could you help Lisk achieve its mission? What are custodians? What are market makers? HTML, CSS, Js regarding styling and js built in functions About project they asked me what was my contribution Build a ledger from an predefined interface. Design a web crawler. A single computer programming question based on denomination of currency General behavioural question you are better off rehearsing off after research from google. Simple technical part except for the description above. Write a program an array Sorting elements in array Query on DBMS How do you communicate to the client if he doesn't understand a problem that you are raising? Take-home assignment : display restaurants, delete and add one using Algolia search API. What is OPP's concept? What is Object? How you can handle broken links? What is the order of constructing and deconstructing objects in cpp? Hooks, closures Are you a hardworking person ? Algorithms and Software Architecture in some cases of e-commerce problems Coding Question,Basics of Python and Django,MySQL Question Coding, OOPS Concept, Basics of Python Difference between List & Tuple Start with core java like , oop concepts, Collection framework, Java8 features SpringBoot annotation like @RestController, @Autowired @Bean @Qualifier and more. Basic OOPS concepts 1st round - OOPS, pointers, OS, DBMS, Logical Reasoning, output-based. 2nd Round - Linked List detect delete and reverse a string- both iterative and recursive—deep dive into Cpp concepts like friends function, typecasting, reference vs value, smart pointer, etc. The interviewer asked me to introduce myself. Asked me what language do i know. Asked me about java and type code for matrices program. Then moved onto data structures asked about heapsort What do you know about Apache Cassandra and NoSQL? basic react interview questions and javascript basics What are you previous projects? What data structure is used in API? Write a Trigger on roll-up summary write a Trigger to restrict entering the date in the contact which is having lessthan the minimum_date and greater than maximum_date in related account record Two DSA questions 1. for loop question 2. Flattening array without using inbuilt function. Q: Mysql index. the difference of Innodb and MyISAM Q: data structure of redis and their implement Describe the basic high-level architecture of a messaging application like WhatsApp & how will I implement it. How to select elements from tree?. Q.1) Give scenario where we can use abstract class and interface Q. Creating polyfills for some methods, JavaScript variables, and their inner workings, sorting algorithm, and Advanced JavaScript concepts. Build a factory floor diagram to move cars through an assembly line Which technologies I’ve worked with and my education background
Design a DB API 2. Tic tac toe game on react 3. Query DB make joins and group data and count unique values in columns 4. Basic DS/Algo questions Some graph questions, leetcode hard questions were practical and and to the point. you have to find out an appropriate solution to them in an hour First assessment: 1 sql, 2 algorithm, 1 javascript with html What are the three ways to reduce page load time? Related to database schemas and data analysis. What is object oriented programming What is hooks in react? python oops concept. Django ORM, all model and structure of django About Classes,Static,some Asynchronous Apex questions and Triggers The Geofencing app that you have worked on - Unit Test - SOLID - Implement a new architecture that they want on the spot Why apply with Setel? (They ask tricky questions here, please avoid answering anything related to better package, benefits, or salary, or else they will hunt you down.)
Tell me about yourself 2. Show me your project and explain 3. What is Semantic UI? 4. What is blockchain. NFT? How do you keep up with technologies.
Tell me about yourself 2. Show some of your projects and explain different parts of it 3. What is semantic UI 4. What is blockchain, nft Multi threading. Why are Locks used? Async and Await? Started from oops and the difficulty level increases as the interview progress Singleton pattern with example. What is CTE? what are SQL views? How is a view different from stored procedure and tables? Can views update data? Can views have indexes? What kind of data view reads? How to increase WordPress website speed and optimize website performance? WordPress basic post types and Database related questions. Have you ever contributed to WordPress.org? How to protect WordPress websites from Hackers? What is polymorphism in java? Generic soft-skill/teamworking questions, "What is the difference between a linked list and an array", and the technical interview consisted of dissecting a specific project of mine that was listed on my resume. 2 String questions in the OA. 1 was easy. Other one was related to KMP algorithm. 1 heap question in interview Atlassian wants to build a simple scheduling system that can execute one-off HTTP requests at a specified time. Consumers are internal Atlassian services only, and they may use this system to schedule requests to be executed in the future. For example: A consumer can schedule a request to https://testservice.com/api/items/_create to be executed on upcoming Sunday at 1am. So on upcoming Sunday at 1am the scheduling system must execute the HTTP request. Requirements: - Provide an interface for scheduling HTTP requests at a specified time. - Execute an HTTP request at specified time. - Initial release expects 10 scheduling requests per minute. how to write trigger with map example show me how to write a trigger on any object show me how to see field history on object show me how to create class, write soql query show me how to add fields on page layout Share your screen and show me how to add roll up summary field Show me how to create visual force page Show me how to assign case assignment rule, lead assignment rule Apex Trigger involving parent - child relationship - Update a field on parent object which will contain average of all numeric values contained in some field of child object records. Salesforce CPQ Product Rules and Price Rules along with multiple scenerios.
Past Experience 2. Leetcode Medium and Hard (LinkedList) write PHP API call client with page token similar to google, also asked me to Write and API server and generate paging for the data set similar to google. Hash table, aggregate a list of bank transactions so that each bank at most has 1 transaction with every other bank What is singleton design pattern Design a pizza shop using oops concept and code according to their requirements. There were 2 coding questions. We spent 30 minutes on the first question, and the rest of the time on another question which I didn't finish. Leetcode
What is real life example of binary search ? 2. What is real life example of lambda functions in python ? 3. Why you choose python over java ? They also asked about my knowledge of polymorphism 1.tell me about yourself 2.oops concept 3.method overloading & Method overriding 4.singleton pattern in java 5.difference between list and map 6.exception handling in java 7.table creation in mysql 8.how will manage multiple registration in mysql 9.explain about your projects Appels REST difference http et https requete SQL sur un exercice (Left join) dis moi un peu sur selenium (comment instancier le driver , scroll, ...) les statuts de réponses Rest (404,400,...) Postman et variables Test design Technical: Custom binding Extension functions String manipulation How to run 5 API calls and once all api calls are completes then proceed Questions around suspend functions and coroutine cancel. Data classes What are Promises? what are callbacks? Tell me about binary Search? Implement a linked list in which you can add, delete and view middle element in O(1) time How did you fare in high school mathematics, physical sciences and computing? Which were strengths and which were most enjoyable? How did you rank, competitively, in them? Software design Pattern . what is Singleton and observer design pattern Ds algo: create a stack with o(1) min value Lld: Design a photo download system in ios and swift Create an Item listing application on xcoxd Ds algo: find if paranthesis are balanced How is Python language different from c++. Directive, dependency injection ,Data binding,Observable, Angular features,explain the directives Couple questions about computer science and general theory, and other questions about more concrete topics like advantages and disadvantages of different programming languages and their uses. When do you use the `mutable' keyword? What is hoisting in JS? What is the difference between a stack and a heap? Technical question pertaining to project. Acid Property and how does it differ for NoSQL Difference between TCP & IP Explain OSI Layer Questions on Sorting techniques What happens in background during a http request Advantage of tail over non tail recursion What is tail recursion? Q: WAP to print star pattern Q: WAP to sort list of integers without using inbuilt functions i.e. any sorting technique Q: Other spring boot & java generic questions Questions about Data Architecture and Engineering. Concepts of handling data, Data Modeling and ETL Questions. 3 Hands on coding question. Did them in SQL. Given a list of file paths, output a formatted directory structure
Difference between function expressions and function declaration. 2. What is hoisting? 3. How would you update a database with immutable records? About core Java, Microservices, SQL, Collections What is most difficult enhancement that you have done in the previous project What's your favourite stack (frontend/backend) and why MC round- design a music management system(Very simple) HLD-LLD- A notification management system DSA-Array of songs, play all songs in a random fashion infinite(or M ) number of times. Condition all songs in the current array to be played before starting the next cycle. Multithreading- Producer consumer problem, the interviewer will ask a lot of follow up questions, wants the most optimised way(CPU should be blocked only for producer or consumer thread at a particular time) Design pattern- You will be given a problem where you need to solve the situation via the correct design pattern(Very important) Database- Sharding, Indexing etc Q: Write a program to find factorial of a number using recursion. Q: Wap to reverse a string using recursion. Q : Write a SQL query to find 3rd highest salary . Q: Install docker, pull an image, run that image and hit a given URL using email, and API-key in headers to get next step question.
SQL 2. Abstraction 3. Multiple Choice 4. Problem to Solve Longest Substring Without Repeating Characters
Difference between function expressions and function declaration. 2. What is hoisting? 3. How would you update a database with immutable records? Practical exam was given - It was a PHP test. Currency rate exchange system where actual rates are provided by a third party. About core Java, Microservices, SQL, Collections Q: Write a program to find factorial of a number using recursion. Q: Wap to reverse a string using recursion. Q : Write a SQL query to find 3rd highest salary . automation and Functional Testing API testing and Database testing Difference between WCF and API What are some Higher Order Array Methods and what they do ? What's a class in Javascript ? They asked me about callback, promisses, hooks , usestate 1.How to use generic? 2.Explain the process of creating a register page 3.Exceptation handling and current project discussion Questions for the interview was : 1) Oops concepts in python 2) Django Framework workflow 3) Write a program of fibonacci series 4) Sql queries 1) Oops concepts in python 2) Django Framework workflow 3) Write a program of fibonnice series 4) Sql queries
Write a code to reverse a string 2. Opened Amazon.in and asked me to write XPath for elements on that page. 3.Difference between Abstract and Interface The technical interview consisted of several themes - CPU bound vs I/O bound - async/multithreading in Python and effects of GIL - system design - slow HTTP attack on a reverse proxy
Bubble sort coding question using functions 2. Write programming logic to store your name using character pointer 3. Basic questions on data structures Virtual DOM, Component Life Cycle, some JS questions, HackerRank calculator with testing I have to do a python program for print a prime number small project to develop api in go with mongodb. Architecture, Database, CS fundamentals, Working experiences, and other... do you work on integration? oops concept SQL queries CRUD operations set method why $ used Explain the types of joins in SQL joints Two cooks have a kitchen and require 30 minutes to bake a food what is the result? Q: Are you interested in NFTs? Q: What experience do you have with .Net? Q: Experience with Go or C++? What is inheritance? What is the way of inheriting variable of one class to any other class? What is Polymorphism? Given 2 sorted arrays, merge them together, eliminate duplicates, and sort the result. Find K Pairs with Smallest Sums, Intersection of Two Arrays, Longest Increasing Subsequence, Longest Substring Without Repeating Characters, etc. Solid principals ? Design patterns? DDD concepts? Message brokers ? Used a third party coding test site, two questions and 1 hour to solve them. Closures, Scope, Box Model, REST What is the Observer Pattern Q1. What technologies you have worked on? Code for frequency of elements in the list min and max value from the list basic data types,oops concept question MySQL based questions Did u have any experience developing Micro Services app? Explain spring MVC flow and architecture Whats was your biggest achievement ? What are SOLID principles, and design patterns? Define and give an example of the Singelton pattern. Abstract classes and interfaces. LLD for a learning platform. covered some SQL concepts, Designs Patterns, Talked about your current role - are you familiar with Kanban - are you up-to-date with recent technologies? some behavioral questions based on scenarios. What is the role play for seek() and Tell() Red black tree map implementation. Did u have any experience developing Micro Services app? covered some SQL concepts, Designs Patterns, Talked about your current role - are you familiar with Kanban - are you up-to-date with recent technologies? some behavioral questions based on scenarios.
What are the primitive data types in java? 2. What are the collections in java? 3. What does the TreeSet do and how different it is from the TreeMap. 4. Difference between list and set? Explain about Binary searching in Data structures Polymorphism, computer basics , joins,structures,class, hashes. designing APIs, linked list implementation, SQL concepts, OOPS questions, some deep IAM questions Linked List ,Graph,Tree, Bit Manipulation, Array, Strings oops concept, dbms concept, Project discussion, ontime performance and many more.. In short the process was tough and it should not be taken litely. They will judge in every minute for whatever the single word you had spoken. So maintain the well communication Micro services architecture Traditional C# questions with SQL queries number of set bits in a number SQL question: Triggers,SP and Functions SSIS: Transformations and scenario-based question What do you know about Functional and Class components. 3 coding questions in Codility. SOLID. Design Pattern. Where did you use them. Algorithms, Design patterns, Networking, Algorithm complexity What would a REST API for a bookshelf look like? Common data structure and design questions Basic OOPs questions and Mysql query What is overloading and overwriting? What is the difference between a Super Class and a Sub Class? Basic Testing Concepts on Technical Round. Agile, API testing, Functional Testing, and scenario-related questions. Q: Explain what a hashmap is and the implementation. Q: What is the difference between a set and a list? Q: Design a computational model of an elevator. Q: Analysing Java code and explaining bugs, or where efficiency could be improved. It's been several weeks so I may not remember everything, but it's the same MS Paint clone that others have shared here. No user interface is required, just a few functions such as paint and undo. You should be able to undo multiple times. The input is an array of strings which represent individual pixels' colors, and the output is the new array of strings after the change (paint or undo) has been made. Q: What is polymorphism? Q: What does it mean to overload a method, and why would you need to do it? Q: What is your experience with working in teams? Something related to architectures and git Round 1: 1. Merge intervals 2. Palindromic linked list Round 2: This was supposed to be a LLD round. The hiring manager began my interview questioning my job switches in a sarcastic way. I felt very uncomfortable at this point and i could sense she had made her mind to reject me for my job hops and did the interview for namesake. She just threw lots of theoretical questions to me like difference between POST and PUT, monolithic vs microservice, docker etc. to pass time of 1 hr. Very disappointed with the process . Ho do you manage your tasks? What computer language you like to work on?
How to design a Applicant Tracking System? 2. How to design a messaging system with different failover scenarios. 3. Optimize factorial program There were few more designing questions which I don't remember but those were not too hard. Can you explain yourself please? What motivates you to get up every day/do this kind of science? Why did you choose software engineering? Q: Have you used ? First non-repeating char (in single pass) Merge two sorted arrays Merge k sorted arrays Is a given tree is BST Design a half way Queue in optimized way. What is method over loading and methods overriding? Qual a diferença entre REST e RESTFull ? Write the fibonacci sequence using only one loop? Is smart work better than hard work ? Hard Work Vs Smart Work CI/CD REST API MVC and other backend basics ... How would you rate your lang skills Why are you leaving your previous company To find permutations for non intersecting chords using n points on a circle. Question to to detect and remove cycle from linked list. Resume round 2 Question rather than being focused on the web core concept and developer resume based , were more focused on the devops like CI/ CD pipelines , docker and Jenkins. How to optimize ur CI/ CD pipelines ina project Round 1 - DSA and problem solving Round 2 - Java and OOPS fundamentals Jenkins installation method Agent installation method. Longest possible sequence in the given array Q: Describe a time you overcame a difficulty
Where do you see yourself in next five years? Is there something in your career that made you feel like it was impossible to move forward? How would you design a data lake for a customer using AWS. It was a cloud architecture question. Questions on Java and rest webservices. Questions based on experiences. What is the 8th power of 2 Binary Tree search MySQL y OOP, entre otras . Design a service which pulls IP Blocklist data from GitHub and expose an endpoint which returns Blocklists an IP address is contained in. was asked to design a rate limiter difference between a list and array Cognitive Ability Test, similar to IQ test. Has questions about pattern recognition, grammar, simple maths and more. System Design Q: Why did you use this design? Q: What is the exact scope of the design? HR Q: How can you work smoothly with a new team-member? Q: How can you make a bug-free code? What kind of effort does the development process make it bug-free code? Q: Amazon Interview Style question. Let me~ *Every Interview Session contain. 5min introduce myself time. what is the runtime of the following code? what is the difference between polymorphism and inheritance? Why did you choose mobile app development? why did you choose Alarm.com what is multithreading in os What was your relevant experience What was the most complicated project you've ever worked on? Build binary search tree (including nodes), build program to make every third word uppcase
Code a function from javascript _loadash library 2. Pseudocode for a parser 3. Graph Problem 4. Design a react component What are your interests in software development? why do you think you will make a good fit? Have you programmed with TCP/IP protocols before? Create 9 boxes and add green background colour when clicked Design patterns and implement one in the interview and explain why. Simple programming question for pair programming, system design, examples of ways you have demonstrated leadership in the past With a very simple incrementing variable, what happens when we add threads to the program? How can we ensure things work correctly? After being shown any number of naive approaches to locking, which ones would work? Implement the backend for a Wordle clone Design the road incident reporting feature of Waze. If Martians existed and had to request data from Earth, how could we reduce latency of requests. If we still see high or slightly higher p99s, what might be the cause? Implement an algorithm to find the square root of a number. How do you make it more efficient. Given a list of words, return groupings of all palindromes. Design a dictionary API and design a race circuit leaderboard. Domain knowledge Make a triangle pattern given below. * ** *** **** Q: Tell us about your experience with the SDLC
Bubble Sorting 2. Hibernate About OOPS concepts and PHP basic
Event Loop in node js 2. How do APIs interact from backend to frontend. 3. Question related to the technology stack I have mentioned in my resume. get array of digit and change it to integer then sum reverse digit Factorial program in both first class and with recursion. Introduce yourself. College projects? How you used your technical knowledge in real world? OOps concepts. How do you implement your error handling? Take home test - racing robots. Multi-threaded OO design project. Print from 0 to n without using any type of loop and also write a function to print up to n and then back down to 0 (use recursion). Looking at a code example of what was supposed to be an immutable class but having to explain why some of the internals could still be changed after construction due to object references and then saying how to fix it. implement logic for tick-tac-toe and phonebook Q. Oops Concepts. Q. Does java supports multiple inheritance ? If yes then how? Q. Interface related output programming questions. Q.is it possible to have same methods on 2 different interfaces? Q. Internal working of Hashmap. Q.Explain any Sorting Technique you know. Q. Stack and Queue Q. We have a binary number 1011 stored in a linked list, and we want its equivalent decimal in output(11).Write a program for it. Q.We have an array of numbers, write a program which returns the non repetitive number. Q.write a function to check if a string is a palindrome. Q.Android LifeCycle Q. Android Application Components. Q.Define a scenario where onCreate is called but on resume not called. Q. Define a scenario where onStop called but onPause not called. Q.what are fragments Q.MVVM Q.How can we call the activity methods in fragments Q. What are Kotlin Extensions?Why do we need them? Q. What are data classes in kotlin? Q. What is companion object in kotlin?How can we use it in our java code? If I prefer backend or frontend Q: What was the reason you got into tech? Problem about hash map data structure. So tell me What is SQL? Common intersection point of Linked List Basic programming question. And sql queries. Dive deeper into my previous intern experience. Describe your project. Favorite core subjects. What would you do if you had two tight deadlines and weren't able to meet them. How to design a sample system. How do you communicate with the team in different situations. Design a deck of cards, leadership principles, system design of a car dealership, DFS question What are the differences between function and procedure in sql Coin change binary tree (LC Hard) Here is a link to an empty white board. Without any reference, write out the data structure for perfectly mapping a 3 dimensional object suspended in space. Give the backend engineers the data structure you require to render a suspended 3 dimensional object. The object dimensions are assumed to be the same. Oh yeah, and the object dimensions are assumed to always change. Assume they know everything. What would you write as a data structure to fill them in on what they don't know? Write this out on the whiteboard with no reference to anything I am talking about. Solidity try catch syntax and the outcome Explain Java ConcurrentHashMap in depth, the implementation, volatile in JVM Whats the different between storage, memory and calldata Multiple Inheritance in Solidity, the expected outcome What is Minimum viable proxy eip1167 Call vs Delegate call, and the use case Something related to hashing and maps How would you improve a technical solution
Parse a bizarre string 2. Parse a even more bizarre string Tell me about a time you had conflict with another person and how you resolved it. Based on shell scripting and few ds, dont really remember the questions but it was basic. Describe your experience with SASS. Every word on your resume becomes a question Gave a case study and was asked to present it using my experiences and learning. What is Oriented Object Programming? Python basics problem, django workflow,ORM Python, POO, .NET Json Aptitudes how to implement a command Tree Linkedlist Design Array Strings Have you worked with any databases such as Django or flask. Some Api library call and fetching data Q: What is polymorphism (as it relates to object-oriented programming)? Reasons for entering the field A dynamic programming question. Graph theory The phone call was with the CTO and was pretty conversational Routing, Layer2/3 questions and find no. of hosts/subnets from Ip and mask What are you looking for in you new job? What are the company's values? They send a test case which you need to hand in your solution in 4 hours. the expectation is to solve the algorithm in an efficient way. write SQL query for given scenario DSA Q: Find the shortest distance to a character in a string Q: Find the longest palindromic substring of a string. Q: Find the longest palindromic substring of a string. A data structure question what is event flow? Basic oops concepts questions and few scenarios based questions. Main question: try to model Amazon online store by uaing Data structures, DB, search and index functionality - how will you find an item by a category, price, etc. Warm up question about an array from cracking the coding interview (literally) How to iterate through a binary tree How do you measure your success on a daily basis? how to add two no without add operator ? Tell me about a problem you encountered when working on your project and how you solved it. Tell me about one challenge you faced/ your biggest achievement What is the difference between optimistic and pessimistic locking? What is the difference between git rebase and git merge? What is a variable? What is an object? Which is your favourite programing language and why you choose it? What relative experience do you have? Is it possible to call batch from batch Where do you live? Do You know to drive? Tell me about yourself. describe what the routing does in an express server. what is a waterfall working approach vs agile. what are the benefits using the stack that you chose. is mongoose a db? what is the difference between mongodb and sql? what are the benefits of these? what is a RESTful API? what is a monolith app? what is a micro service? What management style do you prefer to work under?Java, oops, microservices, situation based questions 1.Difference between DELETE and TRUNCATE 2.cat command usage 3.Command to find hidden files in unix 4.Remove white spaces in a file in unix 5.SQL query to find 5th highest salary 1.What happens if we pass null values to rollup and scan components? 2.Replicate usage 3.Difference between replicate and broadcast 4.Left Outer Join 5.Dedup sort in abinitio Which component breaks component parallelism Explain what are different types of parallelism Difference between output index and output indexes Difference between Partition by key and partition by round robin I has an assessment to develop over a week and a live white board challenge. What is the most interesting technological development Which methodology you are following in your organization? db migrations, testing, architecture design, etc etc what is Concurrent hashmap collection framework one coding question on array What do you know about The Composable Architecture? What subjects I studied. What projects I developed. What do you feel about TDD and do you like writting Unit tests for your code? Technical related concepts and aws realted concepts Fetch from fake api and send errors Basic questions related to the domain knowledge Apart from the personal questions that are asked to know me better, there were some cognitive questions to understand the way I think. Leetcode-like interview questions. You can choose a preferred programming language. What is the best possible consistency of a development team you could think of? Patterns and some examples . Palindrome Weighted multilevel graph questions with implementation using dynamic programming How would you implement scanf and printf, if you are part of a team that is developing a new language. In my case as I was giving an interview for a full stack developer. They asked all stack questions (JavaScript, C#, and SQL). Also, they check data structure and algorithm

Designing Questions (design patterns, oop) - some Database related questions (indexing..etc) - JS coding challenge - Microservices questions C++ ,C,QS,Linked list like reverse a linked,implement using stack, questions from array like 2nd largest element,Database(simple ones),OS,questions on projects too. The Questions of programming are basic,they just check your concepts and give you time to think during the interview Coding questions 1)reverse string questions of any kind SQL Queries , Python OOPs, Big data basic, Project What is the difference between a list and a tuple in python? How to reverse a linked list System design for an app System design in a virtual whiteboard. Max sum without adjacent elements About my previous project and questions from SQL and JAVA What do you do when you get disappointed? Q; asked questions based on my experience and projects Assignment questions: 1. Creating a python API for bulletin system 2. Creating a CI/CD pipeline in a docker environment and a celery task on python for message queue systems. Culture fit and basic javascript questions. What are the responsibilites of the Operating system Two sum, system lock, bit manipulation

Stack/queue problems on leetcode 2) java dependency injection 3) java garbage collection How do you design a queue based logging system. How to use Polymorphism and Inheritance to make the code runnable? How to add a method to the function without modifying the original class?

What is difference between comparator and comparable 2. Explain this statement System.out:: println 3. How's d you filter out elements using steams? 4. What are new features of Java 8 What would you do if you hit a dead-end? First codesignal round was a standard OA, the second one involved interacting with a codebase and making REST API calls What was your greatest accomplishment in high school? How do you construct a promise from scratch? why you choose laravel for backend? What are different types of casting? what is framework , debugging and based on the language you know, questions are framed
DBMS 2. Javascript 3. Project Discussion Model write up and essay How can you handle unwanted situations in your team? what are three good and bad things your friends would say about you Hashmap working what is AWS EC2 Project related questions and cv based
Explain Agile 2. what is Spike 3. What is difference between SOAP & REST API 4. What is Regression Testing OA coding questions: delete an item in a Linked list air invaders counting bits creating a binary search tree How do you initialize pages in Page Object Model? Some String and HashMap based Java coding challenges.. Refer easy sections of LeetCode.com Questions on different types of API request headers like what kind of response is expected, and what is security tag talking about? How do you perform API testing in your project? What is the REST API? How the HashMap is implemented? Q : What is the output of the following code? #include <stdio.h> int main() { int x=5; if(x==5){ if(x==5)break; printf(“Hello”); } printf(“Hi”); } Reverse a string, read from file Question on stack and queues. Linked list, hash map, data structures What was your biggest failure? Quick sort, priority queue, sweep line, sliding window Reverse an array except for the beginning and end Real Examples with Psuedo code Merge Sort, quick Sort, DSA

Java from basics to advanced concepts with programs. - Data Structures - Multi threading - Spring Boot Basics and Rest API with sceneries given to write API Tell me about yourself, my strength and weakness Salary expectations How many types of array are there in PHP? What are the ways to define a constant in PHP? What data did you use to make your decisions on the project? What is 1 thing you would like to learn more about, and possibly talk about in a meeting How would you design an app and database for a Vet Office? start from a small scale system and grow to large scale system few SQL scenario basic Talend audit n error handling scd type warehouse questions

quick questions. around OS, network, databases. 2. Implement delayed scheduler 3.top k posts trending on Linkedin. Inquired about my developer background. Who are you as a person? What ambitions do you have? Is javascript synchronous or asynchronous? Have you ever fired anyone? Follow up questions. Have you ever promoted anyone? Follow up questions. String manipulation coding round. How would you choose a leader for your team? Q. How to build binary tree in sorted. C questions, microcontrollers, last experience Automate the login process using your local env. Self introduction, Former working experience. Coding challenge Oops concept, polymorphism, abstraction, join How to solve some SQL Problems Automate the login page, use your local environment How to reverse a binary tree.
Java Design Pattern 2. Java Streams API Implement a function to tell if a graph is bipartite. Implement an image convolution operator. Binary tree search modification question Lifecycle method, Pure Component, Hooks concepts, Es6 concepts One simple for example: difference between tuples and lists in python. They asked me to design database structure for Charity funding application ? How MVC arquitecture is organized? Write a Depth First Search Function Framework knowledge and Core PHP Is javascript synchronous or asynchronous? Q. How to build binary tree in sorted. Automate the login process using your local env. Oops concept, polymorphism, abstraction, join How to solve some SQL Problems How to reverse a binary tree.
Java Design Pattern 2. Java Streams API Binary tree search modification question Lifecycle method, Pure Component, Hooks concepts, Es6 concepts Pattern star and number type How MVC arquitecture is organized? Framework knowledge and Core PHP Coding design pretty much standard stuff 1: Code up a web crawler. 2: OOD for a log system. Which difficulties did you encounter in previous jobs? How did you solve them? What is the difference between git rebase and git merge? Basic TDD design questions and OOPs concepts Q: Basic relational database questions like indexing and many to many relations. What are your strengths and weaknesses? Count number of substring occurrences Introduce about yourself What is data encapsulation

moathOSA/PHP

PHP