module 3

Multiple Choice

Which of the following best describes a relational database?

• A database that organizes data into tables related by common fields

• A database that stores data in a single file

• A database that only stores unstructured data

• A database that does not allow relationships between data

Open Ended

List and briefly explain two key characteristics of relational databases.

Fill in the Blanks

Fill in the blank: The

Manager in an RDBMS is responsible for handling database backups and recovery in case of failures.

Multiple Select

Which of the following are components of an RDBMS?

• Database Engine

• Query Processor

• Storage Manager

• Data Visualizer

Multiple Choice

Which of the following RDBMS systems is known for being lightweight and serverless, often used in mobile and desktop applications?

• MySQL

• Oracle Database

• SQLite

• Microsoft SQL Server

Open Ended

Explain how RDBMS systems ensure data reliability and consistency, even in the event of system failures.

Multiple Choice

Which SQL command is used to create a relationship between the 'Orders' and 'Customers' tables in the provided schema?

• PRIMARY KEY

• FOREIGN KEY

• UNIQUE

• CHECK

Open Ended

Explain how normalization helps in reducing data redundancy and improving data integrity in a database.

Multiple Choice

Which of the following normal forms specifically addresses multi-valued dependencies?

• First Normal Form (1NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

• Fifth Normal Form (5NF)

Multiple Choice

Which SQL statement would you use to retrieve the first and last names of customers who live in 'New York'?

• SELECT * FROM Customers WHERE City = 'New York';

• SELECT FirstName, LastName FROM Customers WHERE City = 'New York';

• SELECT FirstName, LastName FROM Customers;

• SELECT City FROM Customers WHERE FirstName = 'New York';

Fill in the Blanks

Fill in the blank: The

statement is used to retrieve data from one or more tables in a database.

Multiple Choice

Which SQL clause is used to filter groups after aggregation in the provided example?

• WHERE

• HAVING

• GROUP BY

• ORDER BY

Open Ended

Explain the difference between using a JOIN and a SUBQUERY in SQL, as shown in the examples.

Multiple Choice

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

• FROM
• WHERE
• SELECT
• ORDER BY

Multiple Choice

Which of the following statements about window functions is correct?

• They filter rows based on a condition.

• They combine data from multiple tables.

• They perform calculations across a set of rows related to the current row.

• They insert new records into a table.

Fill in the Blanks

Fill in the blank: The INSERT statement is used to add new

to a table.

Multiple Choice

Which word is missing from the following SQL statement?

Select * table_name

• With

• Where

• From

• And

Multiple Select

Which of the following are valid ways to insert data into a table as shown in the examples?

• Insert a single record

• Insert multiple records

• Insert data from another table

• Insert using a DELETE statement

Open Ended

Reflecting on the learning objectives, which area of SQL or relational databases would you like to explore further or need more clarification on?

Multiple Choice

Which of the following is NOT a learning objective for this module on SQL fundamentals?

• Identify and describe the basic components of SQL

• Construct and execute fundamental SQL queries

• Create relational database tables with appropriate data types

• Design a web application interface