i
AppZen
Filter interviews by
Joining two tables with a WHERE clause in SQL
Use the JOIN keyword to combine two tables based on a related column
Add a WHERE clause to specify the condition for the join
Example: SELECT * FROM table1 JOIN table2 ON table1.id = table2.id WHERE table1.column = 'value'
Handle bad customers by remaining calm, listening actively, empathizing with their situation, offering solutions, and seeking help if needed.
Remain calm and composed
Listen actively to understand their concerns
Empathize with their situation
Offer solutions or alternatives
Seek help from a supervisor if necessary
I applied via LinkedIn and was interviewed in Mar 2023. There were 4 interview rounds.
I applied via Approached by Company and was interviewed before Nov 2023. There were 2 interview rounds.
Flask is a lightweight WSGI web application framework in Python.
Web development
API development
Microservices
Prototyping
RESTful services
SQL query to retrieve specific output
Use SELECT statement to retrieve data
Use WHERE clause to filter results based on specific criteria
Use JOIN clause to combine data from multiple tables if needed
Python code to find a substring from a string
Use the 'find' method to locate the starting index of the substring within the string
Extract the substring using slicing based on the starting index and length of the substring
Handle cases where the substring is not found by checking the return value of 'find'
I want to join this company because of its reputation for innovation and commitment to employee growth.
Reputation for innovation in the industry
Commitment to employee growth and development
Exciting projects and opportunities for learning and advancement
I applied via Referral and was interviewed before Aug 2020. There were 5 interview rounds.
AppZen interview questions for popular designations
Top trending discussions
Probability of a horse going out of a chessboard in 'n' steps.
The total number of possible moves for a horse is 8.
The probability of going out of the board depends on the position of the horse.
For example, if the horse is at a corner, the probability of going out of the board is higher.
The probability can be calculated using combinatorics and geometry.
I applied via Campus Placement
I am an avid traveler and have visited over 20 countries
I love experiencing new cultures and trying new foods
I have backpacked through Europe and Asia
I have volunteered in orphanages in Cambodia and Nepal
Mobile advertising platform
Adtech
Mobile marketing
App monetization
Maximum sub sequence sum in an array
Use Kadane's algorithm
Initialize max_so_far and max_ending_here to 0
Iterate through the array and update max_ending_here and max_so_far
Return max_so_far
Endianness refers to the byte order of a system. It determines how multi-byte data types are stored in memory.
Little-endian systems store the least significant byte first, while big-endian systems store the most significant byte first.
Endianness can affect the way data is transmitted between systems.
To determine the endianness of a system, you can use the byte order mark (BOM) or write a test program that checks the by...
Sort an array of 0's and 1's only.
Use two pointers, one at the beginning and one at the end of the array.
Swap 0's from the beginning with 1's from the end until the pointers meet.
Alternatively, use a counting sort algorithm to count the number of 0's and 1's and then reconstruct the array.
Heaps are data structures used to efficiently find the maximum or minimum element in a collection.
Max heap: parent nodes are always greater than or equal to child nodes
Min heap: parent nodes are always smaller than or equal to child nodes
Heaps are commonly used in priority queues and sorting algorithms
Heap operations include insert, delete, and extract max/min
Example: An array [3, 8, 2, 5, 1, 4, 6] can be represented a
Find 3 numbers in an array where a+b=c.
Loop through the array and check for all possible combinations of a and b.
Use a hash table to store the values of a and b, and check if c is present in the hash table.
Sort the array and use two pointers to find a and b, and then check if their sum equals c.
Algorithms for manipulating arrays and strings in coding
Use sorting algorithms like quicksort and mergesort for arrays
Use string manipulation functions like substring and replace for strings
Use dynamic programming for optimizing solutions to array and string problems
Designing a large scale Ad Server
Use distributed systems for scalability
Implement caching for faster ad delivery
Ensure high availability and fault tolerance
Use real-time bidding for efficient ad placement
Implement fraud detection mechanisms
Ensure compliance with privacy regulations
The program capitalizes the first letter of each reversed word in a sentence.
Split the sentence into an array of words using space as a delimiter.
Reverse each word in the array and capitalize the first letter.
Join the modified words back into a sentence.
I applied via Company Website and was interviewed in Sep 2020. There were 5 interview rounds.
based on 3 interviews
Interview experience
Data Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Data Scientist
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer 2
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Fyle
Rippling
ClearTax
Zoho