Databases Reference
In-Depth Information
Review Questions
1.
Name the most important element of a relational database and its components.
2.
Which type of table relationship associates more than one record in a given
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?
4.
What are some reasons why using a spreadsheet is not a good alternative to
using a large-scale database?
5.
What are some of the benefits of abstraction in an object-relational database
management system?
6.
What object-relational feature of Oracle eases the transition between rela-
tional and object-relational applications?
7.
What are the three steps in the ERA process for database design?
8.
Name the three Oracle-compliant ANSI SQL standards.
9.
What is the difference between a relation and a relationship?
10.
Which type of relationship associates one row in a given table with one or no
rows in another table?
