Code Pumpkin

Category Archives: SQL Interview Questions

Subscribe

View vs Materialized View | Oracle SQL

September 10, 2017
Posted by Pumpkin

Every Java Developer is expected to have basic knowledge of database like SQL Queries, joins, having clause, group by, views, stored procedures, cursors, triggers, etc. If you are preparing for Java / J2EE interview, you should also prepare basic SQL interview questions. In our previous article on SQL interview Questions, we have seen differences between UNION and UNION […]

UNION Vs UNION ALL | Oracle SQL

May 28, 2017
Posted by Pumpkin

Though both UNION and UNION ALL is used to combine results of two SELECT queries, the main difference between them is that UNION doesn't include duplicate records, but UNION ALL does. Another difference between them is that UNION ​ALL is faster than UNION , but may look slow because it returns more data which takes more […]


Total Post : 80
Subscribe
Contribute Your Articles

Interview Experiences

Related Books

Like Us On Facebook

Alexa Page Rank