SQL Database Concepts – VARCHAR vs NVARCHAR
EPAM · not-specified · 0 answers
Year not specified · SQL
SQL interview questions and answers
Explore sql interview questions and answers. Read questions shared by candidates and compare community answers before your next interview.
Browse interview topics · Browse companies
Questions
Search Index Experience: Do you have experience with search indexes — Solr, Elasticsearch?
Dodge Construction Network · not-specified · 0 answers
Asked in 2026 · SQL, Elasticsearch
Raw SQL/Stored Procedures vs EF Core: You mentioned using both raw SQL/stored procedures and EF Core — can you give a specific scenario where EF Core didn't work well, and why you needed raw SQL instead?
Dodge Construction Network · not-specified · 0 answers
Asked in 2026 · SQL, Entity Framework Core
Dense rank
HCA Healthcare · not-specified · 0 answers
Year not specified · SQL
Indexes and types
HCA Healthcare · not-specified · 0 answers
Year not specified · SQL
What is CTE. What is it's syntax. How do you access CTE.
HCA Healthcare · not-specified · 0 answers
Year not specified · SQL
Write a SQL query to get 2nd highest salary
HCA Healthcare · not-specified · 0 answers
Year not specified · SQL
How do you delete duplicate records from a table?
Impetus · not-specified · 0 answers
Year not specified · SQL
Difference between ROW_NUMBER() and DENSE_RANK()?
Impetus · not-specified · 0 answers
Year not specified · SQL
What is isolation and ACID properties?
Agiliad Technologies Pvt Ltd · not-specified · 0 answers
Asked in 2026 · SQL
What is CTE?
Agiliad Technologies Pvt Ltd · not-specified · 0 answers
Asked in 2026 · SQL
Indexing Strategy: In what scenarios do you use a clustered index versus a non-clustered index?
QBurst · not-specified · 0 answers
Year not specified · SQL
How does indexing improve query performance?
Capgemini · not-specified · 0 answers
Year not specified · SQL
Clustered vs Non-Clustered Index.
Capgemini · not-specified · 0 answers
Year not specified · SQL
Stored Procedure vs Function.
Capgemini · not-specified · 0 answers
Year not specified · SQL
Why can't aggregate functions like COUNT() or SUM() be used in a WHERE clause?
Capgemini · not-specified · 0 answers
Year not specified · SQL
Difference between WHERE and HAVING.
Capgemini · not-specified · 0 answers
Year not specified · SQL
Delete Duplicate records from table using CTE
Capgemini · not-specified · 0 answers
Year not specified · SQL
In SQL Server, how do you make sure as to either one DML statement would be executed or none would be executed?
Wipro · not-specified · 0 answers
Year not specified · SQL