SQL Interview Questions: Part 1

1. What is the difference between SQL, Oracle, MySQL, and SQL Server?

SQL is the name of the language used to query databases and follows a standard. Oracle, MySQL andSQL Server are different implementations or versions of a database management system, whichimplement the SQL standard and build on it in different ways.Oracle database is targeted at large companies, SQL Server is owned by Microsoft, and MySQL isowned by Oracle but targeted toward smaller companies and systems.  

2. What is the difference between SQL and PL/SQL?

SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result. PL/SQL stands for Procedural Language/Structured Query Language. It’s Oracle’s procedural language and is built on top of SQL. It allows for more programming logic to be used along with SQL.

3. What is the difference between SQL and T-SQL?

SQL is the language used to query databases. You run a query, such as SELECT or INSERT, and get a result. T-SQL stands for Transact-SQL and is a language and set of extensions for SQL Server that allows for further programming logic to be used with SQL.