Archive for January 26th, 2008

How many different flavors of SQL are there?

Saturday, January 26th, 2008


A database programming language usually involves DBMS specific functions/syntax. If we use it instead of a standard SQL, the procedure code might not work in other DBMS, mostly due to the differences in the feature sets of the different database programming languages. So there are as many falvors as there are different RDBMS’s.

 Share

Posted in Database Interview Questions | No Comments »

Please describe how a cross join (also known as the Cartesian PRODUCT) works.

Saturday, January 26th, 2008

A cross join is when we join every row of one table to every row of another table, which yields all possible pairs.  Note A cross join can be specified in two ways: using the JOIN syntax or by listing the tables in the FROM clause separated by commas without using a WHERE clause to supply join criteria.

 Share

Posted in Database Interview Questions | No Comments »