Urmila International Services PHP Developer Interview Questions and Answers

It had 5 question: 1 easy, 3 medium and 1 hard

Backend application implimentation

Q1. One Dsa question was asked
Add your answer
Q2. One system design question and CS fundamental
Add your answer

Q1. SQL topics in operaters dql,
Add your answer
Q2. Dml,ddl,tcl,sub query
Add your answer
Q3. College projects
Add your answer
Q4. Special operators
Add your answer
Q5. Education baground
Add your answer

Q1. Java threads concepts and its usage
Add your answer
Q2. Data structures problems and design quentions
Add your answer

Q1. Merge sort time complexity less
Ans. 
Merge sort has a time complexity of O(n log n) in the worst case scenario.
• Merge sort divides the array into two halves, sorts them recursively, and then merges them back together.

• The time complexity of merge sort is O(n log n) in the worst case scenario.

• For example, sorting an array of 8 elements would take 3 recursive calls to merge sort.
Answered by AI
Add your answer
Q2. Palindrome with react js to show on UI
Ans. 
Create a palindrome checker using React JS to display on the UI
• Create a input field for user to enter a string

• Use state to store the input string

• Create a function to check if the input string is a palindrome

• Display the result on the UI
Answered by AI
Add your answer

Javascript question on promise, callbacks, hosting

Easy exam sample available on youtube

Q1. What are step functions.
Ans. 
Step functions are a type of serverless function that allow you to create workflows by chaining multiple functions together.
• Step functions are used to coordinate multiple AWS services into serverless workflows.

• They allow you to define a series of steps in a workflow, with each step being a separate function.

• You can use step functions to handle complex business logic, long-running processes, and error handling.

• Step func...read more
Answered by AI
Add your answer
Q2. How to scale lambdas
Ans. 
Scaling lambdas involves optimizing memory usage, increasing concurrency, and managing dependencies.
• Optimize memory usage by reducing unnecessary variables and objects

• Increase concurrency by using asynchronous programming and parallel processing

• Manage dependencies by breaking down functions into smaller, more modular components

• Consider using AWS Lambda Provisioned Concurrency for consistent performance
Answered by AI
Add your answer

Q1. How did you handled a difficult collegelue
Ans. 
I addressed the issue directly and professionally, seeking to understand their perspective and find common ground.
• Approached the colleague privately to discuss the issue

• Listened actively to their concerns and perspective

• Sought to find common ground and reach a resolution

• Maintained professionalism and respect throughout the conversation
Answered by AI
Add your answer

Q1. What is normalization
Ans. 
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by eliminating duplicate data

• Normalization ensures data integrity by enforcing relationships between tables

• There are different normal forms such as 1NF, 2NF, 3NF, and BCNF
Answered by AI
Add your answer
Q2. What is indexing
Ans. 
Indexing is a technique used to improve the performance of database queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of rows that match a certain condition.

• They work similar to an index in a book, allowing the database to quickly locate the rows that satisfy a query.

• Examples of indexes include primary keys, unique
Answered by AI
Add your answer

Worst set of questions

Advanced DSA for entry level role

Q1. Find 3rd highest salary
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and get the third highest salary
Answered by AI
Add your answer
Q2. Pivoting and unpivoting in SQL
Ans. 
Pivoting and unpivoting are techniques used in SQL to transform data from rows to columns and vice versa.
• Pivoting involves rotating rows into columns, typically used to summarize data.

• Unpivoting involves rotating columns into rows, typically used to normalize data.

• Pivoting can be done using the PIVOT keyword in SQL, while unpivoting can be done using the UNPIVOT keyword.
Answered by AI
Add your answer
Q3. Difference in rank and dense rank
Ans. 
Rank assigns unique rank to each row, while dense rank allows for ties in ranking.
• Rank leaves gaps in ranking sequence, while dense rank does not

• Rank(1, 2, 2, 4) = 1, 2, 3, 4

• Dense Rank(1, 2, 2, 4) = 1, 2, 2, 3
Answered by AI
Add your answer