Database Basics Quiz

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Standard Query Language

• Sequential Query Language

Which SQL command is used to retrieve data from a database?

• INSERT

• UPDATE

• SELECT

• DELETE

In SQL, which keyword is used to sort the result-set?

• ORDER BY

• SORT BY

• ARRANGE BY

• GROUP BY

Which SQL statement is used to update data in a database?

• MODIFY

• UPDATE

• CHANGE

• SET

What is the purpose of the SQL WHERE clause?

• To specify the columns to be displayed

• To filter records

• To group records

• To sort records

Which of the following is a valid SQL data type?

• INTEGER

• NUMBER

• DIGIT

• TEXTUAL

In database management, what does ACID stand for?

• Atomicity, Consistency, Isolation, Durability

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Integration, Durability

• Atomicity, Consistency, Isolation, Dependability

Which Google Sheets formula would you use to add up a range of cells?

• =SUM(A1:A10)

• =ADD(A1:A10)

• =TOTAL(A1:A10)

• =COMBINE(A1:A10)

What does the Google Sheets formula =AVERAGE(A1:A10) do?

• Finds the sum of the values in cells A1 to A10

• Finds the average of the values in cells A1 to A10

• Finds the median of the values in cells A1 to A10

• Finds the mode of the values in cells A1 to A10

Which function in Google Sheets would you use to count the number of cells that contain numbers?

• =COUNTIF

• =COUNTA

• =COUNT

• =COUNTNUM