Consider the PL/SQL package below that contains the universal constants.

CREATE OR REPLACE PACKAGE pkg_universal_constants
IS
  v_pi CONSTANT NUMBER(6,2) := 3.14;
  v_light_speed CONSTANT NUMBER(15,2) := 3*(10**8);
END;

Examine the below PL/SQL code to calculate the area of circle.

DECLARE
  v_radius NUMBER(10,2):=10;
  v_area   NUMBER(10,2);
BEGIN

  /* Calculate the area of circle using v_pi constant variable from pkg_universal_constants package*/
  
  DBMS_OUTPUT.PUT_LINE('Area of circle :'||v_area);
END;

Choose the appropriate code to calculate the area of circle.

 

 

To get all PLSQL Assessment Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee