Question 1

The DatePart function always returns a number.

Accepted Answer

The DatePart function is used to extract a specific part (year, month, day, etc.) from a given date and always returns a number representing that part of the date. The DatePart function in SQL Server returns an integer value that represents the specified part of a date or time value. It always returns a number as a result.

Question 2

In the Round function, the precision cannot be a negative number.

Accepted Answer

The precision argument in the Round function specifies the number of digits after the decimal point. It cannot be negative, as it wouldn't make sense to round to a negative number of decimal places. The precision parameter in the Round function specifies the number of decimal places to round to, and it cannot be negative.

Question 3

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

Accepted Answer

The answer of Match the following results with the proper...

Question 4

Match the following DatePart arguments with the data they would return:
I. "yyyy"
II. "n"
III. "h"
IV. "m"
V. "w"
A. Minute
B. Month
C. Year
D. Day of the Week
E. Hour

Accepted Answer

The answer of Match the following DatePart arguments with the...

Question 5

Match the following terms with their descriptions:
I. Input mask
II. Lookup field
III. Lookup Wizard
IV. Parameter query
V. Input Mask Wizard
A. Predefined list of values presented in a menu
B. Criterion is provided when query is run
C. Took used to help create consistent formatting of data in a field
D. Helps create a list of predefined values
E. Setting that guarantees consistent formatting of data in a field

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 6

A parameter query is not a type of select query.

Accepted Answer

A parameter query is a type of select query that prompts the user to enter a parameter value. The query then uses that value to dynamically filter the results. A parameter query is a type of select query that prompts the user to provide a specific value or values as parameters when the query is run.

Question 7

Match the following types of data with the appropriate input masks:
I. Phone number
II. Long Time
III. Zip Code
IV. Short Time
V. Social Security Number
A. 00:00
B. 000-00-0000
C. 00000-9999
D. !(999) 000-0000
E. 99:00:00 >LL

Accepted Answer

The answer of Match the following types of data with...

Question 8

Match the following functions with when they would be used:
I. Date
II. DatePart
III. IIf
IV. Round
V. IsNull
A. When you need to use today's date
B. When you need to display a number to four decimal places
C. When you need to do one action if a condition is true and another if a condition is false
D. When you need to see if a field was skipped in data entry
E. When you need to use only the month within a date

Accepted Answer

The answer of Match the following functions with when they...

Question 9

Match the following terms with their descriptions:
I. Data validation
II. Validation text
III. Validation Rule
IV. Default value
V. Input Mask Wizard
A. Provides custom error message when incorrect data is entered
B. Value entered automatically when a record is created
C. A setting that limits what values can be entered in a field
D. Set of rules that help control the accuracy of data entry
E. Tool used to help create consistent formatting of data

Accepted Answer

The answer of Match the following terms with their descriptions:
I....

Question 10

Match the following results with the proper formulas:
I. January
II. Wednesday
III. December
IV. Saturday
V. 1
A. =MonthName(1)
B. =WeekdayName(4)
C. =MonthName(12)
D. =WeekdayName(7)
E. =DatePart("m",#01/16/1959#)

Accepted Answer

The answer of Match the following results with the proper...

Question 11

Match the following results with the proper DatePart formulas (assume a BirthDate of December 26, 1959 at 10:30 AM):
I. 1959
II. 12
III. 26
IV. 7
V. 10
A. =DatePart("h",[BirthDate])
B. =DatePart("w",[BirthDate])
C. =DatePart("d",[BirthDate])
D. =DatePart("m",[BirthDate])
E. =DatePart("yyyy",[BirthDate])

Accepted Answer

The answer of Match the following results with the proper...

Question 12

Reports cannot be based on parameter queries.

Accepted Answer

Reports can be based on parameter queries. Parameter queries allow users to define a criteria or input a value at runtime to filter the data displayed in the report. Reports can indeed be based on parameter queries. Parameter queries allow users to input specific criteria to refine the data displayed in the report.

Question 13

Match the following with where they are found:
I. Parameters
II. Run (a query)
III. Criteria (in a query)
IV. Input Mask
V. Validation Text
A. Table Tools tab; Design tab; Field Properties; Input Mask row
B. Query Tools tab; Design tab; Show/Hide group
C. Table Tools tab; Design tab; Field Properties; Validation Text row
D. Query Tools tab; Design tab; Criteria row
E. Query Tools tab; Design tab; Results group

Accepted Answer

The answer of Match the following with where they are...

Question 14

The Date function calculates the current date.

Accepted Answer

The Date function does calculate the current date. The Date function does indeed calculate the current date.

Question 15

Match the following terms with their descriptions:
i. Date function
II. Round function
III. DatePart function
IV. IIf function
v. IsNull function

Accepted Answer

A) IsNull function checks if a field has no value.  B) Date function calculates the current date.  C) Round function returns a number to a certain number of decimal places.  D) IIf function evaluates a comparison as true or false and takes appropriate action.  E) DatePart function examines a date and returns a portion of it.

Quiz 5: Data Validation and Data Analysis

The DatePart function always returns a number.

In the Round function, the precision cannot be a negative number.

Match the following results with the proper comparison operators: I. Does not equal 5000 II. Is less than 5000 III. Is less than or equal to 5000 IV. Is greater than 5000 V. Is greater than or equal to 5000 A. <5000 B. <=5000 C. >=5000 D. >5000 E. <>5000

Match the following DatePart arguments with the data they would return: I. "yyyy" II. "n" III. "h" IV. "m" V. "w" A. Minute B. Month C. Year D. Day of the Week E. Hour

A parameter query is not a type of select query.

Match the following types of data with the appropriate input masks: I. Phone number II. Long Time III. Zip Code IV. Short Time V. Social Security Number A. 00:00 B. 000-00-0000 C. 00000-9999 D. !(999) 000-0000 E. 99:00:00 >LL

Match the following results with the proper formulas: I. January II. Wednesday III. December IV. Saturday V. 1 A. =MonthName(1) B. =WeekdayName(4) C. =MonthName(12) D. =WeekdayName(7) E. =DatePart("m",#01/16/1959#)

Reports cannot be based on parameter queries.

The Date function calculates the current date.

Match the following terms with their descriptions: i. Date function II. Round function III. DatePart function IV. IIf function v. IsNull function