Relational Databases and Multimedia Quiz

What is a relational database primarily designed for?

• Organizing data into multiple tables with defined relationships

• Storing data in a single table with minimal structure

• Managing only small-scale applications

• Eliminating the need for data querying

Which of these is an example of a relational database management system (RDBMS)?

• MySQL

• Excel

• Google Sheets

• JSON

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Sequential Query Logic

• Server Query Language

In relational databases, what is a 'foreign key' used for?

• Establishing relationships between tables

• Uniquely identifying records within a table

• Storing large text data

• Setting permissions for data access

What is a common file format for flat file databases?

• CSV

• SQL

• JSON

• XML

Which of the following is a characteristic of a relational database?

• Data is organized into tables with rows and columns

• Data is unstructured and stored in a single file

• Data cannot be queried or manipulated

• Data cannot be related across tables

Which SQL command is used to modify existing records in a table?

• UPDATE

• SELECT

• DELETE

• INSERT

What kind of data type is best for storing true or false values?

• Boolean

• Integer

• Text

• Date

Why is a relational database often preferred over a flat file for complex applications?

• It supports relationships, large datasets, and complex queries

• It stores data in a single, easy-to-read file

• It requires minimal setup and maintenance

• It avoids the use of structured formats

In SQL, what is the purpose of the GROUP BY clause?

• To aggregate data based on specific columns

• To filter data based on conditions

• To delete specific records from a table

• To sort data in ascending order