Mangalam Information Technolgies Interview Questions and Answers

Enough with easy level questions from leetcode

Q1. Self introduction
Add your answer
Q2. Sql and python questions
Add your answer

Q1. Explain the Lifecycle of MVC and the deployment process.
Ans. 
MVC lifecycle involves Model, View, and Controller interactions, while deployment ensures the application is live and accessible.
• 1. Model: Represents data and business logic. Example: A User model that interacts with a database.

• 2. View: Displays data to the user. Example: HTML templates rendering user information.

• 3. Controller: Handles user input and updates the model. Example: A login controller processing user creden...read more
Answered by AI
Add your answer
Q2. What is CTE and syntax of same ?
Ans. 
CTE stands for Common Table Expression, a temporary result set in SQL used for complex queries.
• CTE is defined using the WITH clause.

• It can be recursive or non-recursive.

• Example syntax: WITH CTE_Name AS (SELECT column1 FROM table) SELECT * FROM CTE_Name;

• CTEs improve readability and organization of SQL queries.

• They can be referenced multiple times within a query.
Answered by AI
Add your answer
Q3. What is CORS (Cross Origin Resource Sharing) ?
Ans. 
CORS is a security feature that allows restricted resources on a web page to be requested from another domain outside the domain from which the resource originated.
• CORS is implemented via HTTP headers that allow servers to specify who can access their resources.

• For example, a web application on 'example.com' can request resources from 'api.example.com' if CORS is enabled.

• The 'Access-Control-Allow-Origin' header is cruc...read more
Answered by AI
Add your answer
Q4. What is Bundling and Minification ?
Ans. 
Bundling and minification optimize web assets by reducing file size and number of requests, improving load times and performance.
• Bundling combines multiple files (e.g., JavaScript, CSS) into a single file to reduce HTTP requests.

• Minification removes unnecessary characters (like whitespace and comments) from code to decrease file size.

• Example of bundling: Combining 'script1.js', 'script2.js', and 'script3.js' into 'bund...read more
Answered by AI
Add your answer
Q5. What is HTML helper ?
Ans. 
HTML helpers are functions that simplify the generation of HTML markup in web applications, enhancing code readability and maintainability.
• HTML helpers are often used in MVC frameworks to generate HTML elements easily.

• Common HTML helpers include methods for creating forms, links, and other UI components.

• Example: In ASP.NET MVC, Html.TextBoxFor() generates an input element for a model property.

• HTML helpers promote DRY (...read more
Answered by AI
Add your answer