PSG Software Technologies Interview Questions, Process, and Tips

Model binding is the process of mapping data from HTTP requests to objects in MVC and ASP.NET Core.

• Model binding automatically maps data from HTTP requests to action method parameters or properties of a model class.

• It simplifies the process of retrieving data from forms, query strings, route values, and JSON/XML payloads.

• Model binding can be customized using attributes like [Bind], [FromQuery], [FromBody], etc.

• Example:...read more

Create a simple model view controller to retrieve values from a database

• Create a model class to represent the data structure from the database

• Create a controller to handle requests and interact with the model

• Create a view to display the data retrieved from the database

OOPs concepts like inheritance, encapsulation, polymorphism, and abstraction were used in my previous projects for designing modular and reusable code.

• Inheritance: Used to create parent-child relationships between classes. For example, a base class 'Vehicle' with child classes 'Car' and 'Truck'.

• Encapsulation: Used to hide the internal implementation details of a class and only expose necessary methods and properties. F...read more

SQL queries for creating database tables using DML and DDL

• Use CREATE TABLE statement for DDL to create a new table

• Use INSERT INTO statement for DML to insert data into the table

• Use SELECT statement to retrieve data from the table

• Use UPDATE statement to modify existing data in the table

• Use DELETE statement to remove data from the table

Use a query to print a word from horizontal to vertical

• Use the TRANSLATE function in SQL to convert each character of the word into a separate row

• Use a recursive CTE (Common Table Expression) to achieve the desired output

• Consider using a loop in a programming language to iterate over each character of the word and print vertically