Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00
from a table named EMPLOYEE?

Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY)
for each job code (JOB), sorted by job code, from a table named EMPLOYEE?

If a table named MY_TAB contains 100 rows and the following statement is executed:

How many rows will be updated?

An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

Which type of stored procedure is not associated with an external application program?

Which statement about system-period temporal tables is true?

A table named DEPARTMENT contains the following data:

What will happen?

Which statement about UPDATE processing is FALSE?

Given the following statements:

What will be the result?

A table named STATES has the following columns: STATE_CD, REGION_CD, and
STATE_NAME. Which SQL statement will return the number of states in each region, ordered by
number of states?