View the Exhibit and examine the structure of the EMP table.

You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number. Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

View Exhibit 1 and examine the structure of the EMP table.

View Exhibit 2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

ORDER_TOTAL is a column in the orders table with the data type and size as number(8, 2) Examine the following code:

Which statement is correct about the above code?

Which statements are true about database triggers? (Choose all that apply.)