SQL Quiz

Jackson, Austin, and London are part of the sales team at a retail company. They are tasked with analyzing the company's sales data to identify trends and patterns. They need to extract specific data from the company's database. Which SQL command should they use to perform this task?

• a. SELECT

• b. INSERT

• c. UPDATE

• d. DELETE

Paige and Alex are working on a project for their database class. They need to add new data about students Nyhila, Falyn, and Vincent into their project's table. Which SQL command should they use to accomplish this task?

• a. SELECT

• b. INSERT

• c. UPDATE

• d. DELETE

James and Grant are working on a project to create a database for their school's library. They need to modify the existing data in one of the tables. Which SQL command should they use?

• a. SELECT

• b. INSERT

• c. UPDATE

• d. DELETE

Wilson is working on a project where he needs to remove a specific row of data from a table in his database. He asked for Kevin's help. Which SQL command should Kevin suggest to Wilson to accomplish this task?

• a. SELECT

• b. INSERT

• c. UPDATE

• d. DELETE

Grace and Ethan are working on a school project where they need to extract all the data from the 'StudentRecords' table in their school's database. Which SQL command should they use?

• a. SELECT *

• b. SELECT (All)

• c. SELECT ALL

• d. SELECT COLUMNS

Nyhila and Grant are working on a project for their database class. They need to extract specific data from a table based on a certain condition. Which SQL command should they use in the WHERE clause for this purpose?

• a. WHERE

• b. FILTER

• c. HAVING

• d. CONDITION

Chloe and Kevin are working on a school project where they need to organize a list of student names in alphabetical order. They are using a SQL database for this task. Which SQL command should they use to order the result set in ascending order?

• a. ASC

• b. SORT

• c. ORDER BY ASC

• d. DESC

London and Vincent are working on a project for their computer science class at school. They are developing a database for a local library to keep track of books and borrowers. They need to combine data from the 'Books' table and the 'Borrowers' table based on a common column. Which SQL command should they use to achieve this?

• a. CONNECT

• b. JOIN

• c. LINK

• d. COMBINE

Priya is a teacher at a school and she wants to find out the unique names of her students from a 'student_names' column in her SQL database. The students in her class are Price, Jackson, Gannon, Grant, and Wilson. Which SQL command should she use to retrieve the distinct student names?

• a. UNIQUE

• b. DISTINCT

• c. DIFFERENT

• d. SEPARATE

Austin, Chloe, and Gannon are working on a project to analyze the salary distribution of their company's employees. They want to calculate the average salary. Which SQL command should they use?

• a. AVG

• b. AVERAGE

• c. MEAN

• d. AVG()