Discover the power of technology and learning with TechyBuddy

Deselect Answer

Deselect Answer

DECLARE
 in_inventory INTEGER := 0;
 number_of_order INTEGER := 100;
BEGIN
 IF (in_inventory = 0) OR ((number_of_order / in_inventory) < 5) THEN
  DBMS_OUTPUT.PUT_LINE('Inventory quantity is zero or less than 5');
 ELSIF
  DBMS_OUTPUT.PUT_LINE('Enough inventory available');
 END IF;
END;Deselect Answer

DECLARE
 in_inventory INTEGER := 0;
 number_of_order INTEGER := 100;
BEGIN
 IF (in_inventory != 0) AND ((number_of_order / in_inventory) > 5) THEN
  DBMS_OUTPUT.PUT_LINE('Enough inventory available');
 ELSIF
  DBMS_OUTPUT.PUT_LINE('Inventory quantity is zero');
 END IF;
END;Deselect Answer

a.) SIMPLE_INTEGER is a predefined subtype of the PLS_INTEGER data type
b.) PLS_INTEGER is a predefined subtype of the SIMPLE_INTEGER data type
c.) SIMPLE_INTEGER has the same range as PLS_INTEGER
d.) SIMPLE_INTEGER do not has a NOT NULL constraint
e.) SIMPLE_INTEGER uses two's complement arithmetic and ignores overflowsDeselect Answer

BEGIN
   FOR i IN 1..3 LOOP
    IF i < 3 THEN
      DBMS_OUTPUT.PUT_LINE (TO_CHAR(i));
    END IF;
  END LOOP;
DBMS_OUTPUT.PUT_LINE (TO_CHAR(i));
END;
/Deselect Answer

a.) DECLARE "HELLO" varchar2(10) := 'hello'; BEGIN DBMS_Output.Put_Line("Hello"); END; 
b.) DECLARE "HELLO" varchar2(10) := 'hello'; BEGIN DBMS_Output.Put_Line(Hello); END; 
c.) DECLARE "BEGIN" varchar2(15) := 'Begin';  BEGIN DBMS_Output.Put_Line(BEGIN);  END;
d.) DECLARE "BEGIN" varchar2(15) := 'Begin';  BEGIN DBMS_Output.Put_Line("BEGIN");  END;Deselect Answer

p :=10;
q :=100;
r :='a';
s := Null;

a.) p > r is give TRUE
b.) s = Null is give FALSE
c.) p > s is give NULL
d.) p > r is give error
e.) q > p is give TRUEDeselect Answer

a.) In IF and ELSE statement, ELSE block is always executes irrespective of the IF blocks condition
b.) The IF statement either runs or skips a sequence of one or more statements, depending on a condition
c.) The CASE statement chooses from a sequence of conditions, and runs the corresponding statement
d.) Simple CASE form evaluates a single expression and compares it to several potential values
e.) Searched CASE form evaluates multiple conditions and chooses the first one that is trueDeselect Answer

Deselect Answer

Deselect Answer

a.) EXIT and CONTINUE can appear anywhere inside a loop, but not outside a loop
b.) EXIT and CONTINUE can appear anywhere inside a loop as well as outside a loop
c.) Both EXIT and CONTINUE can be used with additional WHEN clause to run on specific condition
d.) Only EXIT can be used with additional WHEN clause to run on specific condition
e.) Only CONTINUE can be used with additional WHEN clause to run on specific conditionDeselect Answer

BEGIN
   FOR i IN 1..3 LOOP
    IF i < 3 THEN
      DBMS_OUTPUT.PUT_LINE (TO_CHAR(i));
    ELSE
     i := 2;
    END IF;
  END LOOP;
END;
/Deselect Answer

Deselect Answer

a.) '0' through '9' are not equivalent to the integer literals 0 through 9

a.) PLS_INTEGER values require less storage
b.) NUMBER values require less storage
c.) PLS_INTEGER operations use hardware arithmetic, so they are faster than NUMBER operations, which use library arithmetic
d.) For calculations outside the PLS_INTEGER range, use INTEGER, a predefined subtype of the NUMBER data type
e.) A calculation with two PLS_INTEGER values that overflows the PLS_INTEGER range raises an overflow exceptionDeselect Answer

Deselect Answer

Deselect Answer

Deselect Answer

Deselect Answer

BEGIN
  FOR i IN REVERSE 1..3 LOOP
   IF i=i THEN
     DBMS_OUTPUT.PUT_LINE (i);
   END IF;
  END LOOP;
END;Deselect Answer

DECLARE
 a NUMBER := NULL;
 b NUMBER := NULL;
BEGIN
 IF a = b THEN
  DBMS_OUTPUT.PUT_LINE('a = b');
 ELSIF a != b THEN
  DBMS_OUTPUT.PUT_LINE('a != b');
 ELSE
  DBMS_OUTPUT.PUT_LINE('Can''t tell if two NULLs are equal');
 END IF;
END;Deselect Answer

Deselect Answer

<>
DECLARE
 p INTEGER :=10;
BEGIN
 DECLARE
  p INTEGER :=100;
 BEGIN
  DBMS_OUTPUT.PUT_LINE('Value of p=' || p);
 END;
 DBMS_OUTPUT.PUT_LINE('Value of p=' || p);
 DECLARE
  p INTEGER :=1000;
 BEGIN
  DBMS_OUTPUT.PUT_LINE('Value of p=' || outer.p);
  outer.p := p;
 END;
 DBMS_OUTPUT.PUT_LINE('Value of p=' || p);
END;Deselect Answer