WorksheetsDatabase Query Basics Quiz
Total questions: 20
Worksheet time: 10mins
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
What does the AND operator do in a query?
Retrieves records that meet both conditions
Retrieves records that meet only one condition
Deletes all records in the table
Sorts records in descending order
Which query would find books written by "John Smith" before 2000?
WHERE Author="John Smith" OR YearPublished2000;
WHERE Author="John Smith" NOT YearPublished<2000;
A multi-table query helps in...
Summarizing data from a single table
Joining data from multiple related tables
Deleting multiple tables at once
Changing the structure of a table
In a parameter query, how do you ask the user to enter a grade?
WHERE Grade = [Enter Grade]
WHERE Grade = ?
WHERE Grade LIKE "*"
WHERE Grade IS NULL
What would WHERE Grade=9 AND Section="A"; return?
Only students in Grade 9
Only students in Section "A"
Students in Grade 9 and Section "A"
All students in the database
What does LIKE "*math*" return?
Only records that start with "math"
Only records that end with "math"
Records that contain "math" anywhere in the text
Records that contain only the word "math"
Which of these statements is TRUE about a wildcard query?
Wildcards work only with numbers
Wildcards replace specific characters in a text search
Wildcards cannot be used with LIKE statements
Wildcards can only be used in parameter queries
What is the result of LIKE "J*n"?
Words starting with "J" and ending with "n"
Words that only start with "J"
Words that only end with "n"
All words in the database
What is the main purpose of using multi-criteria in queries?
To filter data based on multiple conditions
To add new records to a database
To delete data from multiple tables
To create a new table
What does a parameter query do when executed?
It asks the user for input before running
It runs automatically without user input
It deletes records
It creates a new database
