Database and SQL Plenary

What does the SQL keyword "SELECT" do?

• Deletes data from a table

• Updates existing data in a table

• Creates a new table

• Retrieves specific data from a table

Which SQL clause is used to filter records based on a condition?

• SELECT

• FROM

• WHERE

• AND

Which operator is used to combine multiple conditions in a WHERE clause?

• =

• >

• AND

• *

What does the wildcard (*) represent in an SQL query?

• It selects only the first column in a table

• It selects all columns in a table

• It filters records based on a condition

• It deletes all records in a table

What is the purpose of the SQL keyword "FROM"?

• Specifies the table to retrieve data from

• Filters records based on a condition

• Updates data in a table

• Deletes data from a table

Which SQL query will retrieve all fields for dogs older than or equal to 4 years from the "Dogs" table?

• SELECT * FROM Dogs WHERE Age > 4

• SELECT * FROM Dogs WHERE Age < 4

• SELECT * FROM Dogs WHERE Age >= 4

• SELECT * FROM Dogs WHERE Age = 4