Which of the Following Code Fragments Correctly Uses a Record

question 39

Multiple Choice

Which of the following code fragments correctly uses a record variable to hold the row of data queried for a shopper?

• A) DECLARE
• Rec_shopper bb_shopper%ROWTYPE;
• BEGIN
• SELECT*
• INTO rec_shopper
• FROM bb_shopper
• WHERE idshopper = :g_shopper;
• DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
• END;
• B) DECLARE
• Rec_shopper bb_shopper%ROW;
• BEGIN
• SELECT*
• INTO rec_shopper
• FROM bb_shopper
• WHERE idshopper = :g_shopper;
• DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
• END;
• C) DECLARE
• Rec_shopper bb_shopper%TYPE;
• BEGIN
• SELECT*
• INTO rec_shopper
• FROM bb_shopper
• WHERE idshopper = :g_shopper;
• DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
• DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
• END;
• D) DECLARE
• Rec_shopper bb_shopperROWTYPE;
• BEGIN
• SELECT*
• INTO rec_shopper
• FROM bb_shopper;
• WHERE idshopper = :g_shopper;
• END;

Understand the equity section of the balance sheet and the presentation of common and preferred stock.

Understand and identify different types of equity financing transactions.

Learn how to record transactions involving the issuance of common stock.

Gain knowledge on the concept and accounting treatment of stock subscriptions.

---

Definitions:

Embryonic Period

A crucial stage of human development that occurs in the first 8 weeks after fertilization, during which vital organs and structures begin to form.

Conception

The process of a sperm fertilizing an ovum, resulting in the beginning of a pregnancy.

Age Of Viability

The age at which the fetus may survive if born prematurely; begins about 22 weeks after conception.

Neonatal Nurse

A nurse specializing in the care of newborn babies, particularly the ill or premature, during the first month of life.