MySQL Functions Quiz

What do functions CURRENT_DATE() and CURDATE() return in MYSQL?

• The current time

• The current date

• The current timestamp

• The day of the week

Which MYSQL function returns the time at which it executes?

• NOW()

• CURTIME()

• SYSDATE()

• CURRENT_TIME()

What is the purpose of the DAY(), MONTH(), and YEAR() functions in MYSQL?

• To modify date values

• To extract the day, month, and year from a date

• To add days, months, and years to a date

• To format a date

What does the DATE_ADD() function do in MYSQL?

• Adds a specified time interval to a date

• Calculates the difference between two dates

• Converts a string to a date

• Extracts the date from a timestamp

DATEDIFF() in MySQL is used to:

• Format a date

• Add days to date

• Find the difference in days between two dates

• Convert a date to a different time zone

What is the purpose of the STR_TO_DATE() function in MySQL?

• To format a date as a string

• To add time to a date

• To convert a string to a date

• To extract the month from a date

In MySQL, what is an application of DATE_FORMAT()?

• Adding intervals to a date

• Converting a date to a string in a specific format

• Extracting the day of the week from a date

• Calculating the difference in years between two dates

How can time zones be handled in MySQL?

• Using the TIME_ZONE() function

• By applying the CONVERT_TZ() function

• With the TIME_DIFFERENCE() function

• Through the DAYLIGHT_SAVINGS() function

What does the DAYOFWEEK() function return in MySQL?

• The day of the month

• The week of the year

• The day of the week

• The name of the weekday

The DATE_SUB() function in MySQL is used to:

• Subtract a specified time interval from a date

• Find the subtraction of two dates

• Convert a date to a substring

• Format a date by subtracting elements