5. Data Engineering

Databases — Quiz

Test your understanding of databases with 5 practice questions.

Read the lesson first

Practice Questions

Question 1

Which of the following best describes the primary difference between a relational database and a NoSQL database?

Question 2

Which of the following normal forms eliminates partial dependency in a relational database schema?

Question 3

Which of the following SQL queries would create an index on the 'last_name' column of a table named 'employees'?

Question 4

In a relational database, which type of join returns all rows from the left table and the matched rows from the right table, filling in NULLs for missing matches?

Question 5

Consider a table 'orders' with columns: order_id (primary key), customer_id, order_date, and total_amount. Which of the following best describes the concept of 'functional dependency' in this context?
Databases Quiz — Data Science | A-Warded