Which of the following statements about built$-$in database functions is correct?

$1$ point

Built$-$in database functions must be called from a programming language like Python.

Built$-$in database functions may increase network bandwidth consumed.

Built$-$in database functions may increase processing time.

Built$-$in database functions reduce the amount of data that is retrieved.

$2.$

Question $2$

Which of the following SQL queries would return the day of the week each dog was rescued?

$1$ point

SELECT DAYOFWEEK$($RescueDate$)$ From PetRescue;

SELECT RescueDate From PetRescue WHERE Animal $=$Dog$$;

SELECT DAYOFWEEK$($RescueDate$)$ From PetRescue WHERE Animal $=$Dog$$;

SELECT DAY$($RescueDate$)$ From PetRescue WHERE Animal $=$Dog$$;

$3.$

Question $3$

What is the result of the following query: SELECT $($Current$\_$Date $$ RescueDate$)$ FROM PetRescue

$1$ point

Returns the current date and rescue date columns.

Returns today$$s date.

Returns the rescue date for each rescue.

Returns how long it has been since each rescue.

$4.$

Question $4$

Which of the following queries will return the employees who earn less than the average salary?

$1$ point

SELECT $*$ FROM Employees WHERE Salary $<$ AVG$($Salary$)$

SELECT $*$ FROM Employees WHERE Salary $<($SELECT AVG$($Salary$))$

SELECT AVG$($Salary$)$ FROM Employees WHERE Salary $<$ AVG$($Salary$)$

SELECT $*$ FROM Employees WHERE Salary $<($SELECT AVG$($Salary$)$ FROM Employees$)$;

$5.$

Question $5$

What are the three ways to work with multiple tables in the same query?

$1$ point

Sub$-$queries, APPEND, JOIN operators

Sub$-$queries, Implicit joins, normalization.

Built$-$in functions, implicit joins, JOIN operators

Sub$-$queries, Implicit joins, JOIN operators