Scenario based questions for SQL, to write queries for PIVOT, UNION and MERGE.
Sql Developer Interview Questions
2,214 sql developer interview questions shared by candidates
SSIS Deployment
1) Types of joints in sql server 2) DML and DDL commands
Basic SQL questions, easy queries like - Select all customers that starts with the letter "a":
Como você se descreve no ambiente de trabalho?
Introduce yourself first or background
How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?
MCA with 3 year of experience in Dot net,silverlight,wpf,Sql server ,crystal report
sql optimization and performance
Joins,triggers,aggrigation,pl/sql
Viewing 451 - 460 interview questions