100/50

What is a relational database primarily designed for?

• Storing data in a single table with minimal structure

• Managing only small applications

• Eliminating the need for data queries

• Organizing data into multiple tables with defined relationships

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

• Excel

• Google Sheets

• JSON

• MySQL

What does SQL stand for?

• Simple Query Language

• Sequential Logic Queries

• Server Query Language

• Structured Query Language

What is the purpose of a "foreign key" in relational databases?

• Unique identification of records in a table

• Storing large text data

• Setting permissions for data access

• Establishing relationships between tables

What is a common file format for flat databases?

• SQL

• JSON

• XML

• CSV

What is the characteristic of a relational database?

• Data is unstructured and stored in a single file

• Data cannot be queried or modified

• Data cannot be linked between tables

• Data is organized into tables with rows and columns

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

• SELECT

• DELETE

• INSERT

• UPDATE

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

• Integer

• Text

• Date

• Boolean

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

• It stores data in a single, human-readable file

• Requires minimal setup and maintenance

• Avoids the use of structured formats

• It supports relationships, large datasets, and complex queries

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

• Filtering data based on conditions

• Deleting specific records from the table

• Sorting data in ascending order

• To aggregate data based on specific columns