ooo Sprint 1:10 PM Advanced Review Questions Review the following DECLARE sectio

Question

ooo Sprint 1:10 PM Advanced Review Questions Review the following DECLARE section ree ent type-ree type rec id b ree one id d type rec rec dida 2. the following DECLARE section, what type of variable is v Junk? a scalar table of records What must you do to an URDATR statement to include it in a a You must use a b The statement must contain c An UPDATE can't be included d No change is necessary. 4. In the following DECLARE section, the JOBS table contains tbl-jobs type d tbl jobs .title. 2 5. What's used when creating a data type tor a list of columns Pg 118 48% 6 pages left

Explanation / Answer

1)

Answer B) rec_one.id

rec_one is the variable of type "type_rec" .

2)

Answer c) Associative array

3)

Answer d) No change is necessary

4)

Answer a) tbl_jobs(2).title

Members in an associative array can be referenced by key values (Here, key = 2).

5)

Answer b) %ROWTYPE

"ROWTYPE" keyword when associated with a table name, gives the record type of that table.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.