Multiple choice technology databases

The PROCEDURE_ADD_PRODUCT is defined within a package specifications as follows: PROCEDURE_ADD_PRODUCT (P_PRODNO NUMBER,P_PRODNAME VARCHER2); Which procedure declaration can’t be added to package specifications?

  1. a) PROCEDURE add_product (p_order_date DATE);

  2. b) PROCEDURE add_product (p_name VARCHER2, P_ORDERED DATE);

  3. c) PROCEDURE add_product (p_prodname VARCHER2, P_PRISE NUMBER);

  4. d) PROCEDURE add_product (p_prize NUMBER, P_DESCRIPTION VARCHER2);
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In package specifications, procedure overloading is allowed only if parameter data types differ. Option D conflicts with the existing PROCEDURE_ADD_PRODUCT(P_PRODNO NUMBER, P_PRODNAME VARCHAR2) because both parameters are NUMBER - this would cause ambiguity. The other options are valid due to different data type combinations (DATE, VARCHAR2+DATE, VARCHAR2+NUMBER). Note: VARCHER2 is a typo for VARCHAR2 but present in all options.

Keep practicing — related questions