Quais os comandos de DDL? e os de DML?
Analyste Sql Interview Questions
2,216 analyste sql interview questions shared by candidates
Master database crash , what will you do.
Explain the types of Indexes with example
1. What is the difference between `INNER JOIN` and `OUTER JOIN`? 2. How would you optimize a slow-running query? 3. How do you ensure database normalization, and why is it important? 4. How do you handle duplicate records in a table? 5. What are the advantages of using stored procedures? 1. How would you retrieve the second highest salary from an employee table? 2. How do you ensure data integrity in a database? 3. Describe a situation where you had to improve database performance. 1. How do you handle disagreements within a team about database design decisions? 2. Describe a challenging project you worked on and how you managed it. 3. How do you stay updated with the latest SQL and database technologies? 1. Where do you see yourself in five years? 2. Why do you want to work with our company? 3. What are your greatest strengths and weaknesses as an SQL Developer?
How will you monitor sql server? Tell me some of the tools
The ask me information about my experience and expectations.
Sql tuning
Architect a redundant SQL Server environment
Difference between where and having Diff b/w group by and windows function Error Handling In SP Trigger Function Diff between SP and Function Windows function Odd rows in 50 empid Inner join two tables with nulls
Asked for basics like backups recovery model and HA DR feature and System DB
Viewing 1501 - 1510 interview questions