Dot Net Core Developer Interview Questions and Answers for Freshers

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, construction companies, and consulting firms.

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 the data pages in one go.

• Drop is irreversible and deletes t...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.