Database Sorting and Filtering Quiz

What does sorting data in a database mean?

• Changing the content of the data

• Arranging the data in a specific order, such as from smallest to largest

• Deleting some of the data

• Grouping data based on categories

Which of the following is an example of sorting data?

• Showing only customers from New York

• Organizing a list of names from A to Z

• Removing duplicate entries from the data

• Adding a new record to a database

What does filtering data in a database mean?

• Changing the order of the data

• Organizing data into categories

• Hiding data that does not meet certain criteria

• Sorting the data from smallest to largest

Which of these actions would be considered filtering?

• Sorting a list of items by their price

• Showing only records where the 'Age' is greater than 18

• Arranging a list of students alphabetically

• Grouping all records by city

Which of the following can you filter by?

• A number greater than 50

• All items in a list

• A record's position in the table

• The color of the text

True or False: Sorting data can only be done in ascending order (from smallest to largest).

• True

• False

True or False: Filtering allows you to display only the records that meet specific conditions, such as values greater than a certain number.

• True

• False

True or False: You can filter data to show only certain categories, such as 'Red' or 'Blue' items in a list of products.

• True

• False

True or False: Sorting and filtering are the same thing-they both change the way data is displayed, but don't affect the actual data.

• True

• False

True or False: Sorting can be done alphabetically, by numbers, or by dates.

• True

• False