Zobi Web Solutions Dot Net Core Developer Interview Questions, Process, and Tips

A contractor is a person or company hired to perform work on a specific project or task.

• Contractors can be individuals or companies who are hired on a temporary basis.

• There are different types of contractors such as independent contractors, general contractors, and subcontractors.

• Contractors are typically responsible for their own taxes, insurance, and equipment.

• Examples of contractors include freelance developers, con

Access modifiers in C# control the visibility and accessibility of classes, methods, and other members within a program.

• There are five access modifiers in C#: public, private, protected, internal, and protected internal.

• Public access modifier allows a class, method, or member to be accessed from any other class.

• Private access modifier restricts access to only within the same class.

• Protected access modifier allows acces...read more

Contracts in SQL are agreements between two or more parties defining the terms of a relationship or operation.

• Contracts in SQL are used to enforce business rules and ensure data integrity.

• They can include constraints, triggers, stored procedures, and other database objects.

• Examples of contracts in SQL include foreign key constraints, check constraints, and unique constraints.

Primary key uniquely identifies a record in a table, foreign key links two tables, and unique key ensures uniqueness of values in a column.

• Primary key: uniquely identifies each record in a table, cannot have duplicate values

• Foreign key: links two tables together, enforces referential integrity

• Unique key: ensures uniqueness of values in a column, allows null values but only one null per column

Delete removes specific rows, truncate removes all rows, drop removes entire table in SQL.

• Delete is used to remove specific rows from a table based on a condition.

• Truncate removes all rows from a table but keeps the table structure.

• Drop removes the entire table along with its structure from the database.

• Delete is slower than truncate as it logs individual row deletions.

• Truncate is faster than delete as it deallocates t...read more