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;

---

Definitions:

Assigned Right

A right that has been transferred from one party (the assignor) to another (the assignee), typically involving rights to receive payments or benefits.

Holder In Due Course

A person who has acquired a negotiable instrument in a legitimate manner and has rights to enforce it free of certain defenses.

Personal Defense

A legal argument or strategy used by an individual to justify actions taken or to protect oneself from criminal or civil liability.

Failure Of Consideration

occurs when the promised performance in a contract is not delivered, rendering the contract voidable or void.