35 questions for “SQL Queries”

Found in 1 field. Select a question to see its full answer.

Matching topics

SQL Server Subqueries 7 SQL Server JSON Support in SQL Server 2 Node.js Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize) 1 SQL Server SQL Server Profiler & Extended Events 1

Information Technology

35 questions in 5 technologies

#	Question	Technology	Topic	Level
1	How do you configure and use raw SQL queries alongside LINQ in EF Core when a complex query is difficult or inefficient to express in LINQ? .NET › Entity Framework Core & Data Access	.NET	Entity Framework Core & Data Access	Intermediate
2	How should a team decide between using an ORM like Eloquent or Doctrine versus writing raw SQL queries directly for a specific, particularly complex or performance sensitive part of an application? PHP › Eloquent ORM & Doctrine ORM	PHP	Eloquent ORM & Doctrine ORM	Advanced
3	What is a subquery in SQL Server, and how is it typically used within a larger query? SQL Server › Subqueries	SQL Server	Subqueries	Beginner
4	How does Sequelize define models and relationships for a relational (SQL) database in Node.js? Node.js › Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)	Node.js	Databases & ORMs (MongoDB/Mongoose, SQL/Sequelize)	Intermediate
5	How do you create an Extended Events session to capture specific long running queries on a production server? SQL Server › SQL Server Profiler & Extended Events	SQL Server	SQL Server Profiler & Extended Events	Intermediate
6	What are common mistakes developers make when writing subqueries that can lead to incorrect results or poor performance? SQL Server › Subqueries	SQL Server	Subqueries	Intermediate
7	How does the SQL Server query optimizer typically handle and potentially transform a subquery internally when generating an execution plan? SQL Server › Subqueries	SQL Server	Subqueries	Advanced
8	What is an index in SQL Server, and how does it help speed up queries? SQL Server › Indexes	SQL Server	Indexes	Beginner
9	What is a user defined function in SQL Server, and why would you create one instead of repeating the same logic in multiple queries? SQL Server › User Defined Functions	SQL Server	User Defined Functions	Beginner
10	How does SQL Server compile and cache execution plans for stored procedures, and how does this affect performance compared to ad hoc queries? SQL Server › Stored Procedures & Functions	SQL Server	Stored Procedures & Functions	Advanced

Show all 35 questions in Information Technology