Frequently asked Sql Questions interview..

1.   Can we use a WHERE clause in TRUNCATE statement?

2.   What is the difference between TRUNCATE and DELETE commands

3.   How to find SQL statements which takes more time to run on Database?

4.   What is the different between Analytic and Group function in SQL?

5.   What is the Difference between an Empty String and a NULL value?

6.   What is Referential Integrity?

7.   What is the structure of DUAL table?

8.   How to find record count of a table without using count(*) ?

9.   What is the standard execution sequence of an SQL Statement followed by Oracle Database engine?

10. Let’s say there is a table with 500 rows. Write a query to display rows from 101 to 500.

11. Query to find records inserted in last 2 hours

12. To optimize the performance of an SQL statement what should be the order of tables in FROM clause?

13. To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?

14. When to use EXISTS over IN?

15. How to select odd number records from a table?

16. How to display a number in words?

17. Why ROWNUM =(> 1) will not work ?

18. Why does NULL = NULL Fail in SQL statements?

19. How to sort a VARCHAR2 field as a Numeric field in SQL?

20. What is Global Temporary Tables and What is it Purpose?

21. How to Create new table from existing table?

22. Difference between RANK,DENSE_RANK,FIRST,LAST Analylical Functions?