PHP Fullstack Interview Questions

MySQL
SQL Query -- fetch first and last rows from a table
MySQL, SQL
azure
WebApp Architecture: soft delete question
Azure
Laravel
How to do request validation in Laravel? Give an example.
Laravel
git
What is the difference between Git and SVN
Git
aws
What are the consistency models for modern DBs offered by AWS?
AWS
aws
Name and explain some security products and features available in VPC?
AWS
docker
Docker Container states
Docker
docker
How to use docker for multiple application environments?
Docker
Agile
What is the role of Validators in JIRA?
Jira
JavaScript
Accessing HTML elements in JavaScript
JavaScript
TypeScript
Is it possible to compile .ts automatically with real-time changes in the .ts file?
TypeScript
php
Check about there Project details
PHP
php
Are objects in PHP 5 passed by value or reference? Explain
PHP
php
Have you ever used a PHP framework? What frameworks are you experienced in? What frameworks do you prefer? Why?
PHP
php
In how many ways we can retrieve the data in the result set of MySQL using PHP?
PHP
docker
How container is different from VM?
Docker
MySQL
having vs where MySQL
MySQL
docker
Write a docker file to create and build apache image?
Docker
aws
Load Balancing in AWS
AWS
php
Explain about polymorphism? What are the types of polymorphism ? Please explain
PHP
coding-cability
Find Kth smallest element in a two dimensional matrix

Find Kth smallest element in a two dimensional matrix.

Coding Capability
AJAX
How to pass CSRF token with Ajax request ?
Ajax
php
Why would you use === instead of ==?
PHP
php
How can you enable error reporting in PHP?
PHP
aws
Scenario AWS 2

You have an application running on an EC2 instance.

AWS
Laravel
How to make and use middleware in Laravel ?
Laravel
Laravel
How to use stored procedures in laravel ?
Laravel
coding-cability
Coding Question: Write a program to print all prime factors of a given number.

Write a program to print all prime factors of a given number.

Coding Capability
coding-cability
Coding Question: Find "Perfect Numbers" between 1 and given N

Perfect Number: A (positive integer) number is called a perfect number, if the sum of all of its factors, except the number itself, is equal to the

Coding Capability
MySQL
How to create an Index in MySQL?
MySQL
coding-cability
Coding Question: Kaprekar's Constant: Magic number 6174

Indian mathematician D.R. Kaprekar observed a very interesting property of number 6174.

Coding Capability
MySQL
What Are The Security Alerts While Using Mysql?
MySQL
php
Explain your approach to implementing authentication and authorization for different API endpoints in a PHP framework
PHP
coding-cability
Coding Question: Simulate a "hat game"

Imagine there are 100 pieces of paper in a hat, labelled from 1-100. Two pieces of paper are chosen at random.

coding-cability
Coding Question: Calculate pi using Euler's infinite sum series

Leonhard Euler (15 April 1707 – 18 September 1783) was a Swiss mathematician, physicist, astronomer, geographer, logician and engineer who founded

MySQL
Can you explain the logical architecture of MySQL?
MySQL
Agile
Explain the most critical agile matrices
aws
Scenario AWS

A start-up company has a web application based in the us-east-1 Region with multiple Amazon EC2 instances running behind an Application Load Balanc

How you will check the httpd.conf consistency?
Apache
Agile
Mention the challenges involved in developing Agile Software?
Laravel
Explain reverse routing in laravel ?
php
Scenario PHP

Suppose you receive a form submitted by a post to subscribe to a newsletter. This form has only one field, an input text field named email.

PHP
php
How would you implement a class in the following scenario?

Suppose that you have to implement a class named Dragonball.

Coding Capability
Can you explain the logical architecture of MySQL?
MySQL
Laravel
How is Oauth used in laravel ?
php
Outline your strategy for addressing common security vulnerabilities in a PHP application built with a framework.
PHP
docker
what is docker-compose?
Docker
kubernetes
What are the different services within Kubernetes?
Kubernetes
php
How to create API in PHP?
PHP
php
What will be the output of each of the statements below and why?var_dump(0123 == 123); var_dump('0123' == 123); var_dump('0123' === 123);
PHP
kubernetes
What is a Namespace in Kubernetes?
Kubernetes
MySQL
How Many Triggers Are Possible In Mysql?
MySQL
aws
What is "serverless architecture" in AWS?
AWS
php
Describe your approach to implementing WebSocket functionality within a PHP framework to achieve real-time updates.
PHP
docker
Write a command to check container logs?
Docker
coding-cability
Candidate Facing: Write the code to find Most Booked Hotel Room

Given a hotel which has 10 floors [0-9] and each floor has 26 rooms [A-Z].

What are different approaches to query optimization in NoSQL DB?
NoSQL
php
Explain how you would handle concurrent user requests in a PHP framework to maintain data consistency.
PHP
php
Describe some techniques and best practices you would employ to optimize the performance of a PHP application
PHP
MySQL
How can I see all indexes on a table in MySQL Database?
MySQL
kubernetes
What is ‘Heapster’ in Kubernetes?
Kubernetes
kubernetes
What is the LoadBalancer in Kubernetes?
docker
Write a command to start docker container?
Docker
What is horizontal and Vertical Scaling?
Cloud Computing
php
What are PHP sessions and how do they work?
PHP
php
What’s the difference between unset() and unlink()
PHP
php
What is Abstraction & Abstract Class in PHP OOP ?
PHP
aws
What is EC2 in AWS?
AWS
What is usecase of Puppet/Chef/Ansible/Saltstack?
DevOps
docker
How to create container in Docker?
Docker
What is Hypervisor?
Cloud Computing
php
Describe how you would incorporate a caching mechanism into a PHP framework to improve the performance.
PHP
docker
What is Docker file?
Docker
aws
What is VPC ? How it is different from regular security group?
DevOps
Please specify your role in CI/CD? which all components are part of your CI/CD?
DevOps
What is CI/CD?
aws
How to create security group in EC2?