MagicBricks Public Relations Intern Interview Questions and Answers

As a sales executive, I go through various scenarios such as prospecting, qualifying leads, presenting solutions, negotiating, and closing deals.

• Prospecting for potential clients through cold calling, networking, and referrals

• Qualifying leads to determine if they are a good fit for our products/services

• Presenting solutions to clients and addressing any objections they may have

• Negotiating terms and pricing to reach a mu...read 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 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...read more

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...read more

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