88. Database - SQL Query Quiz

What is the purpose of SQL in a relational database?

• To search for data

• To create and delete records

• To modify and manipulate records

• All of the above

What does the SQL command 'select population from world where name equals Germany' do?

• None of the above

• Selects the population of Germany

• Selects the name of Germany

• Selects the entire world database

What does the SQL wildcard '%' represent?

• Any single character

• Any string of characters

• Any number

• None of the above

What is the purpose of the 'like' operator in SQL?

• To check for exact matches

• To check for partial matches

• None of the above

• To check for null values

What does the SQL command 'select * from world where name like 'A%' and population > 10000000 order by name' do?

• Selects all fields where name starts with 'A' and population is less than 10 million

• None of the above

• Selects all fields where name starts with 'A' and population is greater than 10 million

• Selects all fields where name starts with 'B' and population is greater than 10 million

What does the SQL command 'select name from world where population > (select population from world where name equals Algeria)' do?

• Selects the name of the country with the highest population

• Selects the name of the country with the lowest population

• None of the above

• Selects the name of the country with a population greater than Algeria

What is the purpose of using brackets in SQL queries?

• To group multiple conditions together

• None of the above

• To specify the order of operations

• To indicate the start and end of a query

What is the significance of the 'select star' (*) in SQL?

• None of the above

• It selects a random field from the table

• It selects only the first field from the table

• It selects all fields from the table

What is the purpose of the SQL command 'select name, population from world where name like 'A%' or name like 'B%''?

• Selects the name and population of countries starting with 'A' and ending with 'B'

• Selects the name and population of countries starting with 'A' or 'B'

• Selects the name and population of countries starting with 'A' and 'B'

• None of the above

What is the reading level of this quiz?

• College level

• Grade 12

• Grade 9

• Grade 6