If a table contains duplicate rows, will a query display duplicate values by default? How can you eliminate duplicate rows from a query result?

What is a synonym?

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

What is a surrogate key?

What is a composite key?

What is a foreign key?

What is a primary key?

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

What is a view? When would you use one?

What is the purpose of the IN keyword?