A Guide to SQL Study Set 2

Computing

Quiz 4 :

Single Table Queries

Quiz 4 :

Single Table Queries

Question Type
search
arrow
Preceding a condition with which SQL operator reverses the truth of the original condition?
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
Which operator is inclusive, meaning that a query selects a value equal to either value in the condition along with those in the range of the values?
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
The GROUP BY clause sorts the data in a particular order.
Free
True False
Answer:

Answer:

False

Tags
Choose question tag
close menu
arrow
Which function calculates a total of the values in a column?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which operator uses one or more wildcard characters to test for a pattern match?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following operators can be used for a column computation?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
All SELECT statements require a WHERE clause.
True False
Answer:
Tags
Choose question tag
close menu
arrow
When you need to sort data on two columns, the less important column is called the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
It is possible to place one query inside another.
True False
Answer:
Tags
Choose question tag
close menu
arrow
The basic form of the SQL SELECT command is _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In MySQL, you can use an asterisk (*) to represent any column when using the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What clause can you use to list data in a specific order?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement.
True False
Answer:
Tags
Choose question tag
close menu
arrow
The only arithmetic operators that can be used in SELECT statements are + for addition and - for subtraction.
True False
Answer:
Tags
Choose question tag
close menu
arrow
Which function determines the number of rows in a table?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In the SELECT clause, you can indicate that you want to include all columns using the _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which clause lets you group data on a particular column?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What SQL command do you use to query a database?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Mallory would like to display the rows from a MySQL table that have "Red," "Pink," or "White" in the COLOR column. A concise way of writing her query would be to use a(n) _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
You form compound conditions by connecting two or more simple conditions using _____.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 35