Database Query Basics Quiz

What is a parameter query?

• A query that retrieves all records in a table

• A query that prompts the user for input when it runs

• A query that deletes records from a database

• A query that only works with one table

What symbol is used for a wildcard character in a query?

• @

• *

• #

• &

Which of the following is an example of a wildcard search?

• LIKE "J*"

• = "James"

• > 2000

• SUM(Amount)

A multi-table query is used to...

• Retrieve data from multiple tables using relationships

• Delete all records in a table

• Sort records in ascending order

• Create a new table from an existing one

What does the SQL statement SELECT * FROM Books WHERE Title LIKE "A*"; do?

• Selects all books with titles that start with "A"

• Deletes all books with titles that start with "A"

• Selects all books published in the year "A"

• Displays only books whose title contains "A"

A query that asks the user to input a value before running is called a...

• Wildcard query

• Parameter query

• Append query

• Multi-table query

What does LIKE "?istory" return?

• Only the word "history"

• Any word ending with "istory" but with any first letter

• Only the word "mystory"

• An error message

A multi-table query requires...

• Only one table

• A relationship between tables

• A parameter value

• A delete operation

In a query, which of the following retrieves all students whose first name starts with "S"?

• WHERE FirstName = "S"

• WHERE FirstName LIKE "S*"

• WHERE FirstName LIKE "*S"

• WHERE FirstName = "*S*"

Which of these criteria is used in a multi-criteria query?

• AND

• OR

• NOT

• All of the above