SQL INTERVIEW QUESTIONS FOR DEVELOPERS ( Vestino Technologies )

1.How to find duplicate records in SQL?
2.What is Case WHEN in SQL?
3.How to find 2nd highest salary in SQL?
4. How to delete duplicate rows in SQL
5.What is cursor in SQL?
6.How to create a stored procedure using SQL Server?
7.How to create an index in SQL?
8.How to change column data-type in SQL?
9.What is the difference between SQL and NoSQL databases?
10.SQL JOINS INTERVIEW QUESTIONS
11.How to change column name in SQL?
12.What is a view in SQL?
13. How to drop a column in SQL?
14.How to remove duplicate rows in SQL?
15.How to join two tables in SQL?
16. How to use BETWEEN in SQL?
17.ADVANCED SQL INTERVIEW QUESTIONS
18. What are the subsets of SQL?
19.What is the difference between CHAR and VARCHAR2 datatype in SQL?
20.How to sort a column using a column alias?
21.What is “Trigger” in SQL?
22. Write a Query to display employee details along with age?
23.Write a Query to display employee details along with age?
24.Write an SQL query to get the third maximum salary of an employee from a table named employee_table.
25.What are aggregate and scalar functions?
26.What is a deadlock?
27.Explain left outer join with example?
28.What is SQL injection?
29.What is an UNION operator?
30. Explain SQL Constraints?
31.What is ALIAS command?
32.What are Group Functions? Why do we need them?
33.How can dynamic SQL be executed?
34.What is the usage of NVL() function?
35.This function is used to convert NULL value to the other value.
36.Write a Query to display employee details belongs to ECE department?
37.SELECT EmpNo, EmpName, Salary FROM employee WHERE deptNo in (select deptNo from dept where deptName = ‘ECE’)
38.What are the main differences between #temp tables and @table variables and which one is preferred ?
39.What is CLAUSE
40. What is recursive stored procedure?
41. What is a schema?
42.What does the BCP command do?
43.What is a Cross Join?
44.Which operator is used in query for pattern matching?
45.Write a SQL query to get the current date?
46.State the case maniplation functions in SQL?
47.How to add a column to an existing table?
48.How to store Videos inside SQL Server table ?
49.State the order of SQL SELECT?
50. What is the difference between IN and EXISTS?
51.How do you copy data from one table to another table ?
52.List the ACID properties that makes sure that the database transactions are processed
53.What will be the output of the following Query, provided the employee table has 10 records? 
54.What do you mean by Stored Procedures? How do we use it?
55.What does GRANT command do?
56.What does First normal form do?
57. How to add e record to the table?
58.What are the different tables present inMySQL?
59.What is BLOB and TEXT in MySQL?
60.What is the use of mysql_close()?
61.How do you return a hundred books starting from 25th?
62.How would you select all the users, whose phone number is NULL?
63.How do you run batch mode in mysql?
64.Write an SQL query to show the second highest salary from a table.
65.Write an SQL query to fetch three max salaries from a table.
66.What is the difference between NOW() and CURRENT_DATE()?
67.How can we convert between Unix & MySQL timestamps?
68.What are the nonstandard string types?
69.What is the group by clause used for?
70.How do you get the last id without the max function?
71.Write a SQL query to fetch only even rows from the table.
72.Write a SQL query to create a new table with data and structure copied from another table.