1. Which operator signifies exponentiation? # * / ^ 2. In the query above, the c
ID: 3555979 • Letter: 1
Question
1. Which operator signifies exponentiation?
#
*
/
^
2. In the query above, the criteria in the TourStartDate column would be considered OR criteria.
True
False
3. In the figure above, item 3 points to the ____.
field from the Payments table
field from the Tours table
Payments field list
Sales field list
3. Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.
True
False
4. OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.
True
False
5. If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.
True
False
6. Which function would you use to calculate today's current date?
CURRENT
DATE
YEAR
DAY
7. In the query above, the criteria in the first row would be considered AND criteria.
True
False
8. The operator > means ____.
Less than
Not equal to
Greater than
Null
9. An SQL statement determines what fields are selected after the ____ keyword.
SELECT
FROM
ORDER BY
LIST
Explanation / Answer
1. Which operator signifies exponentiation?
#
*
/
^
2. In the query above, the criteria in the TourStartDate column would be considered OR criteria.
True
False
3. In the figure above, item 3 points to the ____.
field from the Payments table
field from the Tours table
Payments field list
Sales field list
3. Changes you make to PivotChart View are automatically reflected in PivotTable View and vice versa.
True
False
4. OR queries narrow the number of records that will appear in the datasheet because a record must be true for all criteria.
True
False
5. If you change a customer name from "Miller" to "Millen" in a query's datasheet, you will need to make the update in any other query that also displays this customer's name.
True
False
6. Which function would you use to calculate today's current date?
CURRENT
DATE
YEAR
DAY
7. In the query above, the criteria in the first row would be considered AND criteria.
True
False
8. The operator > means ____.
Less than
Not equal to
Greater than
Null
9. An SQL statement determines what fields are selected after the ____ keyword.
SELECT
FROM
ORDER BY
LIST
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.