Interview Questions - Microsoft SQL Server, Oracle SQL Server

SQL Interview Questions for revision
What is SQL?
Syntax to create a table in SQL
What are DDL commands? Create, Alter, Drop commands
What are DML commands? Select, Insert, Update, Delete
Syntax to create a database
Explain the ACID rules of transaction
What is the Dual table in Oracle?
What is NULL in SQL
What is a Join? Inner, Outer, Left, Right, Full, Cartesian, Natural, Equi
What is the difference between a table, view and a synonym?
How to run a stored procedure in SQL?
Write the syntax to create a function in SQL
What is a Stored Procedure in SQL?
Write the syntax to create a stored procedure in SQL?
What is the main difference between a function and stored procedure in SQL?