SQL Interview Questions - Quiz

Introduction

This quiz contains questions on topics you can expect to see in an interview pertaining to SQL and Relational Databases. Some of them are multiple choice, while some are short answer. For these short answer questions, double click on the Jupyter Notebook and type your answer below the line.

Question 1

What are the 4 main datatypes in SQLite3? Can we use other common types from other kinds of SQL?

Type your answer below this line:

---

Question 2

Explain the relationship between Primary Keys and Foreign Keys.

Type your answer below this line:

---

Question 3

Explain the different types of relationships entities can have in a SQL database.

Type your answer below this line:

---

Question 4

Explain the various types of JOINs possible with SQL.

Type your answer below this line:

---

Question 5

Explain the relationship between Aggregate functions and GROUP BY statements.

Type your answer below this line:

---

Question 6

What role do Associative Entities play (JOIN Tables) in many-to-many JOINs?

Type your answer below this line:

---

Summary

In this lesson, we practiced answering open-ended interview questions for SQL and Relational Databases.