Describe situations when you would use the MONTH and YEAR functions.

What will be an ideal response?

The MONTH function can be used to extract the months from dates to identify the most popular month for a catering service. The YEAR function can be used to extract years from dates that employees were hired to focus on just the year hired.

Computer Science & Information Technology

You might also like to view...

Suppose s1 and s2 are two strings. What is the result of the following code?

s1.equals(s2) == s2.equals(s1) a. true b. false

View
Computer Science & Information Technology

You can create many PivotTables per table or query in your Access database

Indicate whether the statement is true or false

View
Computer Science & Information Technology

Most text-based applications now offer the ability to generate text vertically.

Answer the following statement true (T) or false (F)

View
Computer Science & Information Technology

The following program uses function multiple to determine whether the integer entered from the keyboard is a multiple of some integer X. Examine function multiple, then determine the value of X.

``` // This program determines if a value is a multiple of X. #include using namespace std; bool multiple( int ); int main() { int y; cout << "Enter an integer between 1 and 32000: "; cin >> y; if ( multiple( y ) ) cout << y << " is a multiple of X" << endl; else cout << y << " is not a multiple of X" << endl; } // end main // determine if num is a multiple of X bool multiple( int num ) { bool mult = true; for ( int i = 0, mask = 1; i < 10; i++, mask <<= 1 ) if ( ( num & mask ) != 0 ) { mult = false; break; } // end if return mult; } // end function multiple ```

View
Computer Science & Information Technology