i
MagicBricks
Filter interviews by
I applied via LinkedIn and was interviewed in Apr 2024. There were 2 interview rounds.
Top trending discussions
I applied via Approached by Company and was interviewed in Jul 2024. There were 3 interview rounds.
I am an experienced Program Manager with a background in leading cross-functional teams and overseeing project timelines and budgets.
Led cross-functional teams to successfully launch a new product line
Managed project timelines and budgets to ensure on-time and within budget delivery
Collaborated with stakeholders to define project scope and objectives
Implemented project management best practices to improve efficiency an
I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.
I was interviewed before Apr 2021.
Round duration - 45 minutes
Round difficulty - Easy
This was a test where 2 coding questions were to be solved in 45 minutes.
Given a column title as it appears in an Excel sheet, your task is to return its corresponding column number.
S = "AB"
28
The seq...
Convert Excel column title to corresponding column number.
Iterate through the characters in the input string from right to left
Calculate the value of each character based on its position and multiply by 26^index
Sum up the values to get the final column number
Determine if two given strings, str1
and str2
, are permutations of each other.
Two strings are permutations of each other if the characters of one string can be re...
Check if two strings are permutations of each other.
Create character frequency maps for both strings.
Compare the frequency maps to check if they are permutations.
Handle edge cases like empty strings or strings of different lengths.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
The importance of problem-solving skills and teamwork.
Developed problem-solving skills through challenging coursework and projects.
Collaborated with diverse teams to complete group projects.
Participated in hackathons and coding competitions to enhance skills.
Learned to manage time effectively and prioritize tasks.
Developed a strong work ethic and dedication to excellence.
CommonFloor is a real estate platform that helps people find and rent/buy properties.
CommonFloor was founded in 2007 and is based in Bangalore, India.
It offers a range of services including property listings, property management, and home loans.
The platform has over 5 million registered users and lists properties in over 200 cities in India.
In 2016, CommonFloor was acquired by Quikr, another Indian online classifieds p
Find pair of elements in an array whose sum is equal to a given number K.
Iterate through the array and for each element, check if K minus the element exists in the array.
Use a hash table to store the elements and their indices for faster lookup.
If multiple pairs exist, return any one of them.
If no pair exists, return null or an appropriate message.
Session is maintained using session affinity or sticky sessions.
Session affinity ensures that a user's session is always directed to the same server.
Load balancer uses a unique identifier to route requests to the same server.
Sticky sessions can be implemented using cookies or URL rewriting.
Session replication can also be used to maintain session data across multiple servers.
Singleton pattern ensures only one instance of a class is created and provides a global point of access to it.
Create a private constructor to prevent direct instantiation of the class
Create a private static instance of the class
Create a public static method to access the instance
Ensure thread safety by using synchronized keyword or static initialization block
Examples: Logger, Configuration Manager, Database Connection
Explaining abstract class, interface and multiple inheritance in PHP.
Abstract class is a class that cannot be instantiated and can have abstract methods.
Interface is a collection of abstract methods and constants that can be implemented by a class.
Multiple inheritance is not possible in PHP, but can be achieved using interfaces.
Interfaces can be implemented by multiple classes, allowing for multiple inheritance-like be
Write a stored procedure from given tables and conditions
Identify the tables and their relationships
Determine the conditions to be used in the stored procedure
Write the SQL code for the stored procedure
Test the stored procedure to ensure it returns the desired results
To increase PHP memory at run time, modify the php.ini file or use ini_set() function.
Edit the memory_limit value in php.ini file
Use ini_set('memory_limit', '256M') function to increase memory limit at run time
Check for memory leaks in the code
Use unset() function to free up memory after use
php.ini is a configuration file for PHP that allows users to customize various settings.
Change PHP settings such as memory limit, file upload size, and error reporting
Enable or disable extensions and modules
Set timezone and language settings
Configure email settings
Control caching and session settings
Use window.location to get domain from a url in jQuery.
Use window.location to get the full url
Use .hostname to get the domain name
Use .replace() to remove 'www.' if present
WAP to find smallest palindrome number larger than given number.
Convert the given number to string and check if it is already a palindrome.
If not, increment the number and check if it is a palindrome.
Repeat until a palindrome number larger than the given number is found.
Use a while loop to implement the above steps.
WAP to check if linked list elements is a palindrome without using any extra space.
Traverse the linked list and reverse the second half of the list
Compare the first half with the reversed second half
Use two pointers to traverse the list, one at normal speed and other at double speed
Find the first non-repeating character in a string.
Create a hash table to store the frequency of each character in the string.
Iterate through the string and check the frequency of each character.
Return the first character with a frequency of 1.
Connection pooling is a technique of reusing database connections to improve performance.
Connection pooling helps to reduce the overhead of creating and destroying database connections.
It maintains a pool of connections that can be reused by multiple clients.
Connection pooling is commonly used in web applications to handle multiple requests simultaneously.
It can be configured with parameters like maximum number of conn...
A singleton class in PHP is a class that can only be instantiated once.
Create a private constructor to prevent direct instantiation
Create a private static variable to hold the instance of the class
Create a public static method to get the instance of the class
Ensure that the public static method always returns the same instance
To connect to MySQL database using PHP, create a Connection class.
Use mysqli_connect() function to establish a connection
Pass the database credentials as parameters to the function
Create a constructor method to initialize the connection
Create a query method to execute SQL queries
Close the connection using mysqli_close() method
There are three types of errors in PHP: syntax errors, runtime errors, and logical errors.
Syntax errors occur when the code is not written correctly, such as missing semicolons or parentheses.
Runtime errors occur during the execution of the code, such as trying to access an undefined variable.
Logical errors occur when the code runs without errors, but produces unexpected results, such as a miscalculation in a formula.
Session in PHP allows to store user data on the server for later use.
Session starts when a user logs in and ends when the user logs out or the session expires.
Session data is stored on the server and identified by a unique session ID.
Session variables can be set and accessed using the $_SESSION superglobal array.
Session can be destroyed using the session_destroy() function.
Session can be used to store user-specific dat...
Find missing element in an array of elements from 0 to n-1
Calculate sum of all elements in array and subtract from sum of n natural numbers
Use XOR operation on all elements and n natural numbers
Sort the array and find the missing element
I was interviewed before Jan 2021.
Round duration - 60 minutes
Round difficulty - Easy
This was a written coding test with 2 coding questions to be solved in 60 minutes.
You have a sequence of consecutive nonnegative integers. By appending all integers end-to-end, you formed a string S
without any separators. During this pro...
Given a string of consecutive nonnegative integers with one missing number, find the missing integer.
Iterate through the string to find the missing number by checking the consecutive integers.
If there is more than one missing number, all integers are present, or the string is invalid, return -1.
Handle cases where the missing number is at the beginning or end of the sequence.
Consider edge cases such as single-digit numb
You are given a string consisting of English alphabet characters. Your task is to identify and return the first character in the string that does not repeat...
The task is to find the first non-repeating character in a string, or return the first character if all characters repeat.
Iterate through the string to count the frequency of each character
Find the first character with a frequency of 1, or return the first character if no such character exists
Handle both uppercase and lowercase characters separately
Use a hashmap to store character frequencies efficiently
Round duration - 60 minutes
Round difficulty - Medium
Technical interview round with questions around PHP and DBMS.
Connection pooling is a technique used to manage a pool of database connections to improve performance and efficiency.
Connection pooling reduces the overhead of opening and closing database connections for each request.
It allows multiple clients to reuse a pre-established set of connections to the database.
Connection pooling helps in improving the scalability and performance of applications by efficiently managing data...
To create a singleton design pattern in PHP 5, use a private static variable to store the instance and a static method to retrieve it.
Create a private static variable to store the instance of the class.
Create a private constructor to prevent outside instantiation of the class.
Create a static method to check if an instance already exists and return it, or create a new instance if it doesn't.
Yes, PHP can be used to connect to MySQL by using MySQLi or PDO extensions.
Use MySQLi extension to connect PHP to MySQL
Use PDO extension to connect PHP to MySQL
Example using MySQLi: $conn = new mysqli($servername, $username, $password, $dbname);
Example using PDO: $conn = new PDO('mysql:host=$servername;dbname=$dbname', $username, $password);
Different types of errors in PHP include syntax errors, runtime errors, and logical errors.
Syntax errors: Occur when there is a mistake in the code syntax, preventing the script from running.
Runtime errors: Happen during script execution, such as division by zero or calling a function that does not exist.
Logical errors: Difficult to detect as the code runs without errors, but produces incorrect results.
Fatal errors: St...
Session management in PHP involves storing user data on the server to maintain state between multiple requests.
Sessions are started using session_start() function in PHP.
Session data is stored on the server and a unique session ID is sent to the client's browser.
Session variables can be set, accessed, and unset using $_SESSION superglobal array.
Sessions can be destroyed using session_destroy() function.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Accounts Manager
264
salaries
| ₹0 L/yr - ₹0 L/yr |
Relationship Manager
256
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
233
salaries
| ₹0 L/yr - ₹0 L/yr |
Area Sales Manager
179
salaries
| ₹0 L/yr - ₹0 L/yr |
Sales Executive
92
salaries
| ₹0 L/yr - ₹0 L/yr |
NoBroker
99acres
CommonFloor
PropTiger.com