MAQ Software Software Engineer Intern Interview Questions and Answers

Q1. Write code for Level Order Traversal for Binary Tree
Ans. 
Level Order Traversal for Binary Tree is a method to visit all nodes level by level starting from the root.
• Use a queue data structure to keep track of nodes at each level

• Start by pushing the root node into the queue

• While the queue is not empty, dequeue a node, visit it, and enqueue its children
Answered by AI
Add your answer
Q2. Difference between left join and right join
Ans. 
Left join includes all records from the left table and matching records from the right table, while right join includes all records from the right table and matching records from the left table.
• Left join keeps all records from the left table, even if there are no matches in the right table.

• Right join keeps all records from the right table, even if there are no matches in the left table.

• Example: If we have a table of em...read more
Answered by AI
Add your answer

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