A.1. Chapter 1

  1. Name the most important element of a relational database and its components.

    Answer: The table is the most important element of a relational database and it consists of rows and columns. A field exists at the intersection of a row and a column.

  2. Which type of table relationship associates more than one record in a given table with more than one record in another table?

    Answer: A many-to-many relationship associates more than one record in a table with more than one record in another table.

  3. What type of key can be used to enforce referential integrity between two tables in a database?

    Answer: A foreign key can be used to enforce referential integrity between two tables.

  4. What are some reasons why using a spreadsheet is not a good alternative ...

Get Oracle Database Foundations now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.