Which command is used to back out a subset of database changes that have been made within a
unit of work?

An SQL function designed to convert temperatures from Fahrenheit to Celsius was created as follows:

How can this function be used to convert average temperature (AVG_TEMP) data stored in a table
called CLIMATE_INFO?

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

What will happen?

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees
and their associated revenue, even if no revenue exists. Which SQL statement will produce the
desired list?

Which two operations are allowed in the body of an SQL scalar user-defined function? (Choose
two.)

Which command will delete all rows from a table without generating log records?

Which function can be used to obtain values from XML documents that are to be inserted into one
or more tables?

User USER1 wants to retrieve records from a table named EMPLOYEE that satisfy at least one of
the following criteria:
The employee’s hire date (HIREDATE) is before 1999 and the employee’s salary (SALARY) is
less than $40,000.00 a year.
The employee has attended university
Which SQL statement will accomplish this?

If the following result set is desired:

Which SQL statement must be executed?

Which SQL statement will retrieve the employee number (EMPNO), hire date (HIREDATE), and
salary (SALARY) for each employee from a table named EMPLOYEE who was hired before 1998
and earns a salary of less than $35,000.00 per year?