What is a view? When would you use one?

What’s the difference between a view and a materialized view?

What is a primary key?

What is a foreign key?

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

What is a composite key?

What is the difference between SQL and PL/SQL?

What is a surrogate key?

What is the difference between SQL and T-SQL?

What is a unique constraint? How is it different from a primary key?