Database Concepts Quiz

For which of the following purpose(s) do databases need to be normalized? Provide example for 1, 2, 3 NF

Call types of constraints you know and description

What are Primary key, Foreign key?

Can we use UNIQUE constraint on several columns?

List the different types of relationship between tables

How to implement a many-to-many relationship?

What does the ACID mean? Define each property

Difference between TRUNCATE and DELETE and DROP

What is a difference between Table and View?

Difference between View and Materialized View