MAQ Software Interview Questions and Answers for Freshers

The test had 2 standard DSA questions and 9 MCQs based on CS fundamentals.

Q1. Two Sum Of leetcode
Ans. 
Given an array of integers, return indices of the two numbers such that they add up to a specific target.
• Use a hashmap to store the difference between the target and current element

• Iterate through the array and check if the current element's complement exists in the hashmap

• Return the indices of the two numbers if found
Answered by AI
Add your answer
Q2. SQL Top 2 candidates query
Ans. 
Retrieve the top 2 candidates based on their scores using SQL.
• Use the SELECT statement to choose the candidate details.

• Utilize the ORDER BY clause to sort candidates by score in descending order.

• Limit the results to the top 2 using the LIMIT clause.

• Example query: SELECT * FROM candidates ORDER BY score DESC LIMIT 2;
Answered by AI
Add your answer

Q1. What is bios explain
Ans. 
BIOS (Basic Input/Output System) is firmware that initializes hardware during booting and provides runtime services for operating systems.
• BIOS is stored on a chip on the motherboard.

• It performs POST (Power-On Self-Test) to check hardware functionality.

• BIOS settings can be accessed by pressing a specific key during startup (e.g., F2, DEL).

• It allows users to configure hardware settings like boot order and system time.

• Mod...read more
Answered by AI
Add your answer
Q2. Explain cloud service providers
Ans. 
Cloud service providers offer scalable computing resources and services over the internet, enabling businesses to operate efficiently.
• Types of services: IaaS (e.g., AWS EC2), PaaS (e.g., Google App Engine), SaaS (e.g., Microsoft 365).

• Scalability: Resources can be adjusted based on demand, allowing businesses to grow without heavy upfront investments.

• Cost-effectiveness: Pay-as-you-go pricing models reduce the need for l...read more
Answered by AI
Add your answer

Coding round consisting DSA portion mainly.

Q1. SQL questions on Joins
Add your answer
Q2. Problems given on Hacker rank
Add your answer

Q1. Sorting related questions
Add your answer
Q2. Tell me about yourself, family background, hobbies
Add your answer

Easy leetcode and SQL

Basic aptitude questions Learn from Indiabix

Q1. Some DBA questions regarding Stored procedures. What are SSIS, SSAS and SSMS?
Add your answer
Q2. What does a Stored Procedure do
Ans. 
A stored procedure is a precompiled set of SQL statements that can be executed on a database server.
• Stored procedures are used to encapsulate and execute complex database operations.

• They can be used to improve performance by reducing network traffic.

• Stored procedures can be parameterized and reused across multiple applications.

• They provide a level of security by allowing access to the database only through the procedur...read more
Answered by AI
Add your answer
Q3. Write a SQL query to move table from one Schema to other
Ans. 
A SQL query to move a table from one schema to another.
• Use the ALTER TABLE statement to rename the table and move it to the new schema.

• Specify the new schema name in the ALTER TABLE statement.

• Ensure that the user executing the query has the necessary privileges to perform the operation.
Answered by AI
Add your answer
Q4. Difference between SSMS, SSIS and SSAS
Ans. 
SSMS is a management tool for SQL Server, SSIS is an ETL tool, and SSAS is a BI tool for analyzing data.
• SSMS (SQL Server Management Studio) is a graphical management tool for SQL Server.

• SSIS (SQL Server Integration Services) is an ETL (Extract, Transform, Load) tool used for data integration and workflow applications.

• SSAS (SQL Server Analysis Services) is a BI (Business Intelligence) tool used for analyzing and reporti...read more
Answered by AI
Add your answer
Q5. What are cubes. How are they different from Databases
Ans. 
Cubes are multidimensional data structures used for analysis and reporting. They differ from databases in their structure and purpose.
• Cubes store data in a multidimensional format, allowing for efficient analysis and reporting.

• They are designed to handle large volumes of data and provide fast query performance.

• Cubes use dimensions, measures, and hierarchies to organize and analyze data.

• Unlike databases, cubes are optim...read more
Answered by AI
Add your answer

Coding round with a python question and SQL query

Q1. Technical question and a coding question in python, medium level
Add your answer