The ________ function counts the cells containing numbers in the column of records that match the conditions you specify

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

1) A procedure does not require a RETURN type, but a function does. 2) Control of execution shifts from a function to the calling program with the RETURN statement. 3) All public procedures and functions in a package body must be declared in the package specification. 4) A trigger is fired before or after a triggering event. 5) A trigger based on a SELECT statement always fires automatically after statement’s execution.

Identify the most time-consuming function in the program you profiled in Problem 5. Do you think that this function is a bottleneck in your program? Why, or why not?

What will be an ideal response?