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?