Which of the following statement blocks correctly uses a scalar variable in an assignment statement?

A. DECLARE
  order NUMBER(2) :=  4;
  total_amt NUMBER(2);
BEGIN
  total_amt = 12;
END;

B. DECLARE
  order NUMBER(2) :=  4;
  total_amt NUMBER(2);
BEGIN
  total_amt := 12 * order;
END;

C. DECLARE
  order NUMBER(2) :=  4;
  total_amt NUMBER(2);
BEGIN
  order := total_amt *12;
END;

D. DECLARE
  order NUMBER(2) :=  4;
  total_amt NUMBER(2);
BEGIN
  total_amt := total_amt *12;
END;


Answer: B

Business

You might also like to view...

A potential business owner needs to convey his or her business idea to a prospective investor or lender in ________ minutes.

A. 10 B. 5 C. 2 D. 12

Business

During the maturity phase of the product life cycle, ________.

A. sales are low, typically with high failure rate B. sales grow at an increasing rate in comparison to the growth stage C. sales grow, but at a rate lower than the growth stage D. no growth in sales occurs E. long-run drop in sales takes place

Business

The Pension Protection Act of 2006 does not apply to all employers with pension plans

Indicate whether the statement is true or false

Business

Galley, Inc has a contract for operating the kitchen at the Palm Crest Hotel in Miami, Florida. Mealco has approached Palm Crest's director of operations and stated, "Look, sign with us. We'll take care of whatever damages you owe Galley." Mealco's statements: A) are defamatory

B) constitute the tort of contract interference. C) constitute the tort of negligence. D) None of the above

Business