Question Bank

What is the difference between GROUP BY and HAVING in SQL?

What is the purpose of the EXPLAIN or QUERY PLAN statement in SQL?

What is the difference between EXISTS and IN operators in SQL?

Which of the following are common approaches to API versioning in ASP.NET Core? (Select all that apply)

Which of the following are characteristics of interfaces in C# 8.0 and later? (Select all that apply)

Which of the following are valid ways to create and manage threads in .NET? (Select all that apply)

Which of the following are advantages of using stored procedures? (Select all that apply)

Which of the following are ACID properties in SQL transactions? (Select all that apply)

Which of the following are SOLID principles? (Select all that apply)

Which of the following are common caching strategies in ASP.NET Core? (Select all that apply)

Which of the following are advantages of using Entity Framework? (Select all that apply)

Which of the following are benefits of using LINQ in C#? (Select all that apply)

Which of the following are important aspects of session management security? (Select all that apply)

Which of the following are important secure cookie flags? (Select all that apply)

Which of the following are valid security testing methodologies? (Select all that apply)

Which of the following are effective methods to prevent SQL Injection? (Select all that apply)

Which of the following are important HTTP security headers? (Select all that apply)

Which HTTP security header protects against clickjacking?

What does the X-XSS-Protection header do?

What is the Principle of Least Privilege?