Click on the question to see the answer
Basic SQL Interview Questions
- Can we use a WHERE clause in TRUNCATE statement?
- What is the difference between TRUNCATE and DELETE commands
- How to find SQL statements which takes more time to run on Database?
- What is the different between Analytic and Group function in SQL?
- What is the Difference between an Empty String and a NULL value?
- What is Referential Integrity?
- What is the structure of DUAL table?
- How to find record count of a table without using count(*) ?
- What is the standard execution sequence of an SQL Statement followed by Oracle Database engine?
- Lets say there is a table with 500 rows. Write a query to display rows from 101 to 500.
- Query to find records inserted in last 2 hours
- To optimize the performance of an SQL statement what should be the order of tables in FROM clause?
- To optimize the performance of an SQL statement what should be the order of join conditions in WHERE clause?
- When to use EXISTS over IN?
- How to select odd number records from a table?
- How to display a number in words?
Advanced SQL Interview Questions
- Why ROWNUM =(> 1) will not work ?
- Why does NULL = NULL Fail in SQL statements?
- How to sort a VARCHAR2 field as a Numeric field in SQL?
- What is Global Temporary Tables and What is it Purpose?
- How would you convert date into Julian date format in Oracle SQL?
Note: New Questions will be added to this list on regular basis