Identify the vocabulary word for each definition below

This preview shows page 1 - 3 out of 5 pages.

Database Programming with PL/SQL 5-2: Indexing Tables of Records Practice Yashub Armando Guzman Espinoza 1630123 Activities Vocabulary Identify the vocabulary word for each definition below. Collection A set of occurrences of the same kind of data INDEX BY table A collection which is based on a single field or column; for example, on the last_name column of EMPLOYEES INDEX BY table of records A collection which is based on a composite record type; for example, on the whole DEPARTMENTS row Try It / Solve It 1. PL/SQL collections: A. In your own words, describe what a PL/SQL collection is.
B. Which of the following are collections and which are not?
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
2 C. What is the difference between an INDEX BY table and a database table such as EMPLOYEES or COUNTRIES?
Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture